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
3 years ago
Originally Published: 2001-07-25
Article Number
000055186
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

Related Articles

Trending Articles

Don't see what you're looking for?