Tuesday, April 12, 2016

Migrating data from SQL sever (On Prem) to Azure

I was trying to migrate the data from SQL Server 2012 to Azure DB. There are different ways to this , one of being exporting the data tier and importing back to Azure.

However, during exporting data tier some times you land up with bunch of exceptions as seen below. Its time consuming to get rid of these and sometimes you don't know what to do other than by searching or any trial and error.

I found a very cool tool that does this for you. Please download sqlazuremw for the SQL version you have from codeplex available at https://sqlazuremw.codeplex.com/

I downloaded it for SQL Server 2012 and works like a gem ! 

1. Select the Analyze/Migrate option and connect to source
2. Do the analysis of the source database
3. Connect to target server
4. Start the migration

Haven't seen any issues so far. You could visit http://sqlazuremw.codeplex.com/workitem/list/basic for any known issues.

Monday, April 11, 2016

Azure - Getting Started

Getting Started for Azure

I have come across many of the people asking where do we start with Azure Portal. What is in there , what would be the price if I need to host a simple website along with SQL as a backend.

Let's start with Azure basics.  The Azure™ Services Platform (Azure) is an internet-scale cloud services platform hosted in Microsoft data centers, which provides an operating system and a set of developer services that can be used individually or together. Azure’s flexible and interoperable platform can be used to build new applications to run from the cloud or enhance existing applications with cloud-based capabilities. Its open architecture gives developers the choice to build web applications, applications running on connected devices, PCs, servers, or hybrid solutions offering the best of online and on-premises.

I would suggest to go for an Azure trial account for a month before you opt for any subscription.

To sign up Azure , click  https://account.windowsazure.com/signup 

At the bottom click "Sign Up" to fill in all the required details to get started. You would also need to fill in card details , don't worry its safe & charges won't  be deducted till you are under free month subscription. 

You receive $200 of Windows Azure credits with the Free Trial.  The choice is yours on how you use your Windows Azure credits. You could use it on Virtual Machines, Web Sites, Cloud Services, Mobile Services, Storage, SQL Database, on whatever you need. To protect you from accidentally incurring charges for usage beyond the included offer amount please set the Spending Limit feature by default to a limit of $0.

Once you are done with initial sign up process, please click the URL  https://portal.azure.com/.


After logging on to the Azure Portal, click the "New" button & provision whatever you like. e.g. You would need to publish an MVC website along with a SQL database.

Click the "New" link , then "MarketPlace" -> "Everything". You would see "WebApp + SQL" as shown below. Click the same to create an app along with SQL database. 


Please follow the link https://azure.microsoft.com/en-us/marketplace/partners/microsoft/websitesqldatabase/
 to get more details on publishing your first app.

Enjoy Azure!