You must Sign In to post a response.
  • Category: SQL Server

    How to propagate data changes between dev, qa, and production

    We do CRUD operation for admin master tables & write scripts whatever changes make with values and store it to one tracking table in Dev environment. We will run those scripts in other environments by hand(Is there any tool or what is the best approach to run other environment?). Here we are facing one issue the primary key value is not same in other environments.We have almost 10000 record in that table.Kindly share your input how to handle this situation.
  • #769892

    You can create Temp Table and inserted those records then you can compare both checking validation and duplicate you can put new primary key your temptable you can compare and inserted easily

    Name : Dotnet Developer-2015
    Email Id :

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • Sign In to post your comments