![]() Address the problems based on the recommendations. Alternatively, you can choose Convert Schema from the top navigation bar after selecting your schema.Īfter the conversion completes, compare and review the structure of the schema to identify potential problems. Right-click the schema, and then choose Convert Schema. Choose your target database from the drop-down list, or provide a new name, in which case a database will be created on the target server.Enter connection details to connect to Azure SQL Managed Instance.Select Connect to Azure SQL Managed Instance. Right-click the node, and then choose Add statements. (Optional) Add dynamic or ad hoc queries to statements. ![]() To convert the schema, follow these steps: You can change the type mapping for each table by selecting the table in the Db2 Metadata Explorer. Validate the default data type mappings, and change them based on requirements if necessary. The default location for the report is in the report folder within SSMAProjects.įor example: drive:\\Documents\SSMAProjects\MyDb2Migration\report\report_. You can also open the report in Excel to get an inventory of Db2 objects and the effort required to perform schema conversions. Review the HTML report to understand conversion statistics and any errors or warnings. Alternatively, you can choose Create report from the navigation bar after selecting the schema. Right-click the Db2 schema you want to migrate, and then choose Create report. On Connect to Db2, enter values for the Db2 connection details. Then select Azure SQL Managed Instance as the migration target from the drop-down list, and select OK. Provide a project name and a location to save your project. To create an assessment, follow these steps: Assess and convertĬreate an assessment by using SQL Server Migration Assistant. Connectivity and sufficient permissions to access both source and target.Īfter you have met the prerequisites, you're ready to discover the topology of your environment and assess the feasibility of your migration.A target instance of Azure SQL Managed Instance.To download SQL Server Migration Assistant (SSMA) for Db2.To verify that your source environment is supported.To migrate your Db2 database to SQL Managed Instance, you need: This guide teaches you to migrate your IBM Db2 databases to Azure SQL Managed Instance, by using the SQL Server Migration Assistant for Db2.įor other migration guides, see Azure Database Migration Guides.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |