ABSDDLUtils

This application can be used for comparing the actual database schema against the expected database schema. Handy during updates and installations to make sure that all needed database changes are available.

It is based on the Apache open source project DDLUtils

How it works:

This tool can do the following:

1. Generate a zipped xml file containing the data model of an actual data base

	How it works:

	When you copy the complete DDLUtils folder to [ABS_HOME]\server\tools, no configuration is needed. 
	All needed jars and configs and expected model xmls are integrated in the installed server software
	
	Configuration of the various parameters is done via the \config\ddlutils.properties. 
	The most important entry is the link to the used absserver.properties file. The actual data 
	base connection is defined by the regular values in the absserver.properties
	
	Once this is set up, you can create an xml model of the actual database by running the 	bin/createXMLModelfromCurrentModel.bat
	The xml file will be stored in the /xml folder, with the name expectedmodel-v8.02.01.xml.zip


2. Compare a data base model against a zipped xml file containing the expected model

	How it works:
	
	When you copy the complete DDLUtils folder to [ABS_HOME]\server\tools, no configuration is needed. 
	All needed jars and configs and expected model xmls are integrated in the installed server software
	DLLUtils will use the actual data base as defined via the absserver.properties file
	
	Once this is set up, you can run the bin/compareCurrentDatabaseModelToExpectedXMLModel.bat
	This will first create a new file xml/actualmodel-vX.XX.XX.xml and then it will compare this
	file against the related zipped expectedmodel-vX.XX.XX.xml.zip, which must exist. 
	
	If you do not want to use the related absserver.properties, you have the option to set the needed properties as parameters.
	Please check the related bat / sh files for examples
	
	The log files are written in the /log folder. Here is a description of the various log files
	
		-	CompareSchemaToXML Summary.log					This is the most important log file, containing a summary of the comparison. It lists the various entries ordered from fatal to info.
															The fatal errors contain errors related to missing elements ( tables, columns etc. ). 
		-	CompareSchemaToXML.log							This is the complete log file showing all entries
		-	CompareSchemaToXML Details - xxxxx.log			All detail log entries related to the mentioned database elements
		-	CorrectionScript.sql							The correction script contains various simple correction to correct found errors. It can be run via the server admin tool