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.

[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 !