HP Cisco MDS 9120 Cisco MDS 9000 Family Storage Media Encryption Configuration - Page 275

Migrating Cisco SME Database Tables, Step 1

Page 275 highlights

Send documentation comments to [email protected] G A P P E N D I X 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 Step 2 Step 3 Step 4 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 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. 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. Enter passwords for the source and destination database when prompted. OL-18091-01, Cisco MDS NX-OS Release 4.x Cisco MDS 9000 Family Storage Media Encryption Configuration Guide G-1

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280

Send documentation comments to [email protected]
G-1
Cisco MDS 9000 Family Storage Media Encryption Configuration Guide
OL-18091-01, Cisco MDS NX-OS Release 4.x
APPENDIX
G
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:
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.