Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Compare 2 databases - free?

Author  Topic 

loydall
Starting Member

33 Posts

Posted - 2010-11-10 : 08:11:54
Hi - I need to compare 2 databases - 1 is more up to date than the other so I need to see what's missing on the old one. I need to see what tables, stored procs and views are missing (and also what fields in existing tables are missing).

Is there any free software that will allow me to do this?

Thanks

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-11-10 : 09:19:14
Have a look at:
http://dbcomparer.com/
Go to Top of Page

loydall
Starting Member

33 Posts

Posted - 2010-11-10 : 10:07:12
Thanks! That's completely perfect. Great stuff.
Go to Top of Page

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-11-11 : 00:51:57
quote:
Originally posted by loydall

Thanks! That's completely perfect. Great stuff.



You are welcome
Go to Top of Page
   

- Advertisement -