New Project (SSMA) (AccessToSQL)

Use the New Project dialog box to create a new SSMA project. To access the New Project dialog box, on the File menu, click New Project.

Options

Name

Enter the name of the project. SSMA will append the file extension.

Location

Enter or browse to the folder or network location to save the project.

MigrateTo

Select one of the target database version from below list

  • SQL Server 2005

  • SQL Server 2008

  • SQL Server 2012

  • SQL Server 2014

  • SQL Server 2016

  • SQL Azure

Important

A new project of 'SQL Azure' type requires, SQL Server Native Client (SNAC) version 10.5 or above to link Access tables to Azure SQL Database.
You can obtain the latest version of SNAC from Microsoft SQL Server 2008 R2 Feature Pack.