Comparing databases

Hello,

I would like to make a comparison between two databases in SQL server,
to find differences between tables, procedures and so on.

I have searched the web and found several softwares able to perform the
task, but none able to compare a database with a backup otained from a
SQL Server database, or between two backups.

Is this possible ? Is there a software able to perform such comparison
?

Thank you for your help.

--
L'amour, c'est un sport. Surtout s'il y en a un des deux qui veut pas.
[Jean Yanne]"ByB" <email@.email.comwrote in message
news:mn.957d7d7999326e87.13846@.email.com...

Quote:

Originally Posted by

Hello,
>
I would like to make a comparison between two databases in SQL server, to
find differences between tables, procedures and so on.
>
I have searched the web and found several softwares able to perform the
task, but none able to compare a database with a backup otained from a SQL
Server database, or between two backups.
>
Is this possible ? Is there a software able to perform such comparison ?
>
Thank you for your help.
>
--
L'amour, c'est un sport. Surtout s'il y en a un des deux qui veut pas.
[Jean Yanne]
>
>

I don't think you'll find any tool that can compare a database to the
contents of a backup file.

Check out Red Gate for database to database comparison.

http://www.red-gate.com/products/SQL_Compare/index.htm
http://www.red-gate.com/products/SQ...mpare/index.htm
--
David Portas|||On Sep 18, 5:25 pm, ByB <em...@.email.comwrote:

Quote:

Originally Posted by

Hello,
>
I would like to make a comparison between two databases in SQL server,
to find differences between tables, procedures and so on.
>
I have searched the web and found several softwares able to perform the
task, but none able to compare a database with a backup otained from a
SQL Server database, or between two backups.
>
Is this possible ? Is there a software able to perform such comparison
?
>
Thank you for your help.
>
--
L'amour, c'est un sport. Surtout s'il y en a un des deux qui veut pas.
[Jean Yanne]

ApexSQL is very good.|||Another great tool for comparing and synchronising SQL Server
databases (schema and data) is DB Ghost from Innovartis. It can also
let you manage your "source" database as a set of CREATE scripts under
source control:

http://www.dbghost.com
http://www.innovartis.co.uk|||On Sep 18, 11:29 pm, "David Portas"
<REMOVE_BEFORE_REPLYING_dpor...@.acm.orgwrote:

Quote:

Originally Posted by

"ByB" <em...@.email.comwrote in message
>
news:mn.957d7d7999326e87.13846@.email.com...
>
>
>

Quote:

Originally Posted by

Hello,

>

Quote:

Originally Posted by

I would like to make a comparison between two databases in SQL server, to
find differences between tables, procedures and so on.

>

Quote:

Originally Posted by

I have searched the web and found several softwares able to perform the
task, but none able to compare a database with a backup otained from a SQL
Server database, or between two backups.

>

Quote:

Originally Posted by

Is this possible ? Is there a software able to perform such comparison ?

>

Quote:

Originally Posted by

Thank you for your help.

>

Quote:

Originally Posted by

--
L'amour, c'est un sport. Surtout s'il y en a un des deux qui veut pas.
[Jean Yanne]

>
I don't think you'll find any tool that can compare a database to the
contents of a backup file.
>
Check outRed Gatefor database to database comparison.
>
http://www.red-gate.com/products/SQ...mpare/index.htm
>
--
David Portas

Coincidentally, comparing to a backup is one of the new features in
SQL Data Compare 6 Pro, which is due out very shortly. If you would
like to try this out, the Alpha release should still be available from
our forum page: http://www.red-gate.com/messageboard/index.php
Most likely we will be releasing a public release candidate sometime
next week, so check the SQL Data Compare forums for announcements.

Kind regards,

David Atkinson
Red Gate Softwaresqlsql

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