Incorrect order of objects when comparing backup to live DB

sergeserge Posts: 2
edited June 22, 2010 10:58PM in SQL Compare Previous Versions
I'm creating a new database by comparing a backup to a brand new database with no objects. What I noticed when you compare 2 databases using SQL Compare 8.1 it generates all objects that do not exist in the target database correct - views that depends on other tables are created at the end of the script.

But when I compare backup to a live database it generates a script where views created before tables they actually refer to.

So I assume this is a bug related to database backups only?
· Share on Twitter
Sign In or Register to comment.