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

Help - object creation order?

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited May 22, 2003 4:42AM in SQL Compare Previous Versions
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.

Brian Donahue
Technical support

"jeff saylor" <js@nowhere.com> wrote in message
> I'm evaluating SQL Compare and am trying to script a fairly complex db.
> While the script appears syntactically correct, object creations are out
> 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.