com.bankframe.admin.tools
Class MigrateMetaData

java.lang.Object
  com.bankframe.admin.tools.MigrateMetaData

public class MigrateMetaData
extends Object

This class migrates the Meta-data txn_field table prior to MCA 4.0 to the MCA 4.0 style meta-data tables

Usage:
java com.bankframe.admin.tools.MigrateMetaData -url [jdbcUrl] -driver [jdbcDriver] -u [username] -p [password] -t [tablespace] -script [script file name] [-OnlyScript] [-DB2ScriptFormat]
Options:

1. -url The JDBC URL of the database
2. -driver The JDBC Driver to use to access the database. Note the driver must be in the classpath
3. -u The username to connect to the database as
4. -p The password to connect to the database as
5. -t The tablespace to use. This defaults to the username
6. -script Once the meta-data has been converted the contents of the meta-data tables are extracted to an SQL script file. If this is null no script is created
7. -OnlyScript This option specifies that only the script is to be updated from the new tables that have been previously updated, the database tables are not changed

Constructor Summary

MigrateMetaData()
Constructor

Method Summary

static void	main(String[] args)
void	migrateMetaData(String url, String driver, String username, String password, String tablespace, String script, boolean onlyScript) This method initialises tool and starts processing

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MigrateMetaData

public MigrateMetaData()

Constructor

Method Detail

main

public static void main(String[] args)

Parameters:

args - String array

migrateMetaData

public void migrateMetaData(String url,
                            String driver,
                            String username,
                            String password,
                            String tablespace,
                            String script,
                            boolean onlyScript)
                     throws SQLException,
                            IOException

This method initialises tool and starts processing

Parameters:

url - is the JDBC URL of the database

driver - is the JDBC Driver to use to access the database. Note the driver must be in the classpath

username - is the username to connect to the database as

password - is the password to connect to the database as

tablespace - is the tablespace to use. This defaults to the username

script - is contents script file name. Once the meta-data has been converted the contents of the meta-data tables are extracted to an SQL script file. If this is null no script is created.

onlyScript - specifies that only the script is to be updated. This uses the new database tables created previously, the database tables are not affected.

Throws:

SQLException

IOException