Replication

sid123

Hi
Our staging server doesn't have replication but our production one does.
However I cannot get the compare tables to work as I need as it always finds the following differences in the production server.

[msrepl_tran_version] [uniqueidentifier] NOT NULL DEFAULT (newid())

Is there anything I can do apart from adding the columns to the staging server?

Many Thanks
Steve

Michelle T

In the current version, no, you'll need to add the columns to the staging server if you want the compare to work - there's no way to ignore this specific difference while comparing the rest of the table.

I've added your request to our list of feature requests to do with handling replication.