DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to synchronize development and production

  1. #1
    Join Date
    Mar 2001
    Suppose you have two database PrdDB and DevDB. If you make database change on DevDB, for example, add new columns, change column width......, how do you promote these change to PrdDB in a systematic way.

    Usually, I will do an export from DevDB and import into the target DB. However, PrdDB has real data so you cannot do this kind of import.

    So, what I did before is to keep all scripts that I executeed on DevDB and implemeted the same script on PrdDB.

    Question: is there any kind of tools or scripts that can compare two instance and create the script that can synchronize them?

  2. #2
    Join Date
    Nov 2000
    Baltimore, MD USA
    ERwin can, and probably some of the other tools in that vein as well, I would wager.

    ER Studio, Visio, Power Designer, et al.

    - Chris

  3. #3
    Join Date
    Aug 2000
    BMC, Platinum . . .

  4. #4
    Join Date
    Mar 2000

    How we did

    Hi, 5th May 2001 20:17 hrs chennai

    I am very much eager to know on this issue.

    Since when we worked in Major Banking projects we used did code promotion from dev to prod then and there plus, for new versions from Dev to Prod it was a big process called Librarian activities code check in and code chack out etc.
    all the diff columns was found out manually and promoted the codes.

    I think even though the process was excellent the new columns diff was not found with any tools as you say so can
    chisrlong and Kmesser tell the websites where this tools informations are available.



    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width