Using Source Control to Deploy Schema Changes

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Using Source Control to Deploy Schema Changes

Postby rlrcstr » Mon Oct 08, 2012 12:17 am

WHen I try to deploy schema changes to an Azure DB, SQL Source Control complains that the temp db's aren't supported. Is there a trick to getting this to work?


Posts: 7
Joined: Fri Jun 22, 2012 8:19 am

Postby Chris Auckland » Wed Oct 10, 2012 8:37 am

Thanks for your post.

We would recommend that you you SQL Compare to deploy a database revision to an Azure database.

Are you using Azure as a development server? We would normally recommend users to develop locally, and then to deploy to Azure rather than develop directly on an Azure database.
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Postby GrantDG » Wed Oct 17, 2012 12:09 am

Is there any plan to support Azure from SQL Source Control..?

It's become such a part of my workflow I'm lost without it! :cry:
Posts: 1
Joined: Wed Oct 17, 2012 12:05 am

Almost works

Postby curtmiller66 » Mon Feb 24, 2014 7:00 pm

Everything works perfectly in Azure except you get an error Invalid object name 'fn_listextendedproperty'. since there are no extended properties. If that error were ignored, I would think everything was perfect.
Posts: 2
Joined: Thu Jul 05, 2012 6:37 pm
Location: Issaquah, WA

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests