Answered by:
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
Wednesday, February 8, 2012 11:20 AM
Answers
-
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.
- Proposed as answer by Horizon_Net Wednesday, February 8, 2012 12:14 PM
- Marked as answer by Kenny_I Thursday, February 9, 2012 11:04 AM
Wednesday, February 8, 2012 11:30 AM
All replies
-
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.
- Proposed as answer by Horizon_Net Wednesday, February 8, 2012 12:14 PM
- Marked as answer by Kenny_I Thursday, February 9, 2012 11:04 AM
Wednesday, February 8, 2012 11:30 AM -
What is most simple solution for demo?
Does all options need firewall configurations in our network?
Kenny_I
Wednesday, February 8, 2012 12:56 PM -
Please refer to SQL Azure trainning course for how to migrate existing database to cloud below:
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 msdnmg@microsoft.com Microsoft One Code Framework
Thursday, February 9, 2012 4:33 AM