I'm evaluating Clover for a data migration project, moving data between two SQL Server 2008 databases.
As part of my testing I need to evaluate whether clover can migrate parent/child data between the two systems, whilst retaining the relationship. For my test I have a DBInputTable that reads the source parent records, and a DBOutputTable that inserts the mapped parents into the destination db. However I am getting stuck on having the DBOutputTable component return the new ids that the db has generated.
Does anyone have a solution to this problem?
Thanks i advance,