MetadataConverter is a Java command-line tool that extracts metadata from DB2/AS400 databases (at the moment) and generates Oracle DDL and CSV files containing metadata and index information for the specified tables.
- Start process metadata to DDL/.csv file.
- Test connection to server.
- Insert created DDL file to database schema.(ORACLE right now)
- Compare schema(Oracle) to schema(Oracle) and show diffs in file.(For Testing)
For linux :
java -jar MetaDataConverter.jar
The tool generates two output files:
- output_file.csv: A CSV file containing the extracted metadata information for each table and its columns, including data types, lengths, scales, not-null constraints, and auto-increment attributes.
- output_file_ddl.sql: An SQL file containing the generated Oracle DDL statements for creating tables and indexes.
Whole project connections can be configured when project is started. (Except part with "Compare schema(Oracle) to schema(Oracle) and show diffs in file." This one is in code right now.)
To build the project, use your favorite Java build tool, such as Maven or Gradle.
- Oracle Done
- MySQL Done
- SQL Done
- DB2 Done
- AS400 Done
From\To | Oracle | MySQL | SQL | DB2 | AS400 |
---|---|---|---|---|---|
- Oracle | X | Done | Done | ||
- MySQL | Done | X | |||
- SQL | Done | X | |||
- DB2 | Done | X | |||
- AS400 | Done | X |
- Compare any type database schema to any type database schema.
- Extracted table as an object. Done
- Exract metadata information more than table columns and indexes.
- Created CSV file to choosen DDL.
- Created DDL file to choosen other DDL.
- Insertion of DDL to database.(With deletion if needed)