Exclude columns

Boris

How can I exclude certain columns when synchronizing?

I want to sync a production table with certain tables from test tables.
Some columns of the test database are more up to date and some columns of the production database contain the latest data.
Also I guess the msrepl_tran_version column should be left untouched if I don't want to break mssql's replication mechanism.

Thx in advance

Robert C

Hi,

If you look in the "tables and views" tab of the project configuration dialog, there's a column named "columns in comparison". If you edit this for your tables, and deselect certain columns, they won't be compared or altered.

Hope this helps,
Robert

Boris

Thx a bunch.

This software feels like a jackpot to me.
Let's just hope my boss feels the same way.

Boris

-edit: double post-

Robert C

No worries - glad it's useful to you!