Bug? - Synch Script Creation with Circular References
randyminder@yahoo.com
Posts: 30
We have a database with 3300 objects. These objects are stored as Red-Gate script files. We have a circular reference in our schema where view 'A' is dependent on UDF 'B' and UDF 'B' is dependent on view 'A'.
When I create a blank database and do a compare where the source is the script files and the target is the database, the synch script file that SQL Compare creates always attempts to create the view before the UDF. Of course SQL Server 2005 doesn't like that. However, SQL Server will permit the UDF to be created before the view. Why isn't SQL Compare smart enough to know to create the UDF first and then the view?
Thanks - Randy
When I create a blank database and do a compare where the source is the script files and the target is the database, the synch script file that SQL Compare creates always attempts to create the view before the UDF. Of course SQL Server 2005 doesn't like that. However, SQL Server will permit the UDF to be created before the view. Why isn't SQL Compare smart enough to know to create the UDF first and then the view?
Thanks - Randy
Comments
I've added this forum topic to the bug report about this behaviour, but it's quite difficult to fix this without breaking other aspects of the dependancy tracking code - I suspect this problem won't get fixed for a while.
Redgate Software