I’ve already spoken about source controlling database using Visual Studio Online and Red-Gate SQL Source Control in this post. The described kind of approach brings a drawback, due to the nature of the plugin and VSO APIs: High latency when getting and syncing local database and workspaces.
Due to this problem, I’ve changed my settings when linking my databases, switching them from “Team Foundation Server (TFS)” to “Working folder“, as in the following picture:
Continue reading “SQL Server with Red-gate SQL Source Control – Working folder management with TFS”
Italian Community Days 2014 are coming!
The event is totally free!
You fill find:
- A very good agenda.
- Three days of tech full immersion, dal 25 al 27 febbraio.
- Five tracks
- Sixty speakers!
I’ll present my “database under source control” session. My “mission” is to bring ALM knowledge on database side. I think that this topic is often underestimated.
here is the list of cummunities that will follow the event:
Click here for more info.
So, spread the word! hashtag: #CDays14
What are you waiting for? Subscribe now!
You can download the english version of my sessions at SQL Saturdays (on SlideShare):
SQL Saturday 257 in Verona: “Put databases under source control”
SQL Saturday 264 in Ancona: “Put databases in ALM backgrounds” (a special thanks to Gian Maria Ricci)
Stay Tuned! 🙂
“Put databases under source control” slide deck is available here. The SQL Saturday – Verona event was a great success. Now we’re waiting for SQL Saturday in Ancona on 13th December. See you there!
Stay tuned 🙂
This year I will speak at PASS SQL Saturday in Verona with a session based on database and source control management.
“PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers,
providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers.
Whether you’re attending a SQLSaturday or thinking about hosting your own, we think you’ll find it’s a
great way to spend a Saturday – or any day. “
I would like to share my experience in using Visual Studio
tools for database source control and continuous integration with TFService
. So, I’ll wait for you all!
In a previous post we’ve seen how to share the SQL Prompt snippet folder to the development team. We’ve used dropbox for sharing and powershell to copy files between the default directory and the new place (changing also the related registry keys). In this post we’ll focus on how to share all the Red-Gate development tools using Team Foundation Server or Team Foundation Service for team sharing (TFService and TFS Express are two free solution).
The requirements are:
– at least a folder, that will be shared to all team members
– the tools must support the customization of the configuration folders
– a script (powershell in the following samples) that can change the configuration folders
Keep in mind that we’re talking about third party tools, plugged in to SQL Server Management Studio. We will speak about:
- SQL Prompt snippets (we will change snippet folder)
- SQL Compare filter and project files (we will change filter and project file startup folder, .scp and .scpf files)
- SQL Data Compare project files (we will change project file startup folder, .sdc files)
We’ll use Team Foundation Service as a Source Control Manager Continue reading “How to share redgate database tools settings with Team Foundation Service”