Post reply

SQL Development & Production Server Configuration.

  • March 18, 2004 at 6:45 am

    #107578

    Hello,

    I have a pretty simple question. We want to set up two SQL Servers, one for development and one for the production environment. (These will be two separate machines, both running SQL Server 2000 Standard Edition)

    How can I configure them so that I can make all the changes I want to the development server, and then after I have tested everything, have my changes and/or data easily migrated to the production server?

    I would appreciate any assisance you have to offer. Thanks.

    Bob Gibilaro

  • March 19, 2004 at 3:01 pm

    #499595

    Serious DBAs will only use SQL ddl scripts to update the dev box (no changes done in enterprise manager), keep and track the scripts (in vss or just a staging directory), then apply the same scripts to the production box when needed.

    Since we don't usually have a real DBA and I have to do this myself, my preference is to use Red-Gate's SQL Compare to compare databases on dev and production server, then review the resulting script and apply as needed. 

     



    Mark

  • March 22, 2004 at 11:31 am

    #499832

    If you like, there's a comparison feature in Quest Central for SQL Server that will let you view the differences and apply to selected servers.

    Its free, click link to try

    http://www.quest.com/requests/?RequestDefID=1965&landing=SQL_Server

  • March 22, 2004 at 7:03 pm

    #499919

    There is also http://www.apexsql.com/ ApexSQL Diff and http://www.adeptsql.com/ AdeptSQL Diff

  • March 23, 2004 at 7:15 am

    #500024

    Hey guys,

    Thanks for all the suggestions. I am suprised that Microsoft does not offer an easier built in feature for this situation.

    Anyways, we purchased the RedGate SQLCompare software and it works great. Exactly what I needed.

    Thanks again!

    Bob Gibilaro

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

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