MS SQL Server Migration

Please follow the below steps for MSSQL server migration.

1. Stop the ManageEngine OpManager service.
2. Backup the old NetFlow Database and restore on to the new Database server (Connect MS SQL client using SQL Server Management Studio and backup NetFlow\OpManagerDB database and restore it in new server).
3. Please ensure that the 'SQL browser' service is running in the new server.
4. Download the below MS SQL server ODBC driver and BCP command line utilities and install it in the NetFlow server. This is needed for NetFlow Analyzer to communicate with remote database server.

ODBC:

https://go.microsoft.com/fwlink/?linkid=2200731

Command line utilities:

https://go.microsoft.com/fwlink/?linkid=2142258
5. Copy bcp.exe and bcp.rll files from Microsoft SQL server folder in the NetFlow server to /bin folder.
6. Ensure that the database user for NetFlow has "dbcreator", "public" and "sysadmin" permission.
7. Open a Command Prompt as administrator and navigate to ManageEngine/OpManager/bin/.
8. Execute DBConfiguration.bat and provide the new server details.
9. Check if all the information is correct for the new SQL server, test and save the configuration.
10. Start the ManageEngine OpManager service.