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.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Using Source Control to Deploy Schema Changes

Postby rlrcstr » Mon Oct 08, 2012 1: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?

Thanks.

J
rlrcstr
 
Posts: 3
Joined: Fri Jun 22, 2012 9:19 am

Postby Chris Auckland » Wed Oct 10, 2012 9: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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby GrantDG » Wed Oct 17, 2012 1: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:
GrantDG
 
Posts: 1
Joined: Wed Oct 17, 2012 1:05 am

Almost works

Postby curtmiller66 » Mon Feb 24, 2014 8: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.
curtmiller66
 
Posts: 2
Joined: Thu Jul 05, 2012 7:37 pm
Location: Issaquah, WA


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests