Failed to generate script from Azure SQL

Question

I would like to generate an Azure SQL database script after connecting to sql server R2, but it gives me an error when I do this.

> TITLE: Microsoft SQL Server Management Studio

Script failed to start myserver server. (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:

An attempt to retrieve data for an object failed for 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

---

The index was outside the array. (Microsoft.SqlServer.Smo)

I am generating a script, as usual, using the sql server database.

Are there any special ways to generate scripts? My goal is to back up the Azure SQL database to the Sql server database. Please can someone help me deal with this problem?

Thanks Arun.

Answer 1

Redgate SQL Azure , !

Answer 2

Service Pack 1 SQL Server 2008 R2 .

Denali CTP1, , 5.

Answer 3

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

Gl