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 Public 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 6.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 6.0 or later, from http://java.sun.com/j2se.

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

(1.3) 	Set an environment variable named JRE_HOME to the pathname of
      	the directory into which you installed the JRE, e.g. c:\jre6.0
      	or /usr/local/java/jre6.0.

      	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:\j2sdk6.0
      	or /usr/local/java/j2sdk6.0.


(2)   	Verify Java Installation

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

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


2.2.  	Verify Java Environment Variables

      	There is one Java environment variable you'll want to set for everything to function as it should,
      	and though some of them may have already been set by your Java installation, you'll want to double-check 
      	them all. You can also look at the Sun Java Installation Instructions page at the Java web site for 
      	further details.
      
     	First you'll need to set the JRE_HOME environment variable to point to the base directory of your Java 
      	installation. In UNIX operating systems you typically modify a startup file like ~/.bash_login to set 
      	and export these shell variables, while for Windows XP you would go to 
      	Start -> Control Panel -> System -> Advanced -> Environment Variables and then set them to point to 
      	the correct locations through the text fields of the GUI (samples below):
      
	Windows: Set the (or create a new) environment variable JRE_HOME to C:\jdk1.6.
	Linux/Unix/Mac: export JAVA_HOME=/usr/java/java-current

	Note: JRE_HOME is what Tomcat uses when it starts up, but it defaults to use JAVA_HOME if JRE_HOME is not set. 
	      For most people, then, setting JAVA_HOME should cover both cases sufficiently.
	
	Next you'll want to add Java to the PATH:
	Windows: Append the string ;C:\jdk1.6.0\bin to the end of the system variable named Path.
	Mac: Not necessary.
	Linux/Unix: export PATH=$PATH:$JAVA_HOME/bin/

	You should test that these variables are set correctly. 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.


(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\startup.bat (Windows)

	$COMPAREZILLA/Tomcat/bin/startup.sh (Unix)

(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\shutdown (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.
      	- 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