Migrate changes from Test to Production

• SQLQuest29

  SSCrazy Eights

  Points: 8264

  More actions

  April 14, 2009 at 9:12 am

  #155557

  Hi All,

  I have a requirement: I have a user who uses a third party application. This application has a form in which the user enters some data and when he clicks "submit", the data gets entered into different SQL server tables in one database.

  Now the user does this in the TEST environment. The requirement is that I have to implement a solution to migrate that changes in production.

  I am thinking of 2 solutions:

  1. do a data import-export and append the data by first clearing out the prod table data. ---> I think this is not a good idea

  2. to implement replication ... merge replication ---> dont know if this is a good idea ?

  Any inputs are appreciated !!

  Environment Test and Prod: SQL 2K5, sp2, win 2k3 R2

  Thanks,

  \\K

  ______________________________________________________________________________________________________________________________________________________________________________________
  HTH !
  Kin
  MCTS : 2005, 2008
  Active SQL Server Community Contributor 🙂

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 14, 2009 at 10:48 am

  #977427

  Are these data changes or schema changes?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question