You might come across the problem while generate the script using Data only option in SQL Server 2008 R2 – SSMS.
The Error message appears normally as follow:
Microsoft.SqlServer.Management.SqlScriptingEngine.CyclicalForeignKeyException: The selected database contains foreign keys that create a cycle. Publishing data only is not supported for databases with cyclical foreign key relationships. 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)
Solution: Use the SQL SERVER 2012 –SSMS.
Cheers!
