Hi all,
I want to sync few data from dev to prod, without performing a full database export and import, because, the production data has existing data in it.
Also, the application saves inserts production data into production database which would not be present in Dev servers.
The dev servers contains few data that needs to be deployed into test, qa and production.
Are there any tools like IDERA for SQL Server, which compares the data between two data sources ?
Please, advise.