Red Gate forums :: View topic - Order of components of generated script is not preserved
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Order of components of generated script is not preserved

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Taras B



Joined: 01 Jun 2013
Posts: 3

PostPosted: Tue Aug 13, 2013 4:36 pm    Post subject: Order of components of generated script is not preserved Reply with quote

We are generating rollout scripts with SQLCompare command line tool. Being able to compare generated script between 2 builds will be very useful to understand changes, but this is rather impossible due to heavy re-ordering of the components of the rollout script. Is there any way to ensure certain ordering of the entries (e.g. dependency driven + alphabetic)?

Thanks
Taras
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Fri Aug 16, 2013 10:28 am    Post subject: Reply with quote

Hi Taras,

SQL Compare works out the dependency matrix and that determines the order of the script generation. If the database changes, the order in which objects are created or altered could be vastly different.

SQL Compare can output a report in HTML format that can show the changes, if that is of any use.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group