Can we create diff-scripts from source control ?

[alibulut2006]

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
_________________
Ali Bulut
Senior Database Administrator & Project Manager
a.bulut@triodor.eu

[james.billings]

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]

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

Thanks.
_________________
Ali Bulut
Senior Database Administrator & Project Manager
a.bulut@triodor.eu

[james.billings]

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.billings]

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.