Properties/Scripts on Migrating from Embedded to Split files

[felix]

On migrating a database from "Embedded" to "Split File" mode I notice (in respect of steps E and F of the post "Migrating an "embedded database" from the all-inclusive database file(.odb) to a robust "spli-file" database folder") that a .properties and a .script file were created in step A when creating the new 'split file' database.

The database directory of the unzipped original .odb file also contains properties and script files. On extracting these to the new split file database, I retained these copies (ie the original .odb copies) and discarded those created in step A. As I am not 100% sure of what the implications of the different specifications in these files are, can anybody please confirm or otherwise that I have retained the correct files.

[DACM]

You can discard the files created in step A as part of an empty database. The extracted files are what you want.

After extracting the database folder-files from an "embedded database," it's best to make a few changes to the .script and .properties files using a text editor:

Adjust the write delay from 60 to 1 second in the .script file:

• original setting upon extraction from .odb file:
  • SET WRITE_DELAY 60
  change to:
  • SET WRITE_DELAY 1

And adjust the cache settings in the .properties file as follows:

• original setting upon extraction from .odb file:
  • #HSQL Database Engine 1.8.0.10
    #Tue Jun 05 05:20:34 PDT 2012
    hsqldb.script_format=0
    runtime.gc_interval=0
    sql.enforce_strict_size=true
    hsqldb.cache_size_scale=8
    readonly=false
    hsqldb.nio_data_file=false
    hsqldb.cache_scale=13
    version=1.8.0
    hsqldb.default_table_type=cached
    hsqldb.cache_file_scale=1
    hsqldb.lock_file=true *** eliminated below ***
    hsqldb.log_size=10
    modified=no
    hsqldb.cache_version=1.7.0
    hsqldb.original_version=1.8.0
    hsqldb.compatible_version=1.8.0
  change to:
  • #HSQL Database Engine 1.8.0.10
    #Tue Jun 05 05:20:34 PDT 2012
    hsqldb.script_format=0
    runtime.gc_interval=0
    sql.enforce_strict_size=true
    hsqldb.cache_size_scale=10
    readonly=false
    hsqldb.nio_data_file=true
    hsqldb.cache_scale=14
    version=1.8.0
    hsqldb.default_table_type=cached
    hsqldb.cache_file_scale=1
    hsqldb.log_size=10
    modified=no
    hsqldb.cache_version=1.7.0
    hsqldb.original_version=1.8.0
    hsqldb.compatible_version=1.8.0