إشعار
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تسجيل الدخول أو تغيير الدلائل.
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تغيير الدلائل.
After you add Access databases and connect to SQL Server or Azure SQL, SQL Server Migration Assistant (SSMA) displays metadata for these objects. You can now select Access database objects, and then convert the schemas into SQL Server or Azure SQL schemas.
The conversion process
Converting database objects takes the object definitions from the Access metadata, converts them into equivalent Transact-SQL syntax, and then loads this information into the project. You can then view the SQL Server or Azure SQL objects and their properties by using SQL Server or Azure SQL Metadata Explorer.
Important
Converting objects doesn't create the objects in SQL Server or Azure SQL. It only converts the object definitions and stores the information in the SSMA project.
During the conversion, SSMA prints status messages to the Output pane, and error, warning, and informational messages to the Error List pane. Use this information to determine whether you need to modify your Access databases or your conversion process to obtain the desired conversion results. You can also use the information in the Prepare Access databases for migration article to determine what is and isn't converted.
Set conversion options
Before converting objects, review the project conversion options in the Project Settings dialog box. By using this dialog box, you can set how SSMA converts indexed memo columns, primary keys, foreign key constraints, timestamps, and tables without indexes. For more information, see Project Settings (Conversion).
Conversion results
The following table shows the converted Access objects, and the resulting SQL Server or Azure SQL objects:
| Access object | Resulting SQL Server object |
|---|---|
| table | table |
| column | column |
| index | index |
| foreign key | foreign key |
| query | view Most SELECT queries are converted to views. Other queries, such as UPDATE queries, aren't migrated.SELECT queries that take parameters aren't converted, nor are cross-tab queries. |
| report | not converted |
| form | not converted |
| macro | not converted |
| module | not converted |
| default value | default value |
| allow zero length column property | check constraint |
| column validation rule | check constraint |
| table validation rule | check constraint |
| primary key | primary key |
Convert Access objects
To convert Access database objects, first select the objects you want to convert, and then have SSMA do the conversion. To view output messages during the conversion, on the View menu, select Output.
In Access Metadata Explorer, expand Access-metabase, and then expand Databases.
Do one or more of the following steps:
To convert all databases, select the check box next to Databases.
To convert or omit individual databases, select or clear the check box next to the database name.
To convert or omit queries, expand the database, and then select or clear the Queries check box.
To convert or omit individual tables, expand the database, expand Tables, and then select or clear the check box next to the table.
Do one of the following steps:
To convert schemas, right-click Databases and select Convert Schema.
You can also convert individual objects. To convert an object, regardless of which objects are selected, right-click the object, and select Convert Schema.
When you convert an object, it appears in bold in Access Metadata Explorer.
To convert, load, and migrate schemas and data in one step, right-click Databases and select Convert, Load, and Migrate.
Review messages in the Output pane and any errors and warnings in the Error List pane.
Alter tables and indexes
After you convert Access metadata to SQL Server or Azure SQL metadata, and before you load the objects into your target, you can alter the tables and indexes.
In SQL Server or Azure SQL Metadata Explorer, select the table or index you want to alter.
On the Table tab, select the property you want to alter and then enter or select the new setting. For example, you can change nvarchar(15) to nvarchar(20), or select a check box to make a table column nullable.
Move the cursor out of the changed property cell by selecting another row or pressing the Tab key.
Select Apply.
You can now view the changes in the code on the SQL tab.