Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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!
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
Thanks James... This really helps in this and other projects I am working on!
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.
Continue discussion
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!
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
Thanks James... This really helps in this and other projects I am working on!
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.