Shift2Ingres
Migrate to Ingres now!




This project is hosted on

SourceForge.net Logo

No code change required to run your existing application!

Pre-requisites | Application Migration


Pre-requisites:

  • Running Ingres R3 Database Server
    Click here to download the latest copy of Ingres R3 Database Server
    Click here to see steps for configuring the Ingres Database Server

  • Compiled Shift2Ingres source code.
    Click here to download the latest copy of the source code
    Click here to see steps for building Shift2Ingres source code

  • Migrate data from your existing Oracle/DB2 database to an Ingres database.
    Click here to see steps for migrating data

[ Back to top ]




Application migration manual

  • Step1: Make sure you meet the pre-requisites


  • Step2: Start the Core Layer Server

    • Let {S2I_SRC} be the directory in which you have unzipped/tarred and {S2I_SRC}/Shift2Ingres be the directory in which you built the Shift2Ingres source code.

    • Change directory to {S2I_SRC}/Shift2Ingres using 'cd {S2I_SRC}/Shift2Ingres' command.

    • Open ./resources/Shift2Ingres_CoreServer.properties in your favourite editor
      • Set 'CoreServer.DBType' to the type of Database you want to emulating (valid options are Oracle and DB2).
      • Set 'CoreServer.PortNumber' to the Port number at which you want to start the core layer server. Default port in 1234.
      • Set 'IngresJDBCServer.IPAddress' & 'IngresJDBCServer.PortNumber' to the Ingres R3 Database Server's IP address and port of which the iijdbc service is listening respectively. Default Ingres PortNumber is 21071.

    • Edit './startCoreLayer.bat' (for Windows) OR './startCoreLayer.sh' (for linux) and set JAVA_HOME variable.

    • Run './startCoreLayer.bat' (for Windows) OR 'sh ./startCoreLayer.sh' (for Linux) OR 'ant run_cl'



  • Step3: Configure your existing application

    • Change the JDBC driver jar file to {S2I_SRC}/Shift2Ingres/jars/Shift2Ingres_JDBCDriver.jar

    • Change the Database setting in the application.
      • Set Database IP address to Core Layer Server's IP Address.
      • Set Database Port to Core Layer Server's Port (default is 1234).



  • Step4: Start your application

    • Just start your application like you usually do.

[ Back to top ]


All the code and documents are solely owned by the Shift2Ingres team. Shift2Ingres migration toolkit is available for public use under the BSD Open Source License.