We are in the process of migrating OpManager 11.6 to another server. We are migrating PSSQL to MSSQL before the migration.

When we migrate from PSSQL to MSSQL we get the attached error. We deleted the previous SQL DB, so this is a migration from scratch. We are using the instructions from http://help.opmanager.com/migrating_database Please do not send me the same 5 links, we have them all, and read through them all numerous times.

We are stuck at part 5 which I highlighted in red. We click Yes when the question is asked if I want to continue. It does not do anything. The windows goes away and we are back at the same screen.

Please help, we are migrating because the old server has been crawling over the past 4 months. We just bought a new server for this migration.

Thank you very much in advance for your assistance.

(below are the instructions we are following)

Migrating from MySQL to MSSQL (Same steps for PGSQL to MSSQL)

1. Take a backup, cmd > OpManager\bin\backup
2. Execute BackupDB.bat -targetdb mssql (proceed to next step after the backup is completed)     
3. Select Start > Programs > ManageEngine OpManager > DB Manager > DB Configuration
4. A DB Configuration window pops up > Select MSSQL

Configure the following information:

1. DB Host : The name or the IP address of the machine where MSSQL is installed.
2. Port: The port number in which OpManager must connect with the database. Default is 1433.
3. User Name and Password: The user name and password with which OpManager needs to connect to the database.
4. Driver Jars: Specify the path of the Database driver
5. Click OK.

 4.  Restore the data using RestoreDB.bat present under OpManager/bin/backup directory and restart OpManager.

      For ex : C:\<OpManager Home>\bin\backup>RestoreDB.bat "c:\OpManager\backup\BackUp_APR3_2009_17_43_38_8100.zip"

Important Note : If your migrating the database from PostgreSQL or MySQL to MSSQL, please follwo the steps below.

1. Download the SQL Native Client from the link below. You will need to scroll down the page for the Native Client downloads:

   http://www.microsoft.com/download/en/details.aspx?id=16978 Microsoft SQL Server 2008 R2 Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 R2 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API.                                  

   X86 Package (sqlncli.msi) X64 Package (sqlncli.msi) IA64 Package (sqlncli.msi)

   For more details on installing the native client, refer this site: http://msdn.microsoft.com/en-us/library/ms131321.aspx

   Courtesy: http://msdn.microsoft.com                                                                                                                                                                                                     Here is a quick video of SQL Native client installation.

2. Find the files bcp.exe and bcp.rll in MSSQL server and ensure to copy them under opmanager/bin  folder. If the MSSQL server is installed on a 64-bit OS, and OpManager is installed on 32-bit server, the bcp.exe and bcp.rll copied from the MSSQL server will not work on the OpManager machine. You'll need a 32-bit bcp.exe and bcp.rll.