Red Gate forums :: View topic - Dedicated mode and Git
Return to RSS Feed Available

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

Dedicated mode and Git

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

Joined: 01 Mar 2013
Posts: 2

PostPosted: Fri Mar 01, 2013 3:22 pm    Post subject: Dedicated mode and Git Reply with quote

Just trying out SQL Source Control. Maybe someone can clarify the Dedicated mode for me. From what I read on Dedicated mode should enable me to develop and make changes to a local copy of the database before I deploy them to the live version (if I understand it correctly). But this doesn't seem to be the case. I've linked a database and set it to Dedicated mode, so I indeed have copies of SQL scripts locally, but when in SQL Server Management Studio I modify a stored procedure, it gets updated straight in the database, and by committing changes I'm only updating my local repository... Maybe I'm doing it wrong (modifying procedure by editing ALTER PROCEDURE script and executing it) but otherwise does it mean I have to actually edit the SQL files in repository and then update database through 'Get Latest' panel? That means I'd have to force all my team mates to remember how to modify database (by editing local files), otherwise everyone will be committing someone's changes to their local copies = conflict when pushing to central repository. I'm pretty sure I'm doing something wrong but can anyone clarify the Dedicated workflow for me a bit?
Note that I'm using Git for source control, if that makes any difference.
Thanks in advance.
Back to top
View user's profile Send private message
Brian Donahue

Joined: 23 Aug 2004
Posts: 6678

PostPosted: Mon Mar 04, 2013 3:51 pm    Post subject: Reply with quote


SQL Source Control supports two development models. Simply put:
Dedicated=everyone works on their own individual SQL Server database, then commits the changes to source control. Changes and conflicts are handled by your versioning system
Shared=Everyone updates a single SQL Server database. Changes are audited by SQL Source Control.

At the time of commit SQL Source Control turns the database into a set of SQL scripts, and saves those to the working base.

For most source control systems like TFS and SVN, this also commits to the versioning system. For GIT, there needs to be a separate push to get the files to the server.

The whole idea of SQL Source Control as a product is that in either development model, changes are made directly to the database, then converted to script and submitted to a repository. Another approach would be the opposite and edit the script files and get the build system to create a database from those, but SQL Source Control does not work in that way.
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