Migrating a Local TopTeam Database Schema to Azure SQL Managed Instance Using Data Tier Application

Installation

Overview

To migrate an on-premises or local TopTeam Database Schema (and optionally data) to an Azure SQL Managed Instance, use the Export/Import Data-tier Application feature in SQL Server Management Studio (SSMS). This method packages your database into a .bacpac file for easy deployment to Azure.

Step 1. Disable READ_COMMITTED_SNAPSHOT

Before exporting, set the Is Read Committed Snapshot On option to False for the source database.

2. Export the Data-tier Application from Local SQL Server

Open SQL Server Management Studio (SSMS) and connect to your local SQL Server instance.

1. In Object Explorer, right-click the database you want to migrate.
2. Select Tasks > Export Data-tier Application.
3. In the wizard:

  • Click Next on the introduction screen.
  • Choose Export to a BACPAC file.
  • Specify a local path to save the .bacpac file.
  • Click Next, then Finish to generate the file.

3. Import the Data-tier Application to Azure SQL Managed Instance

  1. In SSMS, connect to your Azure SQL Managed Instance.
  2. Right-click on Databases, then select Import Data-tier Application.
  3. In the wizard:
  • Click Next.
  • Browse to the location of your previously exported .bacpac file and select the file.
  • Click Next.
  • Provide a name for the new database (or use the default).
  • Review the settings and click Next, then Finish to start the import.

4. Re-enable READ_COMMITTED_SNAPSHOT

After the import, set Is Read Committed Snapshot On to True for the newly created database.

Related Articles

Installing & Configuring TopTeam Requirements on Azure SQL Managed Instance

Revised: April 22nd, 2025

Tags: