April 1, 2004 at 7:29 am
We have a development database from which we want to move some of the object to a test server prior to moving them to the production box. What is the best way to make sure that we get all of the related objects? I know which tables I want to move but there are procs that use views and functions and other procs and I don't want to miss anything. Are there any tools/tricks/scripts that can help me?
April 2, 2004 at 4:51 am
sysdepends is a system table to look up.
Once find out all the objects, use dts to copy.
April 2, 2004 at 10:26 am
If you always drop/create instead of alter, then you can use sysobjects.crdate to find changes. RedGAte and others have tools to give you a list of differences in objects between the systems. But mostly you need a good system to track things. I wrote about how I handle this:
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply