1
Vote

Errors On Migrate From Azure

description

Multiple errors Creating Script from Azure (Schema only To start)
 
[dbo].[aspnet_AnyDataInTables] not scripted --> Property TextHeader is not available for StoredProcedure '[dbo].[aspnet_AnyDataInTables]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.
 
 
also
 
 
Property Text is not available for DefaultConstraint '[DF__ASPStateT__Creat__58E67080]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
 
 
I have a feeling i need to make a change in the NotSupportedByAzureFile.Config but I think that is looking the wrong way

comments

ghuey wrote Feb 1, 2011 at 11:06 PM

Hmmmm, these are not errors that get generated by SQLAzureMW, but by SQL Server Management Object. It looks like a privilege issue. Are you going from SQL Server to SQL Azure? Or SQL Azure to SQL Server? One thing that you can try is using SQL Server Management Studio (SSMS) and try Generate Scripts and see if you get the same error. If SSMS works, I would love to debug this issue with you. We can trouble shoot this offline if you want. Just contact me via codeplex.