我试图生成一个数据库中的所有数据的脚本,所以我可以将数据移动到另一个服务器上的相同的数据库.在SQL Server 2012中,我右键单击源数据库
任务>生成脚本>脚本整个数据库和所有数据库对象>高级>数据类型到脚本：仅数据
这给我一个关于循环依赖的错误.如果我将数据类型更改为脚本到模式和数据,它会生成罚款.如何解决这个问题呢？
Action Result Getting a list
of objects from MyDatabase Failed
Detailed report:
Microsoft.SqlServer.Management.SqlScriptPublish.SqlScriptPublishException:
An error occurred while scripting the objects. —>
Microsoft.SqlServer.Management.Smo.SmoException: Cyclic dependencies
found. at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.DependencyGraphTraversal(Int32
num,Dictionary2 dictionary,List1 sortedList,HashSet1 visited,
HashSet1 current) at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.DependencyGraphTraversal(Int32
num,
HashSet1 current) at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.SortDictionary(Dictionary2
dictionary) at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.SortDataSet(DataSet
ds) at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.SortDataSet(List1
objectList,Dictionary2 idDictionary,DataSet ds) at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.ExecuteQueryUsingTempTable(List1
objectList,List1 list,String query) at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.ResolveTableOnlyDependencies()
at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.ResolveDependencies()
at
Microsoft.SqlServer.Management.Smo.SmoDependencyOrderer.Order(IEnumerable1
urns) at
Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable1
urns) at
Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List1
urns,ISmoScriptWriter writer) at
Microsoft.SqlServer.Management.Smo.ScriptMaker.Script(Urn[] urns,
ISmoScriptWriter writer) at
Microsoft.SqlServer.Management.SqlScriptPublish.SqlScriptGenerator.DoScript(ScriptOutputOptions
outputOptions) — End of inner exception stack trace — at
Microsoft.SqlServer.Management.SqlScriptPublish.GeneratePublishPage.worker_DoWork(Object
sender,DoWorkEventArgs e) at
System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at
System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object
argument)
我有同样的确切错误…看到我的答案在这里：
http://mattslay.com/ssms-generate-scripts-data-only-cyclic-dependencies-found-error/
Then,on a whim,knowing that I had successfully scripted this database before,I connected to the Sql Server 2012 instance using Sql Server Management 2008 R2,and I was able to generated the scripts without error!!
Note,that I did data-only,and I had to allow it to script all database objects. I tried to select only certain tables,but that gave some other errors that I wasn’t willing to track down,so I just did the whole thing.
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
