Replication creates the column msrepl_tran_version in my replicated tables. Is there a way to not have this column created when synchronizing databases with SQL Compare and further ignore it when using SQL Data compare?
Unfortunately, you'd need to ignore msrepltran manually. Neither SQL Compare or Data Compare have any built-in awareness of columns that are added as part of Microsoft SQL Server replication.
Thanks much!
Bryan