Sync 2 DataTables...
Before I come to my problem I'll tell you some background about the situation.
I've got a MySQL database (read + write permission) and a sybase database (read permission) and I've to upload data from sybase to mysql and later download data from mysql to sybase.
I write with purpose not sync cause the schema of both tables are different and I've no write permission on the sybase database. To get any data in the sybase database I've to write a import file and tranfer it to a service which is doing the rest.
For now I wanted to get two datatables with the same schema and fill it with the data from the 2 databases.
Now I want to know what is changed (modified, deleted, new, ...).
1. Is Microsoft sync services for ADO.NET usefull for this situation?
2. If yes, how to write the providers? Are there any documentation about this subject?
3. Are there other methods in the framework to get this done?
I hope you can help me with my problem.
Best regards
