You must Sign In to post a response.

08 May 2019 15:53

Joined:	25/06/2008
Level:	Gold
Points:	503

Points:	4

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

31 May 2019 17:05

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	2

Hi

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 : kumaraspcode2009@gmail.com

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

Submit New Thread

Return to Return to Discussion Forum

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

About dotnetspider.com

Quick Links

General

Services