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 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 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.

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.

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

Making sure the browser displays the new data Simply hit RefreshYou should see the updated data

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.