Compare checked in code to SQL

Itamar · Post by **Itamar** » Thu Jul 21, 2005 1:46 pm

Much of the code we have checked into Vault is stored procedures, views and triggers for a SQL 2000 server. I would like to compare what is in Vault to what is actually in SQL.

My question is has anyone figured out a way to compare what is checked into Vault to what is in a SQL database? Or a workaround?

Thanks!

ian_sg · Post by **ian_sg** » Thu Jul 21, 2005 2:16 pm

You would need to generate scripts from the existing SQL Server database (using Enterprise Manager) and compare that to the code you've got in your repository. Vault includes a text diff viewer, as does Visual Studio.

As an alternative, you could generate a new database using the scripts from Vault, and use a third party tool to compare the databases themselves. (There are many such comparison tools. A Google search for "SQL database comparison" yielded at least five.)

Post by **jclausius** » Thu Jul 21, 2005 3:41 pm

Also, I think ApexSQL and SpeedSQLIDE integrate with Vault.

You might want to try the demo of these tools, and see if they provide a way to diff stuff in the Vault repository against the database.