Database-Synchronization

This is a Java-based tool to compare and synchronize tables between a benchmark database and a target Oracle/PostgreSQL database

Requirements

• Maven
• Oracle Instant Client or PostgreSQL

Steps to run

1. Install Maven for Mac/Linux or Windows
2. Clone the repository:

   git clone https://github.com/Joshua-Sun-CompSci/Database-Synchronization.git

3. Navigate to the program directory depends on your database management system:

   cd Database-Synchronization/Database-Synchronization-Oracle

   or

   cd Database-Synchronization/Database-Synchronization-PostgreSQL

4. Navigate to the resources folder and add the tables you want to synchronize to table.txt located at:

   src/main/resources/table.txt

5. Compile the program:

   mvn clean package

6. Run the program using your IDE. Add "en" to the end of the running command if you wish to run in English.
7. Enter the information needed to connect to the benchmark/target databse. Format:

   url = "jdbc:oracle:thin:@//YourHost:YourPort/YourServiceName"(Oracle) or "jdbc:postgresql://hostname:port/dbname"(PostgreSQL)
   username = "YourUsername"
   password = "YourPassword"