Does anyone know of a SQL Compare tool that allows for the disabling of
Replication when doing database compares?
I have a large number of identical merge replicated databases and am using
the Redgate SQL Compare tool. It is a great tool but always identifies every
table as a diff because of the different Replication trigger names. This
kinda defeats the point of using the tool because I still need to examine
every table to ensure consistency. I am looking for a compare tool that will
allow me to disable the comparing of all replication related db objects.
Anything out there?
I have the same issue running merge replication where there are
replication specific objects & a rowguid column in my article tables. I
use DB Ghost from Innovartis to manage my database changes & it ignores
the replication objects during a comparison. To avoid the rowguid
columns coming up as differences, I basically drop replication, drop the
rowguid columns & re-create replication. To do this, I create a file
containing the commands to drop the columns (DB Ghost can generate this
file) & use Enterprise Manager to generate scripts to drop & create my
publications, articles etc. These files are then passed as input to DB
Ghost & executed automatically either before or after the database
comparison.
John McGrath
SQL Server DBA MCSE
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment