December 7, 2006 at 2:56 am
i have 2 databases that are supposed to have the same schema, but i want to make sure... i there a tool to compare the databases? tx!
December 7, 2006 at 3:27 am
search this site and other sites u should get some scripts
"Keep Trying"
December 8, 2006 at 1:20 am
Hi,
Red Gate software create a tool called SQL Compare - which has a 14 day free trial - which will do exactly what you want. You can find more information and download the trial from here: http://www.red-gate.com/products/SQL_Compare/index.htm
Hope this helps,
- James
--
James Moore
Red Gate Software Ltd
December 8, 2006 at 2:16 am
One way is to script both databases (all objects) from the SSMS and use windiff in order to spot the differences.
Adi
December 8, 2006 at 7:41 am
May be Red Gate aso does the same, but I have not yet used it.
Embarcadero is a nice tool to compare databases. I have used it extensively
December 8, 2006 at 9:35 am
Another tool you may want to consider is DB Ghost from Innovartis (http://www.dbghost.com) - as well as schema/data compare and synchronization it also lets you store your "source database" as a set of scripts in source control giving you a full audit trail of changes.
Kind regards,
Malcolm
Malcolm
DB Ghost - Build, compare and synchronize from source control = Database Change Management for SQL Server
www.dbghost.com
December 8, 2006 at 3:02 pm
Quest makes a product that does this and it is absolutely free. Just came out about 3 or 4 weeks ago. I like it.
http://www.quest.com/comparison_suite_for_sql_server/
G. Milner
December 8, 2006 at 4:01 pm
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply