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]

Re: Comparing databases

"ByB" wrote in message
news:mn.957d7d7999326e87.13846@email.com...
> 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/SQL_Data_Compare/index.htm

--
David Portas

Re: Comparing databases

On Sep 18, 5:25 pm, ByB wrote:
> 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.

Re: Comparing databases

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

Re: Comparing databases

On Sep 18, 11:29 pm, "David Portas"
wrote:
> "ByB" wrote in message
>
> news:mn.957d7d7999326e87.13846@email.com...
>
>
>
> > 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 outRed Gatefor database to database comparison.
>
> http://www.red-gate.com/products/SQL_Compare/index.htmhttp:/ /www.red-gate.com/products/SQL_Data_Compare/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 Software