Hi, We have 2 ACS servers each handling different sets of several hundred devices. I need to merge the 2 databases (users, groups and devices) into a third ACS 4.2 server.
My thoughts are to do a backup of one and do a restore on the new server. Now, I need to find a way to import the users, groups and devices from the second ACS server into the new consolidated ACS. I've been searching, and I have not found a way to import the users, groups and devices without removing the devices that were added from the first ACS sever. Does anyone have any recommendations?
Try this. On each ACS server run CSSupport (or the support page in ACS Admin) to generate a package cab.
If you open the cab there will be two CSV files - one for NDGs and one for devices.
Using excel you can merge these two CSVs. To get the data back into ACS you'll need to create an account actions CSV file and process it with RDBMS Sync.
Action code 250 adds an NDG
Action code 220 adds a device
Action code 252 assigns device to NDG
It might sound like a chore, but its largely a cut and paste exercise.
If you routinely use RDBMS sync to add your devices it means you'll always have an up-to-date actions file that you can throw at another server should you need to.
The simpler way is to download the SQL Anywhere developer tools and ask Cisco about loading up the ndg and device tables directly from CSV files. It can be done but I doubt they'll give you the database sa password.