Creating an On Premise Database and MVC Web Application and Migrating to Windows Azure and SQL Azure-Step 5 of 10

Previous Posts that you should review Step 1 https://blogs.msdn.com/b/brunoterkaly/archive/2010/06/12/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-1-of-10.aspx Step 2 https://blogs.msdn.com/b/brunoterkaly/archive/2010/06/11/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure.aspx Step 3 https://blogs.msdn.com/b/brunoterkaly/archive/2010/06/27/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-3-of-10.aspx Step 4 https://blogs.msdn.com/b/brunoterkaly/archive/2010/06/28/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-4-of-10.aspx

Introduction SQL Azure We will migrate our database to SQL Azure in this post. There are many reasons why SQL Azure is a good idea. Microsoft® SQL Azure™ (formerly SQL Server Data Services and later SQL Services) Database is a cloud-based relational database service built on Microsoft SQL Server® technologies It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud SQL Azure Database helps to ease provisioning and deployment of multiple databases. Developers do not have to install, setup, patch or manage any software High availability and fault tolerance is built-in and no physical administration is required. SQL Azure Database supports Transact-SQL (T-SQL). Customers can use existing knowledge in T-SQL development and a familiar relational data model for symmetry with existing on-premises databases

 

Navigate to https://sql.azure.com

The portalThe SQL Azure Portal allows you to manage your database. Note that the server name of my particular database is bjzkzsxp9c.database.windows.net. Your database will have it’s own address.

The ‘master’ database is always there  stocksdb was created by click on ‘Create Database’ Before you can move your data from on-premise to SQL Azure, you will need to have a database ready to accept the data.

‘Create Database’ can be used  Options for a business user Notice that the business edition gives you several options in terms of the ‘size’ of the database you want.

Take note of the server name Needed in connection stringIn the next blog post we will need to adjust our connection string so that our data comes from SQL Azure. bjzkzswxp9c.database.windows.net is the name of our server. Yours will be different.

SQL Azure Migration Wizard Found at CodePlexThe URL is https://sqlazuremw.codeplex.com

Analyze and Migrate  Migrating the SQL DatabaseSelect SQL Databaes below.

The ‘source’ of our data localhostlocalhost is the local ‘on-premise’ version of our database. We are selecting the data that we want to copy to SQL Azure.

Choose the data that you want to migrate The data is moving to the cloudBy selecting StocksDatabaseOnPremiseDb we are identifying the database that we wish to push to the cloud.

Narrowing down the data to migrate  You don’t need to migrate ALL the dataIn this case, we only have one table and a stored procedures that we wish to migrate. We are choosing ‘Script all database objects.’

Generating the SQL Script Purpose of scriptThe SQL script that we generate will be used to migrate data. Clicking ‘Yes’ followed by ‘Next’ will take us to the next step. We will need to select a target database shortly.

Connecting to SQL Azure Verify your Server NameAt this stage we wish to identify where we want to put our data. We have already identified the source. Now we need to identify the target. This is where you type in the server name that you got from the SQL Azure Portal.

 

 

Choosing the target database

StocksDBPreviously, when we were at the portal, we created a database called ‘stocksdb’It is a simple case of going to the AQL Azure portal and clicking ‘Create Database’ and then giving the database a name of ‘stocksdb’

Using SQL Server 2008 R2 Management Studio  Verifying our data migrated successfullyThe good news is that SQL Server Management Studio can be used with SQL Azure. This is a big deal and many of my audiences loved that this is true.

New Query Editor Window  Right click on dbo.StocksWe will just illustrate a ‘select’ statement.

We have completed this post.

Future Posts

MVC App still needs to be put in the cloudWe have succeeded in putting the data in the cloud, but our application (MVC Web App) still needs to be migrated. that is the subject of future posts.