Page Comparison

Setup Project Directories

1. Create a directory where you will store working copies of files to be checked out from Subversion, such as <PATH>/subversion

Checkout Sample Embedded Client Project

1. Navigate to <PATH>/subversion

2. Code Block
   borderStyle solid
   [<PATH>/subversion]$ svn co https://mware.ucdavis.edu/svn/kuali/RiceApplications/sample-embedded-client/trunk/sample-embedded-client

Checkout the Kuali Impex Tool

[<PATH>/subversion]$ svn co https://test.kuali.org/svn/kul-cfg-dbs/trunk

Checkout the Sample Embedded Client Database Configuration Files

[<PATH>/subversion]$ svn co https://test.kuali.org/svn/rice-cfg-dbs/rice-client-db/branches/rice-release-1-0-0-br

Prepare Database Import Configuration

1. Copy <PATH>/subversion/kul-cfg-dbs/impex/impex-build.properties to <HOME>/impex-build.properties
2. Set the following property values in /wiki/spaces/UCDK/pages/119111688:

   Property	Sample Value
   svn.module	rice-cfg-dbs
   svn.base	branches/rice-release-1-0-0-br
   torque.schema.dir	<PATH>/subversion/rice-client-db
   drivers.directory	<path to your client database JDBC driver> Use forward slashes, even in Windows!!!
   import.torque.database.url	jdbc:oracle:thin:@<DB Host>.ucdavis.edu:1521:<DB SID>
   import.torque.database.user	<user you will log in as> SYS, schema, etc.
   import.torque.database.schema	<SCHEMA> Must be in UPPER CASE
   import.torque.database.password	<password>

Set Environment Variables

1. Navigate to <HOME>/subversion/kul-cfg-dbs/impex
2. Set JAVA_HOME

   Code Block
   borderStyle solid
   [<PATH>/subversion/kul-cfg-dbs/impex]$ export JAVA_HOME=<path to Java>

3. Set the classpath

   Code Block
   borderStyle solid
   [<PATH>/subversion/kul-cfg-dbs/impex]$ export classpath=<PATH>/subversion/kul-cfg-dbs/impex/lib

Execute the Database Import

• If you're starting with a blank database:

  Code Block
  borderStyle solid
  [<PATH>/subversion/kul-cfg-dbs/impex]$ ant import

• If you're adding to an existing database:

  1. Code Block
     borderStyle solid
     [<PATH>/subversion/kul-cfg-dbs/impex]$ ant create-ddl

  2. Code Block
     borderStyle solid
     [<PATH>/subversion/kul-cfg-dbs/impex]$ ant dataxml-to-sql

  3. Navigate to <PATH>/subversion/rice-client-db/sql and execute the generated SQL statements.
  4. Navigate to <PATH>/subversion/rice-client-db/datasql and execute the generated SQL statements.