2022
The application is developed in Java to ensure that it can work in both Windows and Linux environments.
On running "startup.bat db_to_source apps<profilename>", a mirror schema with the following structure will be created for each table in source applications.
...
The schema will be created by running a command from the console. The application will evaluate the schema difference between Source apps and Database - Source apps DB instance and generate “ALTER TABLE” command to add the columns. It will not remove any columns for a given table to maintain historical data.
Note: All table names and columns will be trimmed to 30 characters in length.
...