No new comments.
View All Comments
No new messages.
View All Messages
No new notifications.
View All Notifications
LEARN: Introduction to Entity Framework
An Interview Question
Ask a Question
How do I
Internet & Web
Coding Best Practices
Internet of Things
Universal Windows Platform
VR and AR
Databases & DBA
Design Patterns & Practices
C, C++, MFC
Request a new Category
SQL Azure - Options For Migrating an Existing SQL Database To Cloud
In this series of articles we are going to see how to migrate an existing database to the cloud and the options available to do that such as using the traditional approach of migrating using scripts, some 3rd party tools and the migrations wizards.
Migrating a database from the local server to the Azure cloud is something we require on a daily basis to synchronize the servers and make it available to all the users and the developers in full phase. We have options available to do that, where Microsoft provides some real-time inbuilt options, also we have some 3rd party tools available for the migration using some nice and cool wizards.
In this article we are going to see the options available with some overview on each option, in the later series of articles we will see in-depth each option for migrating to the SQL Azure server. Let us jump-start to see the available options.
Option 1 - Migrate by generating Script
Use of this option is straight forward, like creating a schema of the database locally and migrating the database by running the script to the destination SQL Azure server. We can use the SQL Generate and Publish Scripts Wizard to do this by simply selecting the options and doing the publish online.
Also we need to take some steps to carry out this operation since some specific tasks are not available with the SQL Azure online database. Since SQL Azure supports only some subsets of the database options we need to modify the script before we run it on the server.
Option 2 - Migrating by using Microsoft Sync Framework 2.1
This option is used to do a migration for an On-Premises database to be available online by synchronizing and also do a sync between 2 or more SQL Azure databases with in the same servers or to the other servers in multiple data centers. We need to use the Microsoft Sync Framework 2.1 to use the sync process between the servers. Let us see this option in detail in future articles.
Option 3 - Migrating by using SQL Azure Migration Wizard
This option is a small Wizard tool built by the Community to migrate between the server and do a complete sync by creating scripts for the objects. This tool was developed and maintained by Codeplex, the official code place for Microsoft tools. Let us see this option in detail in future articles.
So in this article we have seen the options available for doing a migration and a synchronization of data between on-premises and existing databases to the new server or to the old server for synchronization. We will see in-depth the step by step process of how to do these in future articles.
how to Migrate Existing SQL Database to Cloud
migrating database to cloud
SQL Azure Different options to Migrate Existing SQL Database to Cloud
SQL Database to Cloud
AngularJS Login Form With ASP.NET
Creating ASP.NET Core, Angular2 Shopping Cart Using Web API And EF 1.0.1
Calculating Distance Using Google Maps In ASP.NET MVC
Learn Big Data With Me - Hive
Calling A C# Function With jQuery AJAX In ASP.NET MVC
Five Free Productivity Tools That Every Web Developer Should Use
HTTP Get, Put, Post And Delete Verbs In ASP.NET WEB API
Develop Question And Answer Bot Service Using Microsoft QnA Maker
n-layered Architecture Using Entity Framework, Generic Repository And Unit-Of-Work
CRUD Functionality In AngularJS And ASP.NET MVC 5 With Entity Framework Code First Approach