Zack
asked on
Transferring data from database to another with a Schema check.
Hi EE,
I would like to transfer all data from a prod instance DB to a UAT instance DB. However, I would like to omit tables between the two DB where the schemas are different. Is there a way to do this via the GUI if not what would be the command to check the compare the schemas before transfer?
I am using SQL server 2012.
Any assistance is appreciated.
Thank you.
I would like to transfer all data from a prod instance DB to a UAT instance DB. However, I would like to omit tables between the two DB where the schemas are different. Is there a way to do this via the GUI if not what would be the command to check the compare the schemas before transfer?
I am using SQL server 2012.
Any assistance is appreciated.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The second suggestion can be easily scripted cheers for the advice.
Thank you.