Import existing SQL database into Windows Azure

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

Is it possible to import an existing SQL database into Windows Azure.
I have a cloud SQL database hosted by a different service provider
What process would I have to go through to use this inside my Azure account?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Well yes you can import it. You cannot do a normal backup restore on Azure but you can import the tables and data. My suggestion would be to first create the table structure on Azure using SQL Scripts. Same for all the stored procedures, functions and views.

Once you have it, you can use SQL Server Management console to connect to both instances and export the data from one instance to another one.
Éric MoreauSenior .Net Consultant
Top Expert 2016
Commented:
Don't forget that SQL Azure is not the full SQL Server, some features are missing. If you are using tools like Red Gate SQL Compare/SQL Data Compare, conversion is easy.
PadawanDBAOperational DBA
Commented:
First things first, are you talking about an Azure VM or SQL Azure?  If the latter, there is a prescribed process for that and there are pre-reqs that you must meet.  For the full list of detailed methods to migrate a database to SQL Azure, see here: https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/.  If you are migrating to an Azure VM - this is essentially just another VM and you can do migrations using any strategy you would use for an instance migration.
Murray BrownASP.net/VSTO Developer

Author

Commented:
Thanks very much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial