Re: Database connectivity
Seena Blace [EMAIL PROTECTED] wrote: I wanted to setup connectivity between mysql database and oracle database.I have one database in mysql from which all tables data I want to insert real time data into oracle database.How to connect mysql database with oracle database? From what I understood you want something like replication, no? You may try to use mysql binary logs for that task. Learn http://dev.mysql.com/doc/mysql/en/Log_Files.html for details. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database connectivity
Hi, I wanted to setup connectivity between mysql database and oracle database.I have one database in mysql from which all tables data I want to insert real time data into oracle database.How to connect mysql database with oracle database? thanks - Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages!
RE: Database connectivity
What will the connection be used for? Replication? Query between datasources? There are some third party applications such as Golden Gate that have replication products. You could also write the connection yourself in a language such as Java or C. -Original Message- From: Seena Blace To: Seena Blace; [EMAIL PROTECTED] Sent: 9/1/04 11:30 AM Subject: Re: Database connectivity Hi, I wanted to setup connectivity between mysql database and oracle database.I have one database in mysql from which all tables data I want to insert real time data into oracle database.How to connect mysql database with oracle database? thanks - Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database connectivity
AFAIK, MySQL servers can only talk to other MySQL servers and that is only through the replication protocol/connections. Beyond that you will need to make your server-to-server connections through some kind of external client. Can Oracle act as a client to foreign databases? If it cannot, I believe you will need to write some code to develop a custom solution. It may be possible to use the MySQL source code to enable your custom client to behave as a MySQL replication slave then transform the binlog entries you receive into valid Oracle statements. Other than that, I think that you would need to periodically poll the MySQL server for changes and duplicate them into your Oracle server. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace [EMAIL PROTECTED] wrote on 09/01/2004 12:30:12 PM: Hi, I wanted to setup connectivity between mysql database and oracle database.I have one database in mysql from which all tables data I want to insert real time data into oracle database.How to connect mysql database with oracle database? thanks - Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages!