无法从SQL Azure生成脚本 [英] Could not generate script from SQL Azure

问题描述

我想在连接到sql server R2之后生成SQL Azure数据库的脚本，但是当我这样做时它会给我错误.

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.

>标题:Microsoft SQL Server Management Studio

服务器"myserver"的脚本失败. (Microsoft.SqlServer.Smo)

> 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:

尝试为服务器"myserver"检索对象的数据失败. (Microsoft.SqlServer.Smo)

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

索引超出了数组的范围. (Microsoft.SqlServer.Smo)

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

我像生成sql server数据库一样照常生成脚本.

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

是否有生成脚本的特殊方法?我的目标是将SQL Azure数据库备份到Sql Server数据库.请谁能帮我解决这个问题?

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?

谢谢 阿伦.

推荐答案

我使用了 Redgate SQL Azure备份工具，它确实可以完美备份！

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

这篇关于无法从SQL Azure生成脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！