Red Gate forums :: View topic - Can we create diff-scripts from source control ?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

Can we create diff-scripts from source control ?

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
alibulut2006



Joined: 23 Dec 2010
Posts: 17
Location: 218

PostPosted: Tue Jan 11, 2011 4:56 pm    Post subject: Can we create diff-scripts from source control ? Reply with quote

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
Back to top
View user's profile Send private message Send e-mail MSN Messenger
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed Jan 12, 2011 5:09 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
alibulut2006



Joined: 23 Dec 2010
Posts: 17
Location: 218

PostPosted: Wed Jan 12, 2011 5:24 pm    Post subject: SQL Compare with Source Controlled DB Reply with quote

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

Thanks.
_________________
Ali Bulut
Senior Database Administrator & Project Manager
a.bulut@triodor.eu
Back to top
View user's profile Send private message Send e-mail MSN Messenger
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed Jan 12, 2011 5:27 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Sun Jan 16, 2011 9:29 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group