Development and Production Database Synchronization

  • Hi All,

    I have a small database that needs upgrading as opposed to making changes to the production database i oftern take a backup and work on it offline. What is the best way of getting my changes (tables / views and procs) back into the live database?

    at present im just making a note of my changes then replicating them manually back into the live database but this is sometimes a lengthy process.

    just wondering what is the best practice for this?

    Regards

    Greg

  • The easiest way is to buy a product like RedGate SQLCompare or Apex SQLDiff.

  • gregwhite83 (12/7/2009)


    Hi All,

    I have a small database that needs upgrading as opposed to making changes to the production database i oftern take a backup and work on it offline. What is the best way of getting my changes (tables / views and procs) back into the live database?

    at present im just making a note of my changes then replicating them manually back into the live database but this is sometimes a lengthy process.

    just wondering what is the best practice for this?

    Regards

    Greg

    Generally, I'd suggest that you get all the databases into source control and then come up with a mechanism for building your database out of source control (as previouisly mentioned Red Gate or Apex have tools, or there's Visual Studio or even writing your own) automatically. Then, you only make changes to the source code, deploy it to dev or to sandbox machines, qa, etc., label versions, and do targeted builds to prod. It's a pretty complicated process to set up, but really easy to maintain and has HUGE awards for time & effort in the future.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Many thanks for the replies, i will check out the products.

    Cheers,

    Greg

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

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