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...
>
Showing posts with label evaluate. Show all posts
Showing posts with label evaluate. Show all posts
Thursday, March 22, 2012
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...
>
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
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...
>
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...
>
Subscribe to:
Posts (Atom)