Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Porting Database Object Changes from QA to Production

    Can anyone help me in this issue:
    How do we replicate database changes (like tables) from QA to production without losing Production data.
    We already tried using the DTS export but it is dropping the destination tables before export which will result in data loss in the destination database.

  2. #2
    Join Date
    Feb 2004
    Posts
    492

    Re: Porting Database Object Changes from QA to Production

    Why not write a change script which holds the changes you perform and have it run against both QA as production?

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Re: Porting Database Object Changes from QA to Production

    Originally posted by Kaiowas
    Why not write a change script which holds the changes you perform and have it run against both QA as production?
    Can we write change script for column addition and deletion, if yes can i have a sample syntax. Thanks.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    For instance you can go with ALTER TABLE if only schema changes are involved.

    In DTS you can specifiy not to drop destination rows, instead can append the rows.

    But if you have major change in QA about Schema then its better off to add a step to export current production data before importing from QA.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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