dbTalk Databases Forums  

alternative to DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss alternative to DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
donalmurtagh@yahoo.co.uk
 
Posts: n/a

Default alternative to DTS - 08-16-2006 , 11:37 AM






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


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: alternative to DTS - 08-16-2006 , 04:21 PM






If you have the drivers then you could write something yourself in a
language such as C#

What about deriving something through Access (although not technically free
of charge)

Does Oracle not have any ETL Modules you can use or does everyone use
Informatica?

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



<donalmurtagh (AT) yahoo (DOT) co.uk> wrote

Quote:
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




Reply With Quote
  #3  
Old   
database.replication@gmail.com
 
Posts: n/a

Default Re: alternative to DTS - 08-18-2006 , 01:23 PM



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 (AT) yahoo (DOT) co.uk wrote:
Quote:
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.