Synchronisation script order incorrect
We are having problems (sometimes) with the synchronisation script generated by SQL Compare. We have some stored procedures that select data from views.
These are all created by our codegen process and when we want to sync these into our main dev database the synchronisation script is sometimes created in the wrong order in that it wants to create the stored procedure before the view it relies on has been created.
Its a quick fix to just reorder the items in the script file but a real pain in our automated build environment.
Anybody had these problems? Is there somesetting I can use to aid me here?
Thanks in advance