Choose rows to synchronize
informatika
Posts: 18
Hello,
Is it possible to choose rows for synchronizing.
The Problem is that i want to compare the hole tables and then only synchronize that rows where a datetime field in the one table is greater than the same field in the other table. That means choosing special rows in the DifferentRecords collection.
And additionally i only want to synchronize rows wich have a special primary key in the In1Records- and other with other primary keys in the In2Records-Collection.
My idea was to delete that differences that doesnt match my rules, but all properties in the diffrences-collection are readonly.
Hope that you can imagine what i want to and are able to help me.
Best regards Peter
Is it possible to choose rows for synchronizing.
The Problem is that i want to compare the hole tables and then only synchronize that rows where a datetime field in the one table is greater than the same field in the other table. That means choosing special rows in the DifferentRecords collection.
And additionally i only want to synchronize rows wich have a special primary key in the In1Records- and other with other primary keys in the In2Records-Collection.
My idea was to delete that differences that doesnt match my rules, but all properties in the diffrences-collection are readonly.
Hope that you can imagine what i want to and are able to help me.
Best regards Peter
This discussion has been closed.
Comments
I understand what you're after. Check the SQL Toolkit documnetation for an object called a SelectionDelegate. Using a combination of Bookmarks and putting a SelectionDelegate on the migration SQL generator, you can automatically choose records to synchronize based on a datetime column.
I'd be more than happy to send some source code if you're interested.
http://www.red-gate.com/messageboard/vi ... php?t=1067