Migrating Data into SQL Server Using SSMA

 

SSMA provides flexibility for you to migrate your data with one of the two options below: 

 

  1. Client side data migration engine : This option migrate data through the client machine where SSMA is installed and provides a quick and easy way to migrate smaller database into SQL Server.

 

  1. Server side data migration engine: this option migrate data directly from the source database to the target database and should be considered when migrating large database

 

 

In order to enable server side data migration engine, you will need the following:

 

  1. Install SSMA Extension Pack

SSMA extension pack installation file comes in the SSMA download but requires separate installation:

 

  1. SQL Server Agent

The data migration operation is initiated from SQL Server through a SQL Agent job.

 

Note that SSMA provides a warning when connecting to target when SQL Server Agent is not running:  "Common Requirement: SQL Server Agent is not running. You must start SQL Server Agent to use Server-side data migration engine". You can ignore this warning if you do not plan to perform data migration or if you decide to use client side data migration engine.

 

You can set the data migration option through the project setting:

 

  1. Navigate to Tools menu and go to Project Settings
  2. Select the migration engine option from the Migration menu