Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Jeff Kershner 8 posts 38 karma points
    Jul 09, 2015 @ 20:08
    Jeff Kershner
    0

    Deploying Local SQL DB to Azure DB

    I have a local MSSQL. When I deploy my changes to Azure Website, what is the best way to migrate my local Database to Azure Database?

    Is it just a matter of using SSMS and coping tables? Is there a tool or a documented process for this?

    Thanks!

    Copy Link
  • James 251 posts 1169 karma points
    Jul 10, 2015 @ 13:58
    James
    100

    Hello,

    When deploying my local SQL Dbs to an Azure instance i use:

    https://sqlazuremw.codeplex.com/

    Really easy step by step process. Just ensure to select "Schema + Data" when going through it.

    Youll need to configure the firewall on Azure to allow you to deploy to the DB (you can do this on the SQLserver that houses the DB on azure).

    I think you can use SSMS as well just create a script and point it at Azure. You will still need to add the Firewall rule if you do it this way.

    Cheers,

    James

    Copy Link
  • Jeff Kershner 8 posts 38 karma points
    Jul 10, 2015 @ 17:24
    Jeff Kershner
    0

    Thanks James... This really helps in this and other projects I am working on!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft