Re: alternative to DTS



Do you need online replication or periodic data transfers?

wisdomforce fastreader works pretty fast for oracle data transfer both
into MySQL or SQL Server. It does not even requires target to be online
and creates loader script. Alternatively FastReader can write data
into pipe in ASCII format that can be readed to load into target.

fastreader is not free though: www.wisdomforce.com


donalmurtagh@xxxxxxxxxxx wrote:
Hi,

I used to use DTS for transferring data between Informix and SQL Server
and it worked very nicely. I now need to replicate data between Oracle
and MySQL and need a similar tool. I can't use DTS because I no longer
have SQL Server, and I can't use Oracle or MySQL's replication service,
because they only work between 2 Oracle or 2 MySQL databases.

I don't need anything particularly sophisticated, just something which
can copy data between an Oracle and MySQL database, and ideally is
available free-of-charge.

Thanks in advance,
Don

.



Relevant Pages

  • RE: Windows Services and SQL Server
    ... There are managed providers for Oracle, MySQL and other RDBMS's. ... SqlClient class with a regular SQL Server login? ... I'm using ODBC Drivers ...
    (microsoft.public.dotnet.languages.csharp)
  • Parameterized queries to different data providers
    ... I would like to build my app so it can connect to SQL Server, Oracle ... or mySQL and query data. ... Data queries should be parameterized to reduce impact of SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle - MySQL decision
    ... I'm suprised you've not considered Microsoft SQL Server 2005 Express edition ... I'd choose Oracle since I have used it since version 7 and I ... > MySQL 5.0 on the other hand is a close contender. ... Many potential customers have flexible site ...
    (comp.databases)
  • Re: Iseries/AS400 access to external databases
    ... You can read/write data from any RPG program to SQL Server, Oracle, MySQL or ... external clients via ODBC, service programs, etc. ... guess Oracle and MySQL might be other sources but not in our case). ...
    (comp.sys.ibm.as400.misc)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)