Run validation tests: Run the validation tests against the source and the target, and then analyze the results.Set up the test environment: The test environment should contain a copy of the source database and the target database.Your validation queries should cover the scope you have defined. You must create the validation queries to run against both the source and the target databases. Develop validation tests: To test database migration, you need to use SQL queries.Testing consists of the following activities: Accomplishing this will in some cases require changes to the applications. Remediate applicationsĪfter the data is migrated to the target environment, all the applications that formerly consumed the source need to start consuming the target. Validate the migration by reviewing the data and schema:Īfter the migration is complete, you need to go through a series of post-migration tasks to ensure that everything is functioning as smoothly and efficiently as possible. Provide connection details for both Db2 and SQL Managed Instance.Īfter migration completes, view the Data Migration Report.Ĭonnect to your instance of Azure SQL Managed Instance by using SQL Server Management Studio. To omit data from individual tables, clear the check box. To migrate data from individual tables, expand the database, expand Tables, and then select the check box next to the table. To migrate data for an entire database, select the check box next to the database name. ![]() Alternatively, you can select Migrate Data from the navigation bar. Right-click the database or object you want to migrate in Db2 Metadata Explorer, and choose Migrate data. In Azure SQL Managed Instance Metadata Explorer, from the Databases node, right-click the database. To publish your schema and migrate your data, follow these steps: This gives you an opportunity to evaluate the source and target schemas offline, and perform remediation before you can publish the schema to SQL Managed Instance.Īfter you have completed assessing your databases and addressing any discrepancies, the next step is to execute the migration process. Save the project locally for an offline schema remediation exercise. In the Output pane, select Review results. 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.
0 Comments
Leave a Reply. |