Skip to content

Java program to help migrate persisted data from Transformer 6.2 to Transformer 7.0

Notifications You must be signed in to change notification settings

caplin/persistence-upgrade

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Persistence upgrade tool

A tool that helps migrating data persisted with a Transformer 6.2 to a Transformer 7.0. It supports reading from either a file DB or a java DB (via jdbc) and generates insert statements for the different tables used in version 7.

Usage:

  • Clone the Repo
  • run gradle jar which produces an executable jar file
  • run the program by running java -jar build/libs/upgradeTool-0.1.jar [options]

Examples:

The following examples showcase how to run the tool for the different modes (file DB vs java DB)

FileDb

To run the upgrade tool on a persistence folder run

java -jar build/libs/upgradeTool-0.1.jar --filedb --folder <path_to_persistence_folder>

JavaDb

To run the upgrade tool with jdbc mode, a JDBC Driver needs to be supplied and made available on the classpath in addition to specifying the correct arguments. When command line arguments contain special characters they need to be quoted.

#Linux/OSX
java -cp <path_to_jdbc_driver>:build/libs/upgradeTool-0.1.jar com.caplin.upgradetool.UpgradeTool --driver <driverName> --url <jdbc url> --user <jdbc user> --password <jdbc password> --table <table to upgrade data from> --columns <pers_key column name> <pers_val column name>

#Windows
java -cp <path_to_jdbc_driver>;build/libs/upgradeTool-0.1.jar com.caplin.upgradetool.UpgradeTool --driver <driverName> --url <jdbc url> --user <jdbc user> --password <jdbc password> --table <table to upgrade data from> --columns <pers_key column name> <pers_val column name>

Notes

  • The command line option --converters can be used to override the default classes used in case other modules than the ones that have converters supplied for them need their data upgraded too. This option is a list of class names. The classes must mimplement the Converter interface
  • The command line option --generator can be used to override the default generator. The default generator prints INSERT statements for the upgraded data to stdout. It might be desirable to directly insert data into the new database tables, in which case a new generator can be supplied. The class must implement the ConverterVisitor interface
  • This tool is unsupported and provided as is
  • You're free to modify the code as you see fit

About

Java program to help migrate persisted data from Transformer 6.2 to Transformer 7.0

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages