Using Source Control to Deploy Schema Changes

rlrcstrrlrcstr Posts: 9 Bronze 2
edited February 24, 2014 2:00PM in SQL Source Control Previous Versions
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
· Share on Twitter

Comments

  • Chris AucklandChris Auckland Posts: 769
    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
    · Share on Twitter
  • GrantDGGrantDG Posts: 1
    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:
    · Share on Twitter
  • curtmiller66curtmiller66 Posts: 2
    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.
    · Share on Twitter
Sign In or Register to comment.