<commit_before>---
title: Seamless Migration to Azure SQL Database with Database Migration Assistant
layout: post
modified: 
categories: blog
excerpt: 
tags:
- datamigration
- azure
- azuresqldb
date: '2017-12-02'
image:
  feature: 
share: true,
comments: true
---
Back in May, at the //Build conference, Microsoft [announced](https://azure.microsoft.com/en-us/blog/azure-database-migration-service-announcement-at-build/) a new service - the Azure Database Migration Service. Now the service is [available](https://azure.microsoft.com/en-us/services/database-migration/) in public preview. It is the quickest and easiest way to migrate on-premises databases into the cloud. The new service uses a simple, guided process to streamline the migration and allow for current operations to continue while the migration is happening.

It is as easy to use as the documentation claims. To get started, you will need the following:

1. A blank Azure SQL Database.
2. A source database you want to migrate.
3. The Database Migration Assistant tool (installed where it has access to the source database).

First step is to perform an assessment to see if there are any incompatibilities. For this you need to use the Data Migration Assistant ([download here](https://www.microsoft.com/en-us/download/details.aspx?id=53595)). 
<commit_msg>Edited title and fixed link<commit_after>---
title: Seamless Migration to Azure SQL Database with the Database Migration Service
layout: post
modified: 
categories: blog
excerpt: 
tags:
- datamigration
- azure
- azuresqldb
date: '2017-12-02'
image:
  feature: 
share: true,
comments: true
---
Back in May, at the Build conference, Microsoft [announced](https://azure.microsoft.com/en-us/blog/azure-database-migration-service-announcement-at-build/) a new service - the [Azure Database Migration Service](https://azure.microsoft.com/en-us/services/database-migration/). Now the service is available in public preview. It is the quickest and easiest way to migrate on-premises databases into the cloud. The new service uses a simple, guided process to streamline the migration and allow for current operations to continue while the migration is happening.

It is as easy to use as the documentation claims. To get started, you will need the following:

1. A blank Azure SQL Database.
2. A source database you want to migrate.
3. The Database Migration Assistant tool (installed where it has access to the source database).

First step is to perform an assessment to see if there are any incompatibilities. For this you need to use the Data Migration Assistant ([download here](https://www.microsoft.com/en-us/download/details.aspx?id=53595)). 

{'fraction_non_alphanumeric': 0.07790262172284644, 'fraction_numerical': 0.01198501872659176, 'mean_word_length': 4.473360655737705, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 6, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 4, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3107043', 'n_tokens_mistral': 740, 'n_tokens_neox': 690, 'n_words': 337}