Schema Compare!

12 Aug 2005 5:25 PM

tom d

Hi,
Without using third party tools, does anyone know if there is any sql script
or SP out there that will do a schema compare between two SQL tables from two
different databases on the same server or different servers.

Thanks,
Tom

12 Aug 2005 5:29 PM

Aaron Bertrand [SQL Server MVP]

http://www.aspfaq.com/2209

Show quote

"tom d" <t***@discussions.microsoft.com> wrote in message
news:A4DC4080-66E3-4FED-8D54-D57B07A01FDF@microsoft.com...
> Hi,
> Without using third party tools, does anyone know if there is any sql
> script
> or SP out there that will do a schema compare between two SQL tables from
> two
> different databases on the same server or different servers.
>
> Thanks,
> Tom

12 Aug 2005 7:18 PM

JT

Object comparison utilities are nice but ...

Within Enterprise Manager,
1.    right click on the database and then select All Tasks.. Generate SQL
Scripts..
2.    Select the object types you want to compare
3.    On the options tab, choose options to add to the scripts such as
indexes and primary keys. Also, choose the options ANSI text and "Create One
File Per Object".
4.    When you click OK, it a dialog will prompt for the folder to generate
the scripts to.
5.    Repeat the same steps for the other server/database but to a different
folder.

Download the freeware file/folder comparison utility WinMerge:
http://winmerge.sourceforge.net/

Those scripts with differences will be highted, and clicking on a file will
highlight specific changes between the two versions.

You can also use the DMO api to script objects programatically.

Enjoy

Show quote

"tom d" <t***@discussions.microsoft.com> wrote in message
news:A4DC4080-66E3-4FED-8D54-D57B07A01FDF@microsoft.com...
> Hi,
> Without using third party tools, does anyone know if there is any sql
> script
> or SP out there that will do a schema compare between two SQL tables from
> two
> different databases on the same server or different servers.
>
> Thanks,
> Tom