Import existing SQL database into Windows Azure

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?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Abhigyan SrivastavaCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Éric MoreauSenior .Net ConsultantCommented:
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 DBACommented:
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 BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.