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/>.


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


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

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

=============================
Running With JRE 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.
(1.3) Set an environment variable named JRE_HOME to the pathname of
      the directory into which you installed the JRE, e.g. c:\jre5.0
      or /usr/local/java/jre5.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:\j2sdk5.0
      or /usr/local/java/j2sdk5.0.


(2) Download and Install the CompareZilla Binary Distribution


(2.1) Download a binary distribution of CompareZilla from:

      http://sourceforge.net/projects/comparezilla

(2.2) Unpack the binary distribution to 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.

(2.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.


(2.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


(3) Start Up CompareZilla

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

      $COMPAREZILLA\bin\startup.bat          (Windows)

      $COMPAREZILLA/bin/startup.sh           (Unix)

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

      http://localhost:2020/




(4) Shut Down CompareZilla

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

      $COMPAREZILLA\bin\shutdown            (Windows)

      $COMPAREZILLA/bin/shutdown.sh         (Unix)


(5) Comparing Data

(5.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

(5.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.

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

(5.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.

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