Link to home
Create AccountLog in
Avatar of Norm-al
Norm-alFlag for United States of America

asked on

SQL databases - how to compare from Production and Test SQL server to merge/combine records?

Our PRODSQL server took a HUGE dump 2 days ago and as a resolution, I have the users application point to our DEVSQL. They have been updating records and adding new records to DEVSQL.  We just recovered PRODSQL but before I switch users back to PRODSQL, what is the best way to ensure that all their record changes and additions are merged or updated into PRODSQL? Is there a way to combine 2 like tables and run a compare and merge?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Haver Ramirez
Haver Ramirez

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account