Migrating Cisco SME Database Tables
This appendix describes a database migration utility and also outlines the steps you need to follow to migrate Cisco SME tables from one database to another database.
The database migration utility transfers contents of database tables in Oracle Express installation or in PostgreSQL to an Oracle Enterprise installation.
This utility is packaged in the Cisco Fabric Manager CD starting from NX-OS Software Release 4.1(3) and is available at /software/SMEdbmigrate.zip.
Note The Fabric Manager should be installed, before the migration process, using the destination database so that Fabric Manager tables gets created in the destination database.
To migrate database files from the source database to the destination database, follow these steps:
Step 1 Extract the contents of the SMEdbmigrate.zip file to your directory folder. The contents of the file will be as follows:
Step 2 Right-click the smedbmigration.properties file to open in a text editor. Modify the existing database URL, type, and user name and the destination database URL, type, and user name.
Step 3 To migrate the data files, run the following shell script or batch file:
•sh smedbmigrate.sh (for Unix)
•smedbmigrate.bat (for Windows)
The shell script or the batch file can be executed from any server that has to access to both the source database and the destination database.
Step 4 Enter passwords for the source and destination database when prompted.
The sample output would be as follows:
[root@test-vm-236 SMEdbmigrate]# ./smedbmigrate.sh
[INFO] File /root/download/SMEdbmigrate/smedbmigration.properties found
Please enter the passsword for user admin on source database
Please enter the passsword for user admin on destination database
*[INFO] Migrating database from jdbc:postgresql://172.28.233.186:5432/dcmdb to
[INFO] Migration Start for SME_SETTINGS
[INFO] Migration complete
Note Run a key retrieval operation to confirm that the migration has been successful.