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...
>

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...
>

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...
>> 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?
>sqlsql

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...
>

Compare Tables?

Hello. I have two copies of a database (one older, one newer). I
would like to compare them and take the records that do not appear in
both dbs and copy them to the newer one.
As much as I would like to manually go through, row by row, is there
an easier way'
Using:
- SQL 7
- Win NT
Many thanks!
JDThere's a 3rd party product called SQLCompare...
--
HTH
Ryan Waight, MCDBA, MCSE
"JD" <whatchoogot@.hotmail.com> wrote in message
news:b809817a.0311120722.5bcbac2f@.posting.google.com...
> Hello. I have two copies of a database (one older, one newer). I
> would like to compare them and take the records that do not appear in
> both dbs and copy them to the newer one.
> As much as I would like to manually go through, row by row, is there
> an easier way'
> Using:
> - SQL 7
> - Win NT
> Many thanks!
> JD|||JD,
I have used this product it great but becareful because
it will lock the table during comparing. It best that
you don't do this in production server.
Take Care,
Rachan
>--Original Message--
>There's a 3rd party product called SQLCompare...
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"JD" <whatchoogot@.hotmail.com> wrote in message
>news:b809817a.0311120722.5bcbac2f@.posting.google.com...
>> Hello. I have two copies of a database (one older,
one newer). I
>> would like to compare them and take the records that
do not appear in
>> both dbs and copy them to the newer one.
>> As much as I would like to manually go through, row by
row, is there
>> an easier way'
>> Using:
>> - SQL 7
>> - Win NT
>> Many thanks!
>> JD
>
>.
>|||Also a 3rd party tool called DB Ghost at www.dbghost.com
Thanks,
Darren Fuller MCSE
>--Original Message--
>Hello. I have two copies of a database (one older, one
newer). I
>would like to compare them and take the records that do
not appear in
>both dbs and copy them to the newer one.
>As much as I would like to manually go through, row by
row, is there
>an easier way'
>Using:
>- SQL 7
>- Win NT
>Many thanks!
>JD
>.
>