Data Transfer between two tables involving schema changes

CharlieG

Hey Redgate,

I'm trying to setup a large scale table data transfer between our ms sql prod and dev environment. Problem is there are very likely to be schema changes to the tables on a consistent basis.

What im looking for is something that can do a table to table transfer but only transfer the data where the columns match on the source and the destination and leave out any mismatches without setting up a mapping. This of course comes with the added burden of dealing with fk hierarchies. Our current dev'd solution does all this but we are looking for alternatives.

Is this something we can do with the Redgate tools?

Kurt_M

Hi @CharlieG

As long as the tables have the same name and have a comparison key, it will map the columns in the table. If there are columns that don't have a match, they won't be mapped. This is all done through SQL Data Compare.

The automatic mapping looks like this. You'll note the 'Columns' column has a 3 out of 5 match, as the other 2 are a mismatch.

To re-iterate, provided there is a comparison key, SQL Data Compare should be able to handle the ongoing data transfer even with consistent schema changes.