Now the check-in screen pops up, where you can “tag” your check-in:Ĭongratulation! You just checked in your first code in VS Online! In the next window you are asked for the source control server (click okay if your VS Online URL is selected), and you see the project explorer:Ĭlick on “MySQLProject”, and click OK. If you want to check-in your solution or project, you can right-click it in the Solution Explorer, and choose “Add Solution to Source Control”:Īnother way of doing it, is by clicking on File => Source Control => Add Solution to Source Control. You can open the “Solution Explorer” by clicking on View => Solution Explorer (or Ctrl+Alt+L). Now that you have a project, it might be handy to show what’s in the solution (if you don’t have that on your screen already). In SSMS, click on File => New => Project (or Ctrl+Shift+N), and choose “SQL Server Scripts”: Now that we’ve installed the source control providers, it’s time to create our SQL Scripts project. If you close the windows that are shown, you end up in your source control project overview:Ĭreating a SQL Server Scripts project/solution Log in with your Microsoft Live account (the same you used to create your VS Online profile), and you’re authenticated:Īt this point, your source control is added, and you’ll see it in the overview screen: Once you’ve done that a login screen pops up. Now you need to enter your account URL in the textbox: In the window that opens, click “Servers…”: In this menu, click on “Open from Source Control”.
After the installation, you get a new menu in SSMS for source control: The next step is to configure SSMS, to use the source control provider you just installed. On this page, you need to create a project before you can check in any files: If you log in to the website, and you go to your account url (.), you see the “Create your first team project” page.
If you install the 64-bit version, it won’t work (and trust me on this, I’ve made that mistake before!).Īt this point, I’m assuming you have an account for VS Online.
If you’re running the 32-bit version of SSMS, you need to download the 32-bit version of the provider. This installs the provider, that takes care of the communication with VS Online.įor this installation, it’s important that you download the right version. The second and last installation is the “Microsoft Visual Studio Team Foundation Server 2013 MSSCCI Provider”. This install requires a reboot, so please take that into account! This installs the team explorer, that you need to get things from and check thing into VS online. The first thing you need to download is the “Team Explorer for Microsoft Visual Studio 2013”. In order to use VS Online, you need to install some extra things on your machine. sql code files into VS Online? Let’s take a look. You can login on the website with your Microsoft Live account, enter some information (like a username, etc), and you’re ready to go!īut how do you go from writing a query in SQL Server Management Studio (SSMS), to checking in your.
This is a free online source control system, that you can use once you created an account. So looking for an easy way out, I focused on Visual Studio Online (VS Online). But source control is a much a part of the backup process as the actual database backups. But what about source control for your scripts? Most of us don’t use source control in our daily job.
We make sure the backup process runs as expected, and (hopefully) we restore a backup every now and then to test if the restore process works. As database professionals, we’re all aware of the importance of backups.