Database Access Providers and Supported Databases for DBMoto 6 and above

Product:	DBMoto
Version:	Version 6 and above
Category:	Product Compatibility
Last Updated: Topic ID:	6/20/10 KBFAQ 1590
Summary:	Database access providers and supported databases for DBMoto 6 and above

The following table lists the databases supported in DBMoto versions 6 and 7 for Refresh, Mirroring and Synchronization, and describes the database access providers that have been tested with DBMoto.

DBMoto 6 and 7 have been designed specifically for a .NET environment, therefore use a .NET Data Provider for your database connections wherever possible.

If you need to perform replications using a database not listed here, contact technical support.

Database	Use	.NET	OLE DB	ODBC
Microsoft Access 97 and later	Mirroring Target Refresh: Source, Target			Microsoft Jet ODBC Driver
IBM DB2 UDB (DB2/NT,AIX, Linux, HP/UX, Solaris) v5 and later	Mirroring/Sync: Source, Target (Source DBMoto6 or later. DB2 v7.2 or above required) Refresh: Source, Target	HiT Ritmo/DB2 .NET Data Provider (distributed with DBMoto) Assembly: SqlDb2 (file name: SqlDb2.dll) Sample path: Ritmo DB2\lib\SqlDb2.dll or C:\Program Files\HiT Software\Ritmo DB2 Server 4.1.0\lib\RitmoDB2.dll
IBM Cloudscape v10.1 and later	Mirroring Target Refresh: Source, Target	IBM DB2.NET Data Provider Assembly: IBM.Data.DB2 (file name: IBM.Data.DB2.dll)
IBM DB2 for i (AS/400)	Mirroring/Sync: Source, Target (Source V4R3 or later required. Mirroring target V3R2 and later) Refresh: Source, Target (V3R2 and later)	HiT Ritmo/i .NET Data Provider (distributed with DBMoto) Assembly: Sql400 (file name: Sql400.dll) Sample path: Ritmo i5\lib\Sql400.dll or C:\Program Files\HiT Software\Ritmo i Server 4.0.0 \lib\Sql400.dll
IBM DB2 for z/OS (OS/390) v5 and later	Mirroring/Sync: Source, Target (Source DBMoto6 or later. DB2 v6 or above required) Refresh: Source, Target	HiT Ritmo/DB2 .NET Data Provider (distributed with DBMoto) Assembly: SqlDb2 (file name: SqlDb2.dll) Sample path: Ritmo DB2\lib\SqlDb2.dll
IBM DB2 Express v8.2 and later	Mirroring: Target Refresh: Source, Target	HiT Ritmo/DB2 .NET Data Provider (distributed with DBMoto) Assembly: SqlDb2 (file name: SqlDb2.dll) Sample path: Ritmo DB2\lib\SqlDb2.dll
Firebird v2.0 and later	Mirroring: Target Refresh: Source, Target	Firebird Server for Windows .NET Data Provider Download from Firebird Assembly: FirebirdSql.Data.FirebirdClient (file name: FirebirdSql.Data.FirebirdClient.dll) Sample path: C:\FirebirdClientV2.0\FirebirdSql.Data.FirebirdClient.dll
Gupta SQL Base v8.5.0 and later	Mirroring/Sync: Source, Target (DBMoto6 or later) Refresh: Source, Target	Gupta SQLBase .NET Data Provider Download from Unify Assembly: Gupta.SQLBase.Data (file name: Gupta.SQLBase.Data.dll) Sample path: Gupta: C:\Program Files\Gupta\SQLBase901\Gupta.SQLBase.Data.dll
Informix v9.5 and later	Mirroring/Sync: Source, Target (DBMoto 6.1.1 or later) Refresh: Source, Target	Informix .NET Data Provider Download from Informix Assembly: IBM.Data.Informix (file name: IBM.Data.Informix .dll)
Ingres v9.5 and later	Mirroring: Target Refresh: Source, Target	Ingres .NET Data Provider Download from Ingres Assembly: Ingres.Client (file name: Ingres.Client.dll) CA .NET Data Provider Assembly: Ca.Ingres.Client (file name: Ca.Ingres.Client.dll)
MySQL v. 4.1.5 and later	Mirroring/Sync: Source, Target Refresh: Source, Target	MySQL .NET Data Provider Download from MySQL Note: Trigger-based transactional replications are supported for v. 4.1.5 and later; log- and trigger-based transactional replications are supported for v. 5.1.31 and later Assembly: MySql.Data (file name: MySql.Data.dll) Sample path: C:\MySQL\Connector-net-5.0.3\Driver\bin\net-2.0\release\MySql.Data.dll
Netezza Fully supported in DBMoto V7 and above.	Mirroring: Target Refresh: Target			Netezza ODBC Driver
Oracle v8.1.7 and later	Mirroring/Sync: Source, Target Refresh: Source, Target	Note: Oracle .NET Provider is available for Oracle versions 9.2 and later. For earlier versions of Oracle, use the Oracle OLE DB provider. Oracle .NET Data Provider Download from Oracle Assembly: Oracle.DataAccess (file name: Oracle.DataAccess.dll) Sample path: C:\oracle10_2\client\odp.net\bin\2.x\Oracle.DataAccess.dll
Postgre SQL v8 and later	Mirroring Target Refresh Source, Target	PostgreSQL .NET Data Provider Download from PostgreSQL Assembly: Npgsql (file name: Npgsql.dll) Sample path: C:\Npgsql1.0\Npgsql\bin\ms2.0\Npgsql.dll
Solid	Mirroring: Target Refresh: Source, Target			Solid ODBC Driver
Microsoft SQL Server v7 and later	Mirroring/Sync: Source, Target Refresh: Source, Target	Microsoft SQL Server .NET Data Provider (included with .NET Framework 2.0) Assembly: System.Data (file name: System.Data.dll)
Sybase ASE v12.5 and later	Mirroring/Sync: Source, Target (DBMoto 6.1.1 or later) Refresh: Source, Target	Sybase ASE .NET Data Provider (included with Sybase ASE) Assembly: Sybase.Data.AseClient (file name: Sybase.Data.AseClient.dll) Sample path: C:\Sybase-ASE\ADONET_1.15.50.0\dll\Sybase.Data.AseClient.dll
Sybase Adaptive Server Anywhere	Mirroring/Sync: Source, Target (DBMoto 6.1.1 or later) Refresh: Source, Target	SQL Anywhere .NET Data Provider (included with Sybase Anywhere Studio) Assembly: iAnywhere.Data.SQLAnywhere (file name: iAnywhere.Data.SQLAnywhere.dll) Sample path: C:\Program Files\SQL Anywhere 10\Assembly\v2\iAnywhere.Data.SQLAnywhere.dll Sybase .NET Data Provider (included with Sybase Anywhere Studio) Assembly: iAnywhere.Data.AsaClient (file name: iAnywhere.Data.AsaClient.dll)