How to exclude tables of target database before sync?

compvis

Hi,

I want to update data from database A (source) to database B(destination). I mean, not update data from B to A. How can i use code to exclude (custom) rows from B (target) before synchronizing data ? Like SQL Data Compare 8 software, please see image below:



Thanks

peter.peart

Hi there,

Thanks for your post. This is actually quite simple. You need to supply a SessionSetting to the CompareDatabases method. e.g.

m_Session.CompareDatabases(db1, db2, mappings, SessionSettings.Default ^ SessionSettings.IncludeRecordsInTwo);

This will sync all rows, but remove the records that only exist in the target from the synchronization. i.e. It won't script any deletes.

HTH!

Pete

compvis

Thanks,

My example above is only one table on target. Assuming that i have two tables on target. How can i custom to select one of two tables ? With your code:

m_Session.CompareDatabases(db1, db2, mappings, SessionSettings.Default ^ SessionSettings.IncludeRecordsInTwo);

It means, i have to exclude all table from targets ?

Btw: the StatusEventHandler works fine with console samples but It doesn't work with winforms (i add a progress control to display pecentages). If possible, please upload a winform sample that successfully use StatusEventHandler and progress control.

Thanks for the best tools !