DBReplicator support for Sybase is implemented but in need of further testing.
Database Implementation Notes
SQLServer
DBReplicator support for SQLServer is implemented, but needs further testing.
Microsoft JDBC Connection
Database Driver
com.microsoft.jdbc.sqlserver.SQLServerDriver
JDBC Connect String
jdbc:microsoft:sqlserver://<server name>:1433;DatabaseName=<database name>
JNetDirect JDBC Connection
Database Driver
com.jnetdirect.jsql.JSQLDriver
JDBC Connect String
jdbc:JSQLConnect://<server name>:1433/database=<database name>/lastUpdateCount=true
PostgreSQL
DBReplicator support for PostgreSQL has been reasonably well tested, having been used in production environments with medium(500,000 - 6,000,000 records) sized databases, with sync sessions of up to approximately 3,000,000 records.
Tested with Postgres versions 7.3 and 8.2. It should work for anything in between.
Database Driver
org.postgresql.Driver
JDBC Connect String
jdbc:postgresql://<Hostname>:<Port>/<dbname>
PointBase
DBReplicator support for PointBase is implemented but not tested.
Oracle
DBReplicator support for Oracle is implemented but not tested
Database Driver
oracle.jdbc.driver.OracleDriver
JDBC Connect String
jdbc:oracle:thin:@<Server Name>:<Port>:<database name>
MySQL
DBReplicator support for MySQL is implemented and somewhat tested, but could use much more.
MySQL JDBC Connection
Database Driver
com.mysql.jdbc.Driver
JDBC Connect String
jdbc:mysql://localhost/<database name>
FireBird
DBReplicator support for FireBird is implemented but still needs testing.
DB2
DBReplicator support for DB2 is implemented but needs testing
Database Driver
com.ibm.db2.jcc.DB2Driver
JDBC Connect String
jdbc:db2j:net://<server name>:1527/<database name>;retrieveMessagesFromServerOnGetMessage=true;deferPrepares=true;create=true
jdbc:db2://<server name>::50000/<database name>
DaffodilDB / One$DB
DBReplicator support for DaffodilDB / One$DB is implemented, but needs testing.
Database Driver
in.co.daffodil.db.jdbc.DaffodilDBDriver
JDBC URL
jdbc:daffodilDB_embedded:school;create=true
CloudScape / Derby / JavaDB
Background
Cloudscape Inc was founded in 1996 to develop a Java database. In 1999 it was acquired by Informix, which was taken over by IBM in 2001. IBM developed Cloudscape as an embedded Java database, before handing it over to the Apache Software Foundation in 2004, which renamed it "Derby." Sun began supplying Java DB as a supported version of Derby in 2006.
From the Derby homepage: db.apache.org/derby

