Could not generate script from SQL Azure

Question

I would like to generate script of SQL Azure database after connecting to sql server R2 but it gives me error when i will do that.

> TITLE: Microsoft SQL Server Management Studio

Script failed for Server 'myserver'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Script+Server&LinkId=20476

------------------------------ ADDITIONAL INFORMATION:

Attempt to retrieve data for object failed for Server 'myserver'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attempt+to+retrieve+data+for+object+Server&LinkId=20476

---

Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)

I am generating script as usual as we do with sql server database.

Is there any special ways to generate scripts? My goal is to take backup of SQL Azure database to Sql server database. Please any one can help me to sort out this issue?

Thanks Arun.

Answer 1

Installing the Service Pack 1 for SQL Server 2008 R2 helped for me.

There is a similar problem with Denali CTP1, which suggests that this is fixed in Cumulative Update 5.

Answer 2

I would use the sql migration wizard from codeplex http://sqlazuremw.codeplex.com/

Gl

Answer 3

I have used Redgate SQL Azure backup tool and it did backup perfectly!