The Active Directory Migration Tool version 3.2 (ADMT v3.2) requires a preconfigured instance of Microsoft SQL Server® for its underlying data store. You should use SQL Server Express. When you use one of the following versions of SQL Server Express, ADMT installation enforces the following service pack requirements:

As an option, you can use full versions of SQL Server 2005 or SQL Server 2008. In this case, you can install and run the ADMT console on a remote computer, and you can run multiple ADMT consoles on different remote computers. If you use a full version of SQL Server, ADMT installation does not enforce any service pack requirements.

For more information about installing ADMT, see Installing ADMT in the Target Domain (http://go.microsoft.com/fwlink/?LinkId=183996).

Prerequisites for installing ADMT v3.2

Before you install ADMT v3.2, complete the following prerequisite tasks:

  • In Control Panel, use Add or Remove Programs to remove all versions of ADMT earlier than ADMT v3.2.

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

  • Install or upgrade a server computer (preferably a member server) in either your source or target domain environment as necessary to run Windows Server 2008 R2.

    Although you can use ADMT v3.2 to migrate accounts and resources from Active Directory environments that have a domain functional level of Windows Server 2003 or later, you can install ADMT v3.2 only on a server running Windows Server 2008 R2.

    In addition to running Windows Server 2008 R2, the server computer that you use to install ADMT v3.2 must not be installed under the Server Core installation option or be running as 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 installing SQL Server Express, see Install ADMT v3.2 . 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 v3.2

Download SQL Server 2005 Express (http://go.microsoft.com/fwlink/?LinkId=181159), or create a new database instance on an existing SQL Server installation to use with ADMT v3.2. During the SQL Server installation, select Windows Authentication Mode. After you install SQL Server, use the following procedure to install ADMT v3.2.

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 (http://go.microsoft.com/fwlink/?LinkId=83477).

To install ADMT v3.2
  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

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 (http://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 v3.2 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 2005 or SQL Server Express 2008 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 (http://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 v3.0, ADMT v3.1, or ADMT v3.2 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 (http://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.0/v3.1 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.