What are the challenges you face when working across database platforms? Take the survey

Ordering of objects in generated script

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited June 15, 2004 9:43AM in SQL Compare Previous Versions
Hi Joe,

There isn't a way to preserve the object scripting order, I'm afraid.
The order that the scripts are done has to do with whatever dependent
objects exist in the database, so the order will most likely differ every
time a new object is added or an object is changed in the database.

Maybe you could store a snapshot of each database in source control
rather than a database script and create a 'differences script' on-the-fly
with SQL Compare. Would that be possible/practical?


Brian Donahue
Red Gate Technical Support

"Joseph Fifield" <jfifield@emerlyn.com> wrote in message
> Hello,
> We recently purchased SQL Compare One of the things we use it
> is creating a "full database create" script by simply comparing our
> to a blank database and saving the generated script. We then check this
> script into source control so we can keep track of what changes were made.
> However, every time we do this, the order of the database objects in the
> script completely changes. This makes it very difficult to do diffs
> versions because it looks like almost everything has changed! This even
> occurs with very simple changes such as adding a single column to a table.
> I am wondering if there is a way to maintain ordering of database objects
> the generated scripts between runs?
> Thanks for your help, and thanks for a great product!
> Joe
This discussion has been closed.