How to migrate ADManager Plus from one version of Microsoft SQL server to another

How to migrate ADManager Plus from one version of Microsoft SQL server to another

Objective: To migrate ADManager Plus from one version of Microsoft SQL server to another.

SolutionYou can use any one of the following built-in methods from Microsoft SQL to migrate the ADManager Plus data from one version of Microsoft SQL server to another.

Method 1: Using the Detach and Attach Method
  1. Log in to the Microsoft SQL Server Management Studio.

  2. Right-click on the DB that you wish to move, click Tasks and then click Detach.

  3. In the Detach DB window that pops up, select the Drop Connections and Update Statistics options, and click OK.

  4. Navigate to the storage path of the DB. For instance, C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA.

  5. Copy the .mdf and .LDF files (Ex: admp.mdf and admp_log.LDF) and save the files in the desired location.

  6. Log in to Microsoft SQL Server Management Studio, right click on the destination database, click on Tasks, and click Attach.

  7. In the Attach DB window that pops up, click Add.

  8. Select the .mdf file that you saved in step 5 and click OK.

Note: When you select the .mdf file, the .LDF file gets selected automatically.

  1. Navigate to the installation folder of ADManager Plus. Go to the \conf folder and open the database_params file.

  2. Change the SQL server location and DataBase name, so that the product is pointed to the new DB.


Method 2: Using the Import Data Method: 

  1. Log in to the Microsoft SQL Server Management Studio.

  2. Right click on the DB to which you wish to move the data, click on Tasks and click on Import Data.

  3. In the SQL Server Import and Export window that opens up, click Next.

  4. In the Data Source window that opens up, specify the following:

    • Server Name:

    • Authentication (used to login to SSMS)

    • Database

Note: In the Data Source drop down, select SQL Server Native Client if it is not selected already.

  1. Click Next.

  2. Under the Destination windows, enter the following details:

  • Server Name (This will be detected automatically. You can also change the destination using this option).

  • Authentication

  • Database (This will be detected automatically. You can also change the destination using this option)

Note: In the Data Source drop down, select SQL Server Native Client if it is not selected already.

  1. Click Next.

  2. Under the Specify Table Copy or Query field, choose the Copy Data From One or More Tables/Views and click Next.

  3. Under Select Source Tables and Views field, choose the tables to be copied from source, and use the Edit Mappings to select the tables from the left column. Select particular table operations and click Next.

  4. Select the Run Immediately option and click Next.

  5. Click Finish.



                    New to ADSelfService Plus?

                      • Related Articles

                      • How to migrate ADManager Plus from 32-bit to 64-bit in the same server

                        To migrate ADManager Plus from the 32-bit version to the 64-bit version, you need to take a backup of the product, install the 64-bit version of ADManager Plus, and then restore the backup to this new instance. Note: Upgrade the current instance ...
                      • How to migrate ADManager Plus database to MS SQL in AWS?

                        Steps to migrate ADManager Plus database to MS SQL server in Amazon Web Services Login to your Amazon web services account. Click the Relational Database System (RDS) instance which has been created. Open command prompt in <Installation ...
                      • How to apply the service pack to update ADManager Plus

                        You can update ADManager Plus to a higher version by applying the appropriate service pack downloaded from this page. Note: If you have enabled High Availability, proceed with these steps after applying the service pack. Alternatively, if you have ...
                      • How to integrate ADManager Plus with Azure SQL database

                        ADManager Plus can be integrated with a list of databases to facilitate efficient AD management. This specific integration with Azure SQL database allows administrators to synergistically manage AD objects from their Azure SQL instance itself. ...
                      • How to integrate ADManager Plus with AWS SQL database

                        ADManager Plus can be integrated with a list of databases to facilitate efficient AD management. This specific integration with AWS SQL database allows administrators to synchronize data from AWS SQL to AD to efficiently provision user accounts and ...