Skip to content

Latest commit

 

History

History
54 lines (42 loc) · 3.51 KB

migrating-access-data-into-sql-server-azure-sql-db-accesstosql.md

File metadata and controls

54 lines (42 loc) · 3.51 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection ms.custom helpviewer_keywords
Migrating Access Data into SQL Server - Azure SQL Database (AccessToSQL)
Migrating Access Data into SQL Server - Azure SQL Database (AccessToSQL)
cpichuka
cpichuka
01/19/2017
sql
ssma
conceptual
sql-migration-content
intro-migration
bulk loading data
data, loading into SQL Azure
data, loading into SQL Server
migrating databases, loading data
migrating databases, options
options, migrating data
SQL Azure, migrating data into
SQL Server, migrating data into

Migrating Access Data into SQL Server - Azure SQL Database (AccessToSQL)

After you have successfully created the database objects into [!INCLUDEssNoVersion], you can migrate data from Access to [!INCLUDEssNoVersion] or SQL Azure.

Setting Migration Options

Before you migrate data into [!INCLUDEssNoVersion] or SQL Azure, review the project migration options in the Project Settings dialog box. In this dialog box, you can set the migration batch size, table locking, constraint checking, insertion trigger firing, identity and null value handling, and how to handle dates that are out of the [!INCLUDEssNoVersion] range. For more information, see Project Settings (Migration).

Migrating Data

Migrating data is a bulk-load operation that moves rows of data into [!INCLUDEssNoVersion] or SQL Azure in transactions. The number of rows to be loaded into [!INCLUDEssNoVersion] or SQL Azure in each transaction is configured in the project settings.

To view migration messages, make sure the Output pane is visible. If it is not, on the View menu, select Output.

To migrate data

  1. Make sure you have loaded the Access database objects into [!INCLUDEssNoVersion] or SQL Azure.

  2. In Access Metadata Explorer, select the objects that contain the data that you want to migrate:

    • To migrate data for an entire database, select the check box next to the database name.

    • To migrate data from individual tables, expand the database, expand Tables, and then select the check box next to the table. To omit data from individual tables, clear the check box.

  3. Right-click Databases and then select Migrate Data.

You also can migrate data outside of SSMA by using the [!INCLUDEssNoVersion] bcp command-line utility or [!INCLUDEssISnoversion]. For more information about these tools, see [!INCLUDEssNoVersion] Books Online.

Next Step

If you have Access database applications that you want to continue to use after migration, link the Access database tables to the [!INCLUDEssNoVersion] or SQL Azure tables. For more information, see Linking Access Applications to SQL Server.

See Also

Migrating Access Databases to SQL Server
Setting Conversion and Migration Options