Share via


Installing ADMT in the Target Domain

Applies To: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2

Applies to: Active Directory Migration Tool 3.2 (ADMT 3.2)

ADMT requires a SQL Server database instance to be previously installed. You can run any version of SQL Server.

  • Installing ADMT

  • Detach an Existing Database File from a Previous Version of ADMT and SQL Server

  • Reconfiguring a Database Installation with Admtdb.exe

  • Reuse an Existing ADMT Database from a Previous Installation

Installing ADMT

ADMT can be downloaded from the Microsoft Connect (https://go.microsoft.com/fwlink/?LinkId=401534) site. It requires a preconfigured instance of SQL Server for its underlying data store. If you use SQL Server Express, the ADMT console must be installed and run locally on the server that hosts the SQL Server Express database instance. If you use a full version of SQL Server, you can install and run the ADMT console on a remote computer, and you can run multiple ADMT consoles on different remote computers.

The rest of this section covers the following installation issues:

  • Prerequisites for installing ADMT

  • Install ADMT

Prerequisites for installing ADMT

Before you install ADMT, complete the following prerequisite tasks:

  • In Control Panel, use Add or Remove Programs to remove all previous versions of ADMT.

    Although ADMT does not support an upgrade from a previous version, you can reuse an existing database from a previous ADMT installation, unless it is a database from ADMT v2 or ADMT v1. For more information, see Reuse an existing ADMT database from a previous installation.

  • ADMT must not be installed on a server that runs Server Core or a read-only domain controller (RODC).

  • Configure a SQL Server database installation with an ADMT instance. You can either download and install SQL Server Express locally or create a database instance for ADMT from an existing SQL Server database.

    For more information about creating an ADMT instance on an existing SQL Server database, see Install ADMT by Reconfiguring a Database Installation with Admtdb.exe.

Install ADMT

Download SQL Server Express, or create a new database instance on an existing SQL Server installation to use with ADMT. During the SQL Server installation, select Windows Authentication Mode. After you install SQL Server, use the following procedure to install ADMT.

Membership in Administrators, or equivalent, is the minimum required to complete this procedure. Review details about using the appropriate accounts and group memberships at Local and Domain Default Groups (https://go.microsoft.com/fwlink/?LinkId=83477).

To install ADMT

  1. In the ADMT download package, double-click admtsetup32.exe.

  2. On the Welcome page, ensure that the recommendations are completed, and then click Next.

  3. On the License Agreement page, click I Agree, and then click Next.

  4. On the Database Selection page, type the server\instance.

    The requirement to type the server name also applies to a local database instance. You can type a dot (“.”) to indicate the local server. By default, the SQL Server Express instance is named SQLEXPRESS.

    For example, to use a default SQL Server Express instance on the local server, type .\SQLEXPRESS.

  5. If you chose a SQL Express installation and a database file ADMT.mdf is not in the default data location %windir%\ADMT\Data, the Database Import page appears. Otherwise, ADMT Setup automatically attaches to that database file, and the Summary page appears.

    On the Database Import page, if you do not need to import data, click No, do not import data from an existing database (Default). If you need to import data from a previous ADMT installation, click Yes, import data from an existing ADMT v3.0 or ADMT v3.1 database, and then, to navigate to the existing database file location, click Browse.

    Before you can import the data from an existing database, you have to detach the database file from SQL Server by using SQL Server commands. For more information, see Detach an existing database file from a previous version of ADMT and SQL Server.

    When you are finished, click Next.

  6. On the Summary page, review the results of the installation, and then click Finish.

Detach an Existing Database File from a Previous Version of ADMT and SQL Server

If you use SQL Server Express, the database is automatically detached when you remove ADMT. The detached SQL Server Express database can be reused as part of another ADMT installation later. In this case, ADMT automatically attaches to the existing database that you specify during installation.

You can detach the ADMT database file from a full SQL Server instance if you have another application that you want to attach to the same database. For example, if you plan to move from a full SQL Server installation to SQL Server Express, or if you have an ADMT database file from an earlier installation that you have attached to SQL Server management tools, it needs to be detached from that database before it can be consumed by ADMT.

To detach a database, you can use the SQL stored procedure:

sp_detach_db [ @dbname = ] 'dbname'

For more information about this stored procedure call, see SQL Server documentation. For more information about how to use SQL Server Management Studio to detach the database, see How to: Detach a Database (SQL Server Management Studio (https://go.microsoft.com/fwlink/?LinkId=183994).

Reconfiguring a Database Installation with Admtdb.exe

If you experience problems with database configuration during installation, or if you specified SQL Server Express during the ADMT installation but want to switch to SQL Server (or vice versa) after installation, you can use Admtdb.exe. The command-line syntax for Admtdb.exe is in the following table.

You can run Admtdb.exe from an elevated command prompt on any server that can target the server computer that is running SQL Server to create the ADMT instance on that server computer.

Syntax Description

admtdb create /{s|server}: "Server\instance"

Installs a new ADMT database or prepares an empty database.

The /server parameter specifies the name of the SQL Server and instance to connect to for the purpose of creating the database. This is a required parameter.

admtdb upgrade /s|server: Server\Instance

Upgrades a previous version of an ADMT v3.0 or ADMT v3.1 database.

The /server parameter, which is required, specifies the name of the SQL Server and instance to connect to for the purpose of upgrading the ADMT v3.0 or ADMT v3.1 database.

Note
Before you upgrade the ADMT database, first open the ADMT console to verify that it is compatible with the database.

admtdb attach [/{a|attach}: "v3x database path"

Attaches an existing ADMT database to the local SQL Server Express instance.

The /attach parameter, which is required, specifies the path to a detached Admt.mdf database file.

To see Help for all Admtdb.exe command-line options, at the command prompt, type admtdb /?.

If you began the migration by using a local SQL Server Express database and then configured a remote instance of a SQL Server database, and you need to switch back to using a local SQL Server Express database, complete the following procedure. In this case, the ADMT database file is already attached to the SQL Express instance. Therefore, there is no need to explicitly reattach it.

If you began the migration by using SQL Server and you want to switch to SQL Server Express, see Reuse an existing ADMT database from a previous installation.

Membership in Administrators, or equivalent, is the minimum required to complete this procedure. Review details about using the appropriate accounts and group memberships at Local and Domain Default Groups (https://go.microsoft.com/fwlink/?LinkId=83477).

To reuse a local database after you configure a remote instance of a SQL Server database

  1. On the local computer, click Start, point to Administrative Tools, and then click Services.

  2. In the Details pane, ensure that the service hosting the SQL Server Express instance is running and that the Startup Type is set to Automatic.

    If the service is not started or if it is not set to start automatically at system startup, click Started, right-click the name of the service, and then click Properties.

  3. On the General tab, in the Startup Type list, click Automatic.

  4. Under Service Status, click Start, and then click OK.

  5. Close Services.

  6. At the command prompt, type the following commands:

Note

The admtdb attach command is necessary only if you previously ran SQL commands to detach the local SQL Server Express instance.

    admtdb attach /{s | Server}:”Local SQL Server Express instance”

    admt config setdatabase /s:Server\Instance.

You can now use the local database.

Reuse an Existing ADMT Database from a Previous Installation

If you want to use an existing (detached) database from an earlier ADMT installation with a local SQL Server instance, you can complete the following procedure.

Note

Membership in Administrators, or equivalent, is the minimum required to complete this procedure. Review details about using the appropriate accounts and group memberships at Local and Domain Default Groups (https://go.microsoft.com/fwlink/?LinkId=83477).

To use an existing (detached) ADMT database with a local SQL Server instance

  1. On the local computer, click Start, point to Administrative Tools, and then click Services.

  2. In the details pane, ensure that the service hosting the SQL Server Express instance is running and that the Startup Type is set to Automatic.

    If the service is not started or if it is not set to start automatically at system startup, click Started, right-click the name of the service, and then click Properties.

  3. On the General tab, in the Startup Type list, click Automatic.

  4. Under Service Status, click Start, and then click OK.

  5. Close Services.

  6. At the command prompt, type the following commands:

    admtdb attach /{s | Server}:”Local SQL Server Express instance” /{a | Attach}:”Path to ADMT v3.x database file to attach"
    
    admt config setdatabase /s: server\instance
    

    You can now use the existing ADMT database with the local SQL Server instance. It is not necessary to run the ADMT installation wizard again. ADMT installation can be run only once. You can perform any subsequent database configuration changes by using the admtdb.exe and admt config setdatabase commands.

    To use the Password Export Server with the new ADMT installation, you need to generate a new encryption key. For more information, see Enabling Migration of Passwords.