The Apricot DB Functions

* (FN001) Reverse engineer the source database (for the limited list of the database types) into the Apricot project storage;

* (FN002) Generate the report in format of MS Excel with the detailed info of the database structure, currently stored in Apricot;

* (FN003) The graphical representation of the current Apricot structure (the editable ER- diagram);

* (FN004) The creation of the ER- diagram from scratch. Editing of the existing/saved the ER- diagrams;

* (FN005) The auto- alignment of the selected (or all) objects on the ER- diagram;

* (FN006) Create and save the logical views - the fragments of the ER- diagram which include only the selected entities;

* (FN007) Export of the current ER- diagram into the database specific DDL, SQL- script (can it be implemented as generic as it is possible?);

* (FN008) The on-the-fly comparison of the current Apricot project with the source database;

* (FN009) Storing of the multiple snapshots of the database in the Apricot database. Comparison of the selected snapshots. All the comparison- results have to be provided in the graphical form. (The textual comparison report - if needed?);

* (FN010) Generate the differences alignment script (database specific);

* (FN011) Generate the ER- diagram out of the DDL- script (parsing of the database specific scripts);

* (FN012) Support of the database views (the database type specific); Register the dependencies of the views and db- tables/columns;

* (FN014) Auto generate the script for the data- removal (DELETE FROM all tables, or the selected tables only);

* (FN015) Auto generate the script for the DB - drop (DROP all tables/views, or the selected tables/views only);

* (FN016) The reverse engineering of the reference data stored in the reference- tables. The reference- tables have to be selected before this operation;

* (FN017) Comparison of the reference data between the current Apricot DB info and the source- database;

* (FN018) Generate the reference data- insert- script.

* (FN019) Generate the JPA- layer artifacts for selected entities in ER- diagram (!);