MS SQL Server migration

    1. Stop the NetFlow Analyzer 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 database and restore it in new server).
    3. From the New MS SQL server, copy the files bcp.exe and bcp.rll to OpManager/bin/ folder. 
    4. Please ensure that the 'SQL browser' service is running in the new server. 
    5. Download the same version of MS SQL server Native client and install it in the NetFlow server. This is needed for NetFlow Analyzer to communicate with remote database server. After installing the Native client, please restart the NetFlow Analyzer server.
    6. Ensure that the database user for NetFlow has 'sys admin' permission. 
    7. Open a Command Prompt as administrator and navigate to /OpManager/bin/.
    8. Execute ChangeDBserver.bat 
    9. Check if all the information is correct for the new SQL server, test and save the configuration.
    10. Start the NetFlow analyzer service.