This guide is a sample run on how to migrate data between Azure SQL Server database using SQL Server Import and Export Wizard.

Requirements:

1. SQL Server 2019 Import and Export Data (64-bit) (An error will occur when using 32-bit version)

2. Target tables must be empty to avoid errors.

1. Start Export Wizard

2. Select the Source Database.

3. Select the Destination Database.

4. Specify the Query option.

5. Set Source and Destination Table.

IMPORTANT: Enable identity insert needs to be enabled.

6. Indicated Package Option.

7. Run wizard.

8. Migration Completed.