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