Replication

sid123sid123 Posts: 2
edited November 8, 2007 1:28PM in SQL Compare Previous Versions
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

Comments

  • 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.
    Software Developer
    Redgate Software
Sign In or Register to comment.