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

Introduction

Previous Posts that you should review

bullet

Step 1
hyperlink

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

bullet

Step 2
hyperlink[4]

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

bullet

Step 3
hyperlink[6]

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

This Post - SQL Server Management StudioThis post will focus on using SQL Server Management Studio to display and manipulate data. Obviously, our MVC app will display the data that we manipulate from SQL Server Management Studio.MyImage

snap0083

Start by selecting the previously inserted data from the database 

Displaying data from the stocks tableYou will note that the data is exactly the same as the data we already inserted.

snap0084

 

snap0085

 

snap0086

Update the database

Issue an update statementNotice we are changing the Description in the stocks table

snap0087

 

snap0088

Making sure the browser displays the new data

Simply hit RefreshYou should see the updated data

snap0089

 

snap0090

Next blog post

Porting our data to SQL AzureThe next post will illustrate how to migrate our data to SQL Azure, from the on-premise version of the SQL Server database.