How can we help you today? How can we help you today?

Using Source Control to Deploy Schema Changes

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
0

Comments

3 comments

Sort by
  • Chris Auckland
    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
    0
  • GrantDG
    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
    0
  • curtmiller66
    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
    0

Add comment

Please sign in to leave a comment.