Options
Help - object creation order?
Brian Donahue
Posts: 6,590 Bronze 1
Hi Jeff,
I'm not sure how to answer the multiple-choice part of your question!
Let's call it a possible oversight, then. SQL Compare's scripting is very
good at dealing with dependencies and object order, but problems can come up
because of outdated/corrupted sysdepends tables and other factors, like
trying to migrate users to another server when the logons haven't been
created for them by an administrator.
Sometimes it helps to find the object that gave you the error, and try
to script it by itself. You'll then get a lot less confusing messages from
the server, and it will help you nail down the problem and perhaps solve all
of the errors that occur afterwards.
Sincerely,
Brian Donahue
Technical support
"jeff saylor" <js@nowhere.com> wrote in message
news:EHLv0dzGDHA.1424@server53...
> I'm evaluating SQL Compare and am trying to script a fairly complex db.
> While the script appears syntactically correct, object creations are out
of
> order and generates lots of "object doesn't exist" errors.
>
> Is this a bug or a feature that just doesn't exist in the product?
>
> Appreciation in advance.
>
>
I'm not sure how to answer the multiple-choice part of your question!
Let's call it a possible oversight, then. SQL Compare's scripting is very
good at dealing with dependencies and object order, but problems can come up
because of outdated/corrupted sysdepends tables and other factors, like
trying to migrate users to another server when the logons haven't been
created for them by an administrator.
Sometimes it helps to find the object that gave you the error, and try
to script it by itself. You'll then get a lot less confusing messages from
the server, and it will help you nail down the problem and perhaps solve all
of the errors that occur afterwards.
Sincerely,
Brian Donahue
Technical support
"jeff saylor" <js@nowhere.com> wrote in message
news:EHLv0dzGDHA.1424@server53...
> I'm evaluating SQL Compare and am trying to script a fairly complex db.
> While the script appears syntactically correct, object creations are out
of
> order and generates lots of "object doesn't exist" errors.
>
> Is this a bug or a feature that just doesn't exist in the product?
>
> Appreciation in advance.
>
>
This discussion has been closed.
