Posted by David Portas on 09/18/07 22:29

"ByB" <email@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 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

• Next in forum: How to work with time in format 'hhh:mm:ss' (more than 24 hours)
• Prev in forum: win2k3 sp2 and sql server 2k
• Thread view: Re: Comparing databases

[Reply to this message]