|
|
Posted by Martijn Tonies on 10/23/06 16:55
Chris,
> I want to generate a SQL Script of a SQL Server database. To do this, I
> right-click the database name and choose the option All Tasks/Generate
> SQL Script.
>
> Than I get a text file with a script that generates all objects, but the
> order in which the objects are generated is wrong. There are a lot of
> views in the database and many views are based on other views. When I
> try to execute the script on a different computer, I get a lot of error
> messages, because the script tries to create views that are based on
> other views that are not created yet.
>
> Is there a way to generate a script that automatically 'knows' which
> views to create first or do I have to manually look through all views
> and find out myself the execute order? (I hope not, because it are
> really a lot of views).
Download yourself a copy of our database developer IDE called
"Database Workbench" at www.upscene.com
When extracting DDL, it shuffles the views around in the dependency
order.
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
Navigation:
[Reply to this message]
|