Migrating SME Database Tables



Note Data migration is currently supported only for SME Tapes. It is not yet supported for SME Disks.


This appendix describes a database migration utility and also outlines the steps you need to follow to migrate 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 DCNM for SAN CD starting from NX-OS Software Release 4.1(3) and is available at /software/SMEdbmigrate.zip.


Note The DCNM-SAN application should be installed before the migration process by using the destination database so that DCNM-SAN 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:

SMEdbmigrate.jar

ojdbc14.jar

postgresql-8.1.jar

smedbmigrate.bat

smedbmigrate.sh

smedbmigration.properties

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 
jdbc:postgresql://172.28.233.186:5432/dcmdb **********
 
Please enter the passsword for user admin on destination database 
jdbc:postgresql://172.28.255.110:5432/dcmdb **********
*[INFO] Migrating database from jdbc:postgresql://172.28.233.186:5432/dcmdb to 
jdbc:postgresql://172.28.255.110:5432/dcmdb
[INFO] Migration Start for SME_SETTINGS
...
...
...
[INFO] Migration complete
[root@test-vm-236 SMEdbmigrate]#
 
   

Note Run a key retrieval operation to confirm that the migration has been successful.