Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Merge 2 WCS databases into Prime?

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?               

1 REPLY
Cisco Employee

Merge 2 WCS databases into Prime?

http://www.cisco.com/en/US/docs/wireless/ncs/1.1/release/notes/NCS_RN1.1.1.html#wp83675

Migrating WCS User Data to NCS 1.1 (for Multiple WCS Servers)

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

userdata

Exports only user-created data in the database, saved reports (if -noreports is not specified), map images, license files, mobility services engine backups, location server backups, accuracy test files, controller auto provisioning files.

Note Export userdata is supported only by WCS Release 7.0.172.0 and later.

zip file

Full pathname of the compressed .zip file to create.



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).


319
Views
0
Helpful
1
Replies
CreatePlease login to create content