| title | Save Metadata (AccessToSQL) | |
|---|---|---|
| description | Save Metadata (AccessToSQL) | |
| author | nilabjaball | |
| ms.author | niball | |
| ms.reviewer | randolphwest | |
| ms.date | 12/30/2025 | |
| ms.service | sql | |
| ms.subservice | ssma | |
| ms.topic | concept-article | |
| ms.collection |
|
The Save Metadata dialog box prompts you to load metadata into your SQL Server Migration Assistant (SSMA) project before saving it. You can use this metadata create a complete project file that you can use offline and send to other people, such as technical support personnel.
To access the Save Metadata dialog box, save the project. If any metadata is missing, SSMA displays the Save Metadata dialog box.
The name of each database in the project.
Indicates if metadata is loaded into the SSMA project, or if metadata is missing.
SSMA loads metadata to the project when needed. You see metadata automatically when you browse metadata and convert schemas.
Selects all listed databases.
Clears the check box for all databases with missing metadata. You can't clear the check box if metadata is loaded.
Saves the project and adds metadata for selected databases that are missing metadata.
Cancels the save operation. Missing metadata isn't loaded into the project.