Comparing database structures

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?
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.
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> 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?
>
|||Thanks for the references, I'll certainly check out those products. The
SQLCompare did allow me to ignore the differences on synchronization, which
was enough to finish the job.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OK0ZsF5cHHA.284@.TK2MSFTNGP05.phx.gbl...
> 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.
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>