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.