How to deploy database to Azure SQL Server?

Question

I have .Net web application using .Net Framework 2.0 developed with VS2005 that I want to take to Azure.
 
1. I opened the project with VS2010 (SDK1.6 installed) and it automatically converted the project
2. I build the project succesfully and Was able to open web site in browser
3. I added Windows Azure Deployment Project
4. I build the project
5. Published to project and I can see that login page of web application is displayed.

How should I deploy databases? How to copy or sync from OnPremises?
The web application uses 2 SQL Server database instances so 2 different definitions are needed.

Then How to define to the application that it find database connections?

---

Kenny_I

Answer 1

Hi,

For learning SQL Azure, you can go through the link: http://msdn.microsoft.com/en-us/gg282141 

For migrating SQLServer databases to SQL Azure, you can go through the link: http://msdn.microsoft.com/en-us/library/windowsazure/ee730904.aspx 

You can also use SQL Azure Migration Wizard for migration of databases. Its a great automated tool available at http://sqlazuremw.codeplex.com/ 

Please note that there are a few differences in SQL Server and SQL Azure. You can go through the link:http://msdn.microsoft.com/en-us/library/windowsazure/ee336241.aspx 

I hope this information helps!!

---

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Thanks! Vaibhav Gujral.

Answer 2

What is most simple solution for demo?

Does all options need firewall configurations in our network?

---

Kenny_I

Answer 3

Hi,

Please refer to SQL Azure trainning course for how to migrate existing database to cloud below:

http://msdn.microsoft.com/en-us/wazplatformtrainingcourse_migratingdatabasestosqlazure_topic2#_Toc303335164

And if you have more SQL Azure issues, please post it on SQL Azure forums:

http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/threads

Hope it can help you.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework