User Interface Reference(AccessToSQL)
This section includes Help topics for SQL Server Migration Assistant (SSMA) for Access.
Use the Advanced Object Select dialog box to find database objects by using filter criteria, and then select or clear those objects.
Use the Assessment Report dialog box to analyze the conversion of Access database objects, and to estimate how long the migration will take.
Use the Connect to SQL Server dialog box to connect to the instance of SQL Server that you want to migrate to.
Use the Connect to SQL Azure dialog box to connect to the instance of SQL Azure to which you want to migrate to.
The Convert, Load, and Migrate dialog is part of the Migration Wizard, and also appears when you use the Convert, Load, and Migrate command.
Use the Customer Feedback Options dialog box to control if SSMA sends usage data to Microsoft.
Appears after data migration and reports migration successes and failures for each table.
Use the Edit Type Mapping dialog box to create or edit the mapping of data types between the source and target databases and database objects.
Use the Select Files page of the Find Databases Wizard to select which Access databases to add to the SSMA project.
Use the Select Locations page of the Find Databases Wizard to specify locations to search for Access databases files on a network, on a computer, or in a folder that match search criteria.
Use the Verify Selection page of the Find Databases Wizard to confirm which databases will be added to the SSMA project.
Use the Editor page of the Global Settings dialog box to configure code editor options.
Use the Editor page of the Global Settings dialog box to configure default dialog and warning settings.
Use the Logging page of the Global Settings dialog box to configure logging.
Use the Output Window page of the Global Settings dialog box to configure the display of the Output pane and Error Window pane.
Use the Migration Wizard to guide you through the migration process.
Use the New Project dialog box to create a new SSMA project.
Use the Conversion page of the Project Settings dialog box to specify how SSMA converts indexed memo columns, primary keys, foreign key constraints, timestamps, and tables without indexes.
Use the GUI page of the Project Settings dialog box to specify how much data appears on the Data tab.
Use the Migration page of the Project Settings dialog box to specify 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 SQL Server range.
Use the Type Mapping page of the Project Settings dialog box to specify the default type mappings for all databases and database objects in the SSMA project.
Use the SQL Azure page of the Project Settings dialog box to specify the database suffix and also the heartbeat timeout interval.
The Save Metadata dialog box appears when you save a project that is missing metadata.