MS SQL Server - Dependencies all messed up

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Dependencies all messed up

Rob

2006-11-15, 7:14 pm

Hi,

I'm in the midst of creating the schemas for one of my SQL 2000 DB to
another server running SQL 2005. However, this DB that our wonderful
developer had created, consists of numerous dependencies. I don't want to
copy and restore the database as the data is not required (quite large) and
that a different set of data is being planned to be tested on in the SQL 2005
server.

Long story short, I scripted all my objects, per object type, with any
dependencies and tried replaying that script on the SQL 2005 server
one-by-one, but I keep getting a whole bunch of errors. When I try to fix
one, I find another, fix that, then find another 10. It's been driving me
crazy.

Is there any way to systematically script the schemas so that all dependent
objects are referenced and scripted out in its correct order?

TIA.

Sponsored Links