MSSQL database migration in v12
Kindly follow the below steps to migrate the SQL DB,
1. Take a backup of "customer-config.xml" file from the location "ManageEngine\OpManager\conf".
1. Take a backup of "customer-config.xml" file from the location "ManageEngine\OpManager\conf".
2. Take a SQL backup of OpManagerDB from the old server via SQL Management Studio.
3. Create a new DB named OpManagerDB with the same permissions on the new MSSQL databaseserver.
4. Restore the SQL Backup on the new server via SQL Management Studio.
5. Open command prompt as Administrator (right click CMD -> Run As Adminstrator) in the application installed server and go to the path "ManageEngine\OpManager\bin"
6. Execute the command "DBConfiguration.bat" and point the OpManager with the new DB details.
7. Once configured, Replace the existing "customer-config.xml" file from the location "ManageEngine\OpManager\conf" with the backup "customer_config.xml" file that we have taken.
8. Start the OpManager service and check if everything works fine.
New to ADSelfService Plus?
Related Articles
Migration of Database from MYSQL to MSSQL in the Firewall Analyzer
Please refer the below link for MYSQL to MSSQL migration. http://www.manageengine.co.in/products/firewall/help/appendix/migrating-data-mysql-mssql-database.html Note: I request to stop the Firewall Analyzer service and take the backup of complete ...MSSQL Server migration
1. Stop the NetFlow Analyzer service. 2. Backup the old Netflow DB and restore on to the new DB server (Connect MSSQL client using SQL Server Management Studio and backup netflow database and restore it new server). 3. From the New MSSQL SERVER, ...MSSQL Database shrink.
To reduce the MSSQL database size, please follow the below steps. 1. Stop the NetFlow Analyzer service. 2.Open a command prompt as administrator(Right click and run as administrator) Navigate to <NetFlow_Home\troubleshooting\>. 3. Execute the ...Netflow Analyzer migration (Links based on installation type)
Kindly refer the links below to migrate your Netflow Analyzer installation per your need - https://support.zoho.com/portal/manageengine/helpcenter/articles/mysql-32-bit-installation-to-64-bit-migration (For builds up to 9700) ...Mysql to Pgsql/Mssql -- Plugin
Mysql to Pgsql/Mssql Migration Plugin: Stop Opmanager service and take a backup of the entire Opmanager folder before doing the data migration. Install Opmanager 11500 pgsql with Netflow 10250 (for mssql, select mssql DB during installation). from ...