What are the challenges you face when working across database platforms? Take the survey

Breaking a table during migration

I'm using SQL Data Compare 10. I'm trying to re-structure and in the process I want to break some data from one table in the source to two tables in the destination. Is there a way to do this? When I try to map tables I can't include the table more than once so I can't map some fields to one table and other fields to a second table. Everything in the new database will be new records, the destination is empty. The second table in the destination will be related records so the Id from the source will be mapped to the Id of destination in table one and to foreign key of the destination in table two.
Thanks, Mike


Sign In or Register to comment.