sql server replication: Comparing database structures -- sql server replication

Comparing database structures

Earl
3/30/2007 10:10:08 PM

sql server replication:

I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
comparison between an up-to-date version and an older version of the same
database. However, when I try to synchronize, it synchronizes the normal
tables, then I get a message:

The following error message was returned from the SQL Server:
[208] Invalid object name 'dbo.MSmerge_contents'.
The following SQL command caused the error:
create view [MSmerge_contents_Products] as select * from
dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
(select rowguid from [Products]))

I have limited familiarity with the MSmerge_contents tables, but if I recall
correctly, those are tables used during replication. I've done no
replication on either of these datatabases, although it is possible that one
or the other was derived from a database that had been replicated at one
time. To make a long story short, both of these being non-replicated
databases, any problems just dropping those tables?

Re: Comparing database structures

TheSQLGuru
3/31/2007 7:37:38 AM

1) Can't you have SQLCompare ignore system objects when doing a comparison?

2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
or have cross-platform needs, check out Embarcadero's Change Manager.

--
TheSQLGuru
President
Indicium Resources, Inc.

[quoted text, click to view]