![]() ![]() On the Access Metadata Explorer pane, right-click a database, and then select Create Report. Select Add Databases, and then select the databases to be added to your new project. Provide a project name and a location for your project and then, in the drop-down list, select Azure SQL Database as the migration target. Select File, and then select New Project. To create an assessment, do the following: ![]() Use SSMA for Access to review database objects and data, and assess databases for migration. Ensure that you have connectivity and sufficient permissions to access both source and target.Īfter you've met the prerequisites, you're ready to discover the topology of your environment and assess the feasibility of your Azure cloud migration.Download and install SQL Server Migration Assistant for Access.Verify that your source environment is supported.Prerequisitesīefore you begin migrating your Access database to a SQL database, do the following: In this guide, you learn how to migrate your Microsoft Access database to an Azure SQL database by using SQL Server Migration Assistant for Access (SSMA for Access).įor other migration guides, see Azure Database Migration Guide. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |