December 24, 2003 at 7:39 am
I am developing a set of stored procedures, views, and a few functions for a reporting system which will have to be moved from development server to a couple of different production systems. There are interdependencies bewteen views and procs. Does anyone know of a tool that will use SYSDEPENDS to produce a script which loads the code in the correct order? I know that SYSDEPENDS is not 100% correct, but it seems to be pretty good.
Thanks,
Alan
December 24, 2003 at 7:45 am
Have you tried to generate SQL scripts from EM with option "generate scripts for all dependent objects"?
December 30, 2003 at 2:36 am
I use SQLDiff (http://www.lockwoodtech.com) from time to time to generate scripts I forgot to save.
Not only does it show ALL differences between two databases, but it will generate the merge scripts for you. It is pretty darn good about getting everthing in the correct order. It hasn't let me down yet.
December 31, 2003 at 10:24 am
There are a few diff tools, Lockwood (now named something else), AdeptSQL and RedGate's tool. there are reviews of these procs on this site.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply