CompareZilla Files

======================================================================
    This file is part of CompareZilla.

    CompareZilla is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    CompareZilla is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Publisourcefoc License
    along with CompareZilla.  If not, see <http://www.gnu.org/licenses/>.


=====================================================================

=====================================================================
    		Installation and Configuration
=====================================================================

CompareZilla requires the Java 2 Standard Edition Runtime
Environment (JRE) version 5.0 or later.

(1)	Download and Install the J2SE Runtime Environment (JRE)

(1.1) 	Download the Java 2 Standard Edition Runtime Environment (JRE),
      	release version 5.0 or later, from http://java.sun.com/j2se.

(1.2) 	Install the JRE according to the instructions included with the
      	release.


      	NOTE: You may also use the full JDK rather than just the JRE. In this
      	case set your JAVA_HOME environment variable to the pathname of
      	the directory into which you installed the JDK, e.g. c:\j2sdk5.0
      	or /usr/local/java/j2sdk5.0.


(2)   	Verify Java Installation

      	Check to see if you have Java (version 1.5 or later) installed on your system by running 
      	the following command (sample output from a Linux system):

	$ java -version
	java version "1.5.0_09"
	Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_09-b05)
	Java HotSpot(TM) Server VM (build 1.5.0_09-b05, mixed mode)
 


2.2.  	Verify Java Environment Variables

	Check to see if Java is added to the PATH variable. In both Windows XP and Unix/Linux operating systems 
	you can simply start a new shell and type the set command to see your environment variables.
      
	To include Java in your PATH variable:
	Windows: Append the string ;C:\jdk1.5.0_06\bin to the end of the system variable named Path.
	Mac: Not necessary.
	Linux/Unix: export PATH=$PATH:$JAVA_HOME/bin/




(3) 	Download and Install the CompareZilla Binary Distribution


(3.1) 	Download a binary distribution of CompareZilla from:

	http://sourceforge.net/projects/comparezilla

(3.2) 	Unpack the binary distribution into a convenient location so that the
	distribution resides in its own directory (conventionally named
	"CompareZilla-[version]"). For the purposes of the remainder of this document,
	the symbolic name "$COMPAREZILLA" is used to refer to the full
	pathname of the release directory.

(3.3) 	Download JDBC Driver for your database.
	- Oracle - Go to http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html.
	- Download the JDBC Driver for you version of database.
	- Extract the package and copy the jar files to $COMPAREZILLA\Tomcat\webapps\ROOT\WEB-INF\lib
	- SQL Server - Driver already bundled.
	- MySQL - Driver already bundled.
	- Sybase - Driver already bundled.


(3.4) 	Create/Edit users.
	- The default user is "comparezilla" with the password "comparezilla"
	- You may add/edit new user by editing the file $COMPAREZILLA\Tomcat\conf\tomcat-users.xml

(4) 	Start Up CompareZilla

(4.1) 	Tomcat can be started by executing the following commands:

	$COMPAREZILLA\tomcat\bin\java -jar StartCompareZilla.jar (Windows)

	./$COMPAREZILLA/tomcat/bin/startup.sh (Unix)
	Note: Linux users need to change some file permissions. Issue the following commands:
	$ chmod +x $COMPAREZILLA/tomcat/bin/catalina.sh
	$ chmod +x $COMPAREZILLA/tomcat/bin/startup.sh
	$ chmod +x $COMPAREZILLA/tomcat/bin/setclasspath.sh
	$ chmod +x $COMPAREZILLA/tomcat/bin/shutdown.sh


(4.2) 	After startup, open a browser and go to:

	http://localhost:2020/


(5) 	Shut Down CompareZilla

(5.1) Tomcat can be shut down by executing the following command:

	$COMPAREZILLA\tomcat\bin\java -jar ShutdownCompareZilla.jar (Windows)

	./$COMPAREZILLA/tomcat/bin/shutdown.sh (Unix)




===================================================
            Running CompareZilla
===================================================


(6) 	Comparing Data

(6.1) 	Create Data Source
      	- Before comparing, a data source must be defined. Click the link "Create Data Source" to start 
	  defining your database connections.sourcefo
      	- Supply a Data Source Name for your connection. This can be any name.
      	- Select the data source type.
      	- Supply the connection URL. See below connection string format for your database:
		Oracle 	   - format: jdbc:oracle:thin:@[host]:[port]:[SID]
			     e.g.  : jdbc:oracle:thin:@localhost:1521:HR

		MySQL      - format: jdbc:mysql://[host]:[port]/[database]
			     e.g.:   jdbc:mysql://localhost:3306/test

		Sybase     - format: jdbc:jtds:sybase://[host]:[port]/[database]
			     e.g.:   jdbc:jtds:sybase://localhost:4100/pubs	

		SQL Server - format: jdbc:jtds:sqlserver://[host]:[port]/[database]
			     e.g.:   jdbc:jtds:sqlserver://localhost:1433/pubs

      - Supply the the username and password for the connection.
      - Click the Save button

(6.2) Create a Task

      - After creating the data source, click "Create Task" link to start defining the source tables.
      - Give a name for the task.
      - Select the Data Sources you want to use.
      - Select the schemas.
      - Select the table or view.
      - Check the columns to include in the comparison.
      - Optionally add a filter for each field.
      - Save the task.

(6.3) Run the Task
      - To run a task, click the "Task List" link.
      - Select the task you want to run.
      - Click Run Task button

(6.4) Download and View Result
      - After running the task, click the "List Results" link.
      - Select the result and click download.
      - Save the file in your computer then open with notepad or wordpad.

(6.5) Report Bugs and Feature Request.
      - Please report any bugs and feature request to sulatnijag@yahoo.com