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
Originally Published: 2001-07-25
Article Number
Applies To
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
Migrating RSA ACE/Server database
Resolution
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
Related Articles
RSA DLP How to migrate RSA_DLP_EM database host server Number of Views Error 25000.Upgrade error: unable to migrate sdserv database(3) Number of Views How to migrate the database as a separate step when upgrading RSA Identity Governance & Lifecycle Number of Views 'java.io.FileNotFoundException: aveksa-version.properties' error running migrate.sh in RSA Identity Governance & Lifecycle Number of Views 'ORA-28000: the account is locked' error when migrating an imported database in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
