Post reply

Versions

  • August 10, 2004 at 10:57 pm

    #161976

    Hi,

    I have one production server and a development server. at one point the a database in these two servers are identitical. after that i made some changes in the development server. like did some tuning, wrote a couple of stored procedures. created a table, cretaed /dropped /modified a few indexes. but i didnt keep teh script while doing the same. Now i want to get the scripts of all changes i made after a particular date inorder to update the production one. is there any way to get this done ?

    Pls help

    Thanks in advance

    Jeswanth

    --------------------------------

  • August 11, 2004 at 7:43 am

    #518491

    Try SQL Compare at http://www.red-gate.com.

  • August 11, 2004 at 10:05 am

    #518521

    There isn't a good way natively. Products like Red-Gates and others allow you to do this fairly easily, but you have to do it. I think some of them do scheduling to capture changes.

    Natively, SQL stores the creation date for objects and a "version", but no date if you alter things.

  • August 12, 2004 at 1:46 am

    #518592

    Cast Release Builder is a tool that does the same.

  • August 12, 2004 at 2:57 am

    #518612

    Hi All

    Thanks for the feed back. let me try these tools now

    /-Jeswanth

    --------------------------------

  • August 12, 2004 at 3:06 am

    #518619

    The recent series of articles at sqlservercentral.com about SQL Server change control might be of interest also

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply