on Jun 16, 2016Article Content
| Article Number | 000018904 |
| Applies To | RSA ACE/Server 5.1.x (no longer supported as of 7-14-2006) RSA ACE/Server 5.0.x (no longer supported as of 8-15-2004) RSA ACE/Server 4.1 (no longer supported as of 2-1-2004) UNIX (AIX, HP-UX, Solaris) Microsoft Windows Upgrade |
| Issue | How to migrate an RSA ACE/Server version 4.1, 5.0.x, or 5.1 database into RSA ACE/Server version 5.0.x or 5.1 Migrating RSA ACE/Server database |
| Resolution | Option 1: Use the sdload upgrade option when loading the database. You can use this when you do not want to save any data currently on your new server, however it does not provide as much control over the database migration. NOTE: Do not use this option if you will need to add a new administrator account before performing administrative tasks (e.g. the administrative account for the database does not exist on the new server). UNIX procedure: Create a database dump file on the old ACE/Server: 1. Open a terminal session on the server and run the following commands cd ace/prog aceserver stop sdconnect stop sddump -s 2. Copy the sdserv.dmp and license.rec from this server to a temporary directory on the new server (i.e. /tmp) 3. On the new server, change directory to ace/prog and run the following commands: sdnewdb enter "all" at the prompt sdload -s -u -f /tmp/sdserv.dmp -k /tmp/license.rec All of the "Clients" from a pre-5.0 database will be listed as "Agent Hosts" and will have an "Acting Master Server" configured to be the Primary Server. The server on which the dump file is loaded is designated as the Primary Server. NT/2000 procedure: Create a database dump file on the old ACE/Server: 1. Start->Settings->Control Panel 2. Double-click ACE/Server icon 3. Click "Stop" and click "OK" to the ACE/Server and ACE/Broker stopped dialog boxes 4. Start->Run 5. In the "Open" dialog box type "<drive>\Ace\Prog\sddump.exe" where <drive> is the drive letter where ACE/Server is installed 6. Select option to dump the Server Database 7. Copy the files sdserv.dmp and license.rec to a temporary directory on the new server (i.e. c:\temp) 8. On the new server, run Ace\Prog\sdnewdb.exe 9. Check the options to create Log database and Server database 10. Run Ace\Prog\sdload.exe 11. Check the options "Server Database" and "Server dump file has a different license record than the current database" 12. Supply the path to the sdserv.dmp file 13. Click OK to load the database Option 2: Use the sdload merge option when loading the database. This should be done if you want to retain data from this server, such as when the replica table has been configured as you would like. UNIX procedure: Create a database dump file on the ACE/Server containing the data being migrated: 1. Open a terminal session on the server and run the following commands cd ace/prog aceserver stop sdconnect stop sddump -s 2. Copy the sdserv.dmp and license.rec from this server to a temporary directory on the new server (i.e. /tmp) 3. On the new server, change directory to ace/prog and run the following commands: sdload -s -m -f /tmp/sdserv.dmp -k /tmp/license.rec All of the "Clients" from a pre-5.0 database will be listed as "Agent Hosts" NT/2000 procedure: Create a database dump file on the old ACE/Server: 1. Start->Settings->Control Panel 2. Double-click ACE/Server icon 3. Click "Stop" and click "OK" to the ACE/Server and ACE/Broker stopped dialog boxes 4. Start->Run 5. In the "Open" dialog box type "<drive>\Ace\Prog\sddump.exe" where <drive> is the drive letter where ACE/Server is installed 6. Select option to dump the Server Database 7. Copy the files sdserv.dmp and license.rec to a temporary directory on the new server (i.e. c:\temp) 8. Run Ace\Prog\sdload.exe 9. Check the options "Server Database", "Server dump file has a different license record than the current database", and "Merge records from server dump file with records in current database" 10. Supply the path to the sdserv.dmp file 11. Click OK to load the database |
| Legacy Article ID | a4176 |