Hello All, Good day to all, I have a database for around 80 GB in production. As per the request I refreshed that database to UAT environment. After a week later,user is raising a request to refresh a table alone from production DB to UAT DB. The table has around more than 20 Millions records. Instead of refreshing the whole database,I want to know is there any possibility to take that table alone from the Production database and refresh in UAT Database. Note:- I tried to take that table through generate script, But i could not get that. Please need your suggestion. Thanks in advance.
Its possible with Redgate backup, where you can do an object level recovery from the sqb backup file. Other ways with out redgate is using SSIS, BCP or BULK INSERT, where you can import\export particular table but this way you are adding load on your production server.
Hi there, Another option is [xSQL Data Compare]. You can very well use it to compare and synchronize data between tables and in your case you can specifically select the tables you want to compare / synchronize. Also, if in the future you need to perform this synchronization again, to spare yourself of performing a full comparison / synchronization, you can even apply additional filters to synchronize only part of the table. DISCLAIMER: I'm affiliated with xSQL. :