On Sep 18, 11:29 pm, "David Portas"
<REMOVE_BEFORE_REPLYING_dpor...@acm.org> wrote:
> "ByB" <em...@email.com> 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 .
>
> > --
> > 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...pare/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