Can we create diff-scripts from source control ?

alibulut2006 · January 11, 2011 10:56AM

Hi;
We have some branch databases and one trunk database. Our trunk DB is under source control now and developers committing their changes in their local copies and committing to source control.
We are using SQL Compare tool to create upgrade scripts between latest branch DB and Trunk DB. I s there a way to create these scripts between :
1- Latest branch DB vs Source Control Version
2- Lets say our latest branch DB is also under source control and can we create upgrade scripts from comparing these two version of the DB in source control versions?

Thanks

James B · January 12, 2011 11:09AM

The latest version of SQL Compare with the SQL Server Integration Pack should help with these kind of things. You can now initiate a SQL Compare session directly from within Management Studio, and target it against source-controlled databases - there's a screenshot here: clicky

alibulut2006 · January 12, 2011 11:24AM

Hi;
How can we use this functionality in sqlcompare command options?

Thanks.

James B · January 12, 2011 11:27AM

If you're referring to comparing versions of databases within source control, this has to be done via SSMS, you cannot do it from the commandline unfortuantely.

James B · January 16, 2011 3:29AM

Just following on from my previous post- you can compare source-controlled versions although it's a more manual process.

The steps would involve you using your command-line source control tools to grab a copy of both the source and destination sets of folders to work with, and then using SQL Compare via the command line. We have a white paper here which has an example using SVN, which may be of interest.

Can we create diff-scripts from source control ?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk