Database Access Providers and Supported Databases for DBMoto 6

 

Product:

DBMoto5, DBMoto6

Version:

DBMoto 5.0 and higher

Category:

Product Compatibility

Last Updated:

Topic ID:

7/1/08

KBFAQ 1590

Summary:

Database access providers and supported databases for DBMoto 6

 

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

 

DBMoto 5 and 6 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

ANTs V3.4 and later
(DBMoto6 and later)

Mirroring/Sync:
Source, Target

 

Refresh:
Source, Target

ANTs .NET Data Provider

 

Assembly:
Ants.Data.AntsClient
(file name: Ants.Data.AntsClient.dll)

 

Sample path:
C:\antsdb\AntsClient.NET\Ants.Data.AntsClient.dll

 

 

    

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

 

HiT OLEDB/DB2
OLE DB Provider

HiT ODBC/DB2
ODBC Driver

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

 

HiT OLEDB/400
OLE DB Provider

HiT ODBC/400
ODBC Driver

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

HiT OLEDB/DB2
OLE DB Provider

HiT ODBC/DB2
ODBC Driver

Firebird

v2.0 and later

Mirroring:
Target

 

Refresh:
Source, Target

Firebird Server for Windows .NET Data Provider

 

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

 

Assembly:
Gupta.SQLBase.Data
(file name: Gupta.SQLBase.Data.dll)

 

Sample path:
Gupta: C:\Program Files\Gupta\SQLBase901\Gupta.SQLBase.Data.dll

 

Gupta SQLBase ODBC Driver

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)

 

Informix ODBC Driver (IBM)

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
v3.23 and later

Mirroring/Sync:
Source, Target

 

Refresh:
Source, Target

MySQL .NET Data Provider

Download from MySQL

 

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

 

MySQL
ODBC Driver 3.51

Oracle
v8 and later

Mirroring/Sync:
Source, Target

 

Refresh:
Source, Target

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

Oracle
OLE DB Provider

Oracle ODBC Driver

Postgre SQL
v8 and later

Mirroring
Target

 

Refresh
Source, Target

PostgreSQL .NET Data Provider

 

Assembly:
Npgsql (file name: Npgsql.dll)

 

Sample path:
C:\Npgsql1.0\Npgsql\bin\ms2.0\Npgsql.dll

 

PostgreSQL
ODBC Driver

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)

Microsoft SQL Server OLE DB Provider

Microsoft SQL Server ODBC Driver

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 ASE
ODBC Driver

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)

 

Sybase Adaptive Server Anywhere ODBC Driver