Breaking a table during migration

mike.baker@Reliance

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

Eddie D

Hi, thank you for your forum post.

Sadly, SQL Data Compare will not help in this situation. You cannot deploy from a single source table to two target tables.

A workaround that may help you, the compare / deploy from the source to the target as single tables and then use the 'Split Table' feature of SQL Prompt to split the single table in the target into two tables:
https://documentation.red-gate.com/display/SP8/Splitting+a+table