Ordering of objects in generated script
Brian Donahue
Posts: 6,590 Bronze 1
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?
Regards,
Brian Donahue
Red Gate Technical Support
"Joseph Fifield" <jfifield@emerlyn.com> wrote in message
news:Q0Fm6t7TEHA.3156@server53...
> Hello,
>
> We recently purchased SQL Compare 3.1.5.191. One of the things we use it
for
> is creating a "full database create" script by simply comparing our
database
> 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
between
> 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
in
> the generated scripts between runs?
>
> Thanks for your help, and thanks for a great product!
>
> 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?
Regards,
Brian Donahue
Red Gate Technical Support
"Joseph Fifield" <jfifield@emerlyn.com> wrote in message
news:Q0Fm6t7TEHA.3156@server53...
> Hello,
>
> We recently purchased SQL Compare 3.1.5.191. One of the things we use it
for
> is creating a "full database create" script by simply comparing our
database
> 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
between
> 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
in
> the generated scripts between runs?
>
> Thanks for your help, and thanks for a great product!
>
> Joe
>
>
This discussion has been closed.
