November 3, 2005 at 3:16 pm
DBArtisan and RapidSQL from Embarcadero both analyse dependencies when creating scripts. They're nice tools, but pretty pricey.
November 3, 2005 at 11:42 pm
try DB Ghost (http://www.dbghost.com) - it's cheap and it works.
regards,
Mark Baekdal
+44 (0)141 416 1490
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
November 4, 2005 at 7:54 am
When scripts are generated using EM the first thing generated are the IF EXISTS... DROP [object] commands for the objects that need to be recreated.
If you execute your script once in QA, then delete, or comment out the DROPS, you can then execute your script over and over until no errors (due to dependencies) are left.
This solution is not elegant, but it doesn't cost anything.
November 4, 2005 at 10:48 am
You might want to search this site for chNge management and migration processes. There are quite a few great threads on what you want to do.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
November 4, 2005 at 1:58 pm
the scptxfr tool comes with sql server and generates the objects in a runnable order...
C:\>scptxfr /s <serverName>\<instance> /I /d <databaseName> /f <scriptOutputFile.sql>
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply