@Override
  public <Z, D extends Database<Z>> void synchronize(
      SynchronizationContext<Z, D> context, TableProperties table) throws SQLException {
    final String tableName = table.getName().getDMLName();
    final Collection<String> columns = table.getColumns();

    final String commaDelimitedColumns = Strings.join(columns, Strings.PADDED_COMMA);

    final String selectSQL = String.format("SELECT %s FROM %s", commaDelimitedColumns, tableName);
    final String deleteSQL = context.getDialect().getTruncateTableSQL(table);
    final String insertSQL =
        String.format(
            "INSERT INTO %s (%s) VALUES (%s)",
            tableName,
            commaDelimitedColumns,
            Strings.join(
                Collections.nCopies(columns.size(), Strings.QUESTION), Strings.PADDED_COMMA));

    Connection sourceConnection = context.getConnection(context.getSourceDatabase());
    final Statement selectStatement = sourceConnection.createStatement();
    try {
      selectStatement.setFetchSize(this.fetchSize);

      Callable<ResultSet> callable =
          new Callable<ResultSet>() {
            @Override
            public ResultSet call() throws SQLException {
              logger.log(Level.DEBUG, selectSQL);
              return selectStatement.executeQuery(selectSQL);
            }
          };

      Future<ResultSet> future = context.getExecutor().submit(callable);

      Connection targetConnection = context.getConnection(context.getTargetDatabase());
      Statement deleteStatement = targetConnection.createStatement();

      try {
        logger.log(Level.DEBUG, deleteSQL);
        int deletedRows = deleteStatement.executeUpdate(deleteSQL);

        logger.log(Level.INFO, Messages.DELETE_COUNT.getMessage(), deletedRows, tableName);
      } finally {
        Resources.close(deleteStatement);
      }

      logger.log(Level.DEBUG, insertSQL);
      PreparedStatement insertStatement = targetConnection.prepareStatement(insertSQL);

      try {
        int statementCount = 0;

        ResultSet resultSet = future.get();

        while (resultSet.next()) {
          int index = 0;

          for (String column : table.getColumns()) {
            index += 1;

            int type = context.getDialect().getColumnType(table.getColumnProperties(column));

            Object object = context.getSynchronizationSupport().getObject(resultSet, index, type);

            if (resultSet.wasNull()) {
              insertStatement.setNull(index, type);
            } else {
              insertStatement.setObject(index, object, type);
            }
          }

          insertStatement.addBatch();
          statementCount += 1;

          if ((statementCount % this.maxBatchSize) == 0) {
            insertStatement.executeBatch();
            insertStatement.clearBatch();
          }

          insertStatement.clearParameters();
        }

        if ((statementCount % this.maxBatchSize) > 0) {
          insertStatement.executeBatch();
        }

        logger.log(Level.INFO, Messages.INSERT_COUNT.getMessage(), statementCount, table);
      } catch (ExecutionException e) {
        throw ExceptionType.getExceptionFactory(SQLException.class).createException(e.getCause());
      } catch (InterruptedException e) {
        Thread.currentThread().interrupt();
        throw new SQLException(e);
      } finally {
        Resources.close(insertStatement);
      }
    } finally {
      Resources.close(selectStatement);
    }
  }
 @Override
 public <Z, D extends Database<Z>> void restoreConstraints(SynchronizationContext<Z, D> context)
     throws SQLException {
   context.getSynchronizationSupport().restoreForeignKeys();
 }