08-12-2013 01:23 PM - edited 07-04-2021 12:38 AM
I have 3 WCS servers, 1 WCS is monitoring 24 WLC's another WLC is monitoring another 26 WLC's and the 3rd WCS is being used for HAL. I know I need to upgrade to NCS first but after that upgrade how can I merge the 2 databases into Prime?
08-12-2013 03:34 PM
http://www.cisco.com/en/US/docs/wireless/ncs/1.1/release/notes/NCS_RN1.1.1.html#wp83675
When you migrate multiple WCS servers to the NCS, follow these steps:
Step 1 Stop the WCS server.
Step 2 Export data from the WCS server which is running the most critical data. To do this, follow the steps in the "Exporting WCS Data" section.
Step 3 Export the user data from remaining WCS servers using the following command (for Windows):
export.bat userdata zipfile
Note You need to transfer the exported userdata .zip file from the WCS server to the NCS server.
Note For the remaining WCS servers, except the managed devices and maps, no other userdata (such as config templates, reports, users, virtual-domains, and so on) will not be imported. Also, all network-related data (such as events, alarms, statistics, clients, switches, and so on) will not be imported.
Example output
C:\Program Files\WCS7.0.230.0\bin>export.bat userdata c:\jmr3_exportdata
Starting database server ...
Database server is running.
Starting data export.
Initializing PersistenceService. This may take a minute.
PersistenceService initialized. Performing export user data.
Reading file: conf\userDataExportRules\ConfigTemplateExportRules.xml (1/6)
Exporting user data related db tables under group: SECURITY_TEMPLATE_GROUP
Exporting user data related db tables under group: EAP_TEMPLATE_GROUP
Exporting user data related db tables under group: HREAP_TEMPLATE_GROUP
Exporting user data related db tables under group: CLIENT_TEMPLATE_GROUP
Exporting user data related db tables under group: ROGUE_TEMPLATE_GROUP
Exporting user data related db tables under group: CONTROLLER_TEMPLATE_GROUP
Exporting user data related db tables under group: SERVER_TEMPLATE_GROUP
Exporting user data related db tables under group: RADIO_TEMPLATE_GROUP
Exporting user data related db tables under group: MSE_TEMPLATE_GROUP
Exporting user data related db tables under group: LRAD_GENERAL_TEMPLATE_GROUP
Exporting user data related db tables under group: POLICY_TEMPLATE_GROUP
Exporting user data related db tables under group: SNMPANDSYSLOG_TEMPLATE_GROUP
Exporting user data related db tables under group: ACL_TEMPLATE_GROUP
Exporting user data related db tables under group: APGROUP_TEMPLATE_GROUP
Exporting user data related db tables under group: LRAD_TEMPLATE_GROUP
Exporting user data related db tables under group: WLAN_TEMPLATE_GROUP
Exporting user data related db tables under group: CONFIGGROUP_TEMPLATE_GROUP
Exporting user data related db tables under group: MSE_EVENT_GROUP
Exporting user data related db tables under group: SCHEDULER_GROUP
Reading file: conf\userDataExportRules\DeviceExportRules.xml (2/6)
Exporting user data related db tables under group: DEVICE_GROUP
Exporting user data related db tables under group: CREDENTIAL_GROUP
Exporting user data related db tables under group: SCHEDULER_GROUP
Exporting user data related db tables under group: PARTITION_ASSOCIATION_GROUP
Reading file: conf\userDataExportRules\MapExportRules.xml (3/6)
Exporting user data related db tables under group: MAP_GROUP
Reading file: conf\userDataExportRules\ReportExportRules.xml (4/6)
Exporting user data related db tables under group: REPORT_SETTINGS_GROUP
Exporting user data related db tables under group: SCHEDULER_GROUP
Reading file: conf\userDataExportRules\UserExportRules.xml (5/6)
Exporting user data related db tables under group: TEMPUSER_GROUP
Exporting user data related db tables under group: DASHBOARD_GROUP
Exporting user data related db tables under group: SEARCH_GROUP
Reading file: conf\userDataExportRules\VirtualDomainExportRules.xml (6/6)
Exporting user data related db tables under group: PARTITION_GROUP
Exporting map data.
Completed export of user data related db tables.
Exporting reports, map images, accuracy test files,
controller auto provisioning files.
Exporting Mobility Service Engine, Location Server backups.
Creating ChecksumFile.
Creating compressed export file.
Shutting down database server ...
Database server successfully shutdown.
Data export completed successfully.
Step 4 Do the following:
a. To import all the device data from the managed controllers into the NCS (as root user in ROOT-DOMAIN), choose Configure > Controllers > Add Controllers, choose Zip File from the Add Format Type drop-down list, enter the .zip filename, and then click Add.
b. To import all the device data from the managed autonomous APs into the NCS, choose Configure > Access Points > Add Autonomous Access Points, choose Zip File from the Add Format Type drop-down list, enter the .zip filename, and then click Add.
After you add devices, the NCS pulls all inventory/configuration data from the respective devices.
After you add devices, you can export map data from the WCS (choose Monitor > Maps > Export Map) and import it into the NCS (Monitor > Maps > Import Map).
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: