Can we create diff-scripts from source control ?

alibulut2006alibulut2006 Posts: 25
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
[email protected]

Comments

  • 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
    Systems Software Engineer

    Redgate Software

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

    Thanks.
    Ali Bulut
    Senior Database Administrator & Project Manager
    [email protected]
  • 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.
    Systems Software Engineer

    Redgate Software

  • 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.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.