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 [at] email.com> wrote in message
news:mn.957d7d7999326e87.13846 [at] 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

On Sep 18, 5:25 pm, ByB <em... [at] email.com> 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.

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... [at] acm.org> wrote:
> "ByB" <em... [at] email.com> wrote in message
>
> news:mn.957d7d7999326e87.13846 [at] 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