Support
 
Phone Live Chat
 
Support
 
US: +1 888 720 9500
US: +1 800 443 6694
Intl: +1 925 924 9500
Aus: +1 800 631 268
UK: 0800 028 6590
CN: +86 400 660 8680

Direct Inward Dialing: +1 408 916 9393

 
 
 
 
 
Knowledge Base

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.

Solution:

You 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. Login 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. Example: 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. Login 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.
  9. Navigate to the installation folder of ADManager Plus. Go to the \conf folder and open the database_params file.
  10. 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. Login 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:
    1. Server Name
    2. Authentication (used to login to SSMS)
    3. Database
      NOTE: In the Data Source drop down, select SQL Server Native Client if it's not selected already.
  5. Click Next.
  6. Under the Destination windows, enter the following details:
    1. Server Name (This will be detected automatically. You can also change the destination using this option).
    2. Authentication
    3. 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's not selected already.
  7. Click Next.
  8. Under the Specify Table Copy or Query field, choose the Copy Data From One or More Tables/Views and click Next.
  9. 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.
  10. Select the Run Immediately option and click Next.
  11. Click Finish.

 

Request Support

Need further assistance? Fill this form, and we'll contact you rightaway.

  • Name
  • Email*
  • Phone Number
  • Country
  • Problem Description
  •  
    By clicking 'Submit', you agree to processing of personal data according to the Privacy Policy.
  •  

Select a language to translate the contents of this web page:

ADManager Plus Trusted By

The one-stop solution to Active Directory Management and Reporting
Email Download Link