MacQueen

• Sqlite examples
• Upgrade to Oracle 10 is missing some stuff
• Oracle is difficult to set up
• SQlite is probably good/fast enough and it is free
• Export Oracle to csv files: http://dba-oracle.com/t_export_schema_to_csv_file_all_tables.htm

-- This will create a csv spreadsheet file for all tables in this schema:

connect scott/tiger

set serveroutput on;

set lines 80
set head off
set colsep ','
set pages 0
set feed off

spool runme.sql

select 'set colsep '',''' from dual;
select 'set lines 9999' from dual;
select 'set head off' from dual;
select 'set pages 0' from dual;
select 'set feed off' from dual;

begin
for table_rec in (select table_name from user_tables) loop

   dbms_output.put_line('spool '||table_rec.table_name||'.csv');
   dbms_output.put_line('select * from '||table_rec.table_name||';');

end loop;
end;
/

select ' spool off' from dual;
spool off

@runme.sql

• $111 http://www.sqlmaestro.com/products/sqlite/converter/
• $149 https://dbconvert.com/oracle/sqlite/

 OracleDB oracleDB = new OracleDB();
    SQLiteDB sqliteDB = new SQLiteDB();


    oracleConnection = oracleDB.connect();
    sqliteConnection = sqliteDB.connect();
    {
        Statement s = null;
        PreparedStatement ps = null;
        try {
            s = sqliteConnection.createStatement();
            s.executeUpdate("CREATE TABLE IF NOT EXISTS test_table (field1, field2)");

            ps = oracleConnection.prepareStatement("SELECT * FROM temp_desarrollo");
            ResultSet rs = ps.executeQuery();

            while (rs.next()) {
                ps = sqliteConnection.prepareStatement("INSERT INTO test_table VALUES (?, ?)");
                //SET PARAMETERS
                ps.setString(1, rs.getString(1));
                ps.setString(2, rs.getString(2));
                ps.executeUpdate();
            }

        } catch (SQLException ex) {
            Logger.getLogger(OracleToSQLite.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    oracleDB.disconnect(oracleConnection);
    sqliteDB.disconnect(sqliteConnection);