Re: Mysql and Oracle
> I have a questions: > > I installed MySQL and Oracle 9i in the same XP box, is there any > interference with each other? They'll both compete for CPU and memory, but for testing or development, it's fine. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql and Oracle Forms 6i
Yip I kinda figured that and tend to code that way anyhow But There is OCA which does work with a number of other database it's just there isn't a ready built MySql setup. I'll try converting one of the others to run Thanks anyhow Ken -Original Message- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: 02 February 2004 23:42 To: Ken Brown; [EMAIL PROTECTED] Subject: Re: MySql and Oracle Forms 6i Someone posted an answer: "Oh wow... I can't think of how you'd get that to work without a ton of custom. For starters, you'll have to write your own transactional triggers and intercept every one of Oracle's select, lock, update, insert, delete, like On-Lock, On-Insert, etc. since Forms will want things like rowids. You'll also have to write your own on-Login. Mike" Oracle and MySQL differ in date handling, functions, triggers/stored prodedures (or lack of), outer-join syntax, and a hundred other ways that would make Forms incompatible with MySQL. Not to mention the fact that Forms probably uses SQL*Net and a TNSNames.ora entry. David. - Original Message - From: "Ken Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 02, 2004 3:11 PM Subject: MySql and Oracle Forms 6i > Is there any way of using MySql as a back end to Oracle Forms? > > > > > > Ken Brown > > Mail was checked for spam by the Freeware Edition of No Spam Today! The Freeware Edition is free for personal and non-commercial use. You can remove this notice by purchasing a full license! To order or to find out more please visit: http://www.no-spam-today.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql and Oracle Forms 6i
Someone posted an answer: "Oh wow... I can't think of how you'd get that to work without a ton of custom. For starters, you'll have to write your own transactional triggers and intercept every one of Oracle's select, lock, update, insert, delete, like On-Lock, On-Insert, etc. since Forms will want things like rowids. You'll also have to write your own on-Login. Mike" Oracle and MySQL differ in date handling, functions, triggers/stored prodedures (or lack of), outer-join syntax, and a hundred other ways that would make Forms incompatible with MySQL. Not to mention the fact that Forms probably uses SQL*Net and a TNSNames.ora entry. David. - Original Message - From: "Ken Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 02, 2004 3:11 PM Subject: MySql and Oracle Forms 6i > Is there any way of using MySql as a back end to Oracle Forms? > > > > > > Ken Brown > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL and Oracle
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Chen, Mao [mailto:[EMAIL PROTECTED] -->Sent: Monday, November 10, 2003 2:25 PM -->To: [EMAIL PROTECTED]; [EMAIL PROTECTED] -->Subject: MySQL and Oracle --> -->Hi Everyone, --> --> --> -->I'm wondering is there any way we can make MySQL database directly -->'talk' with Oracle database? For example, directly transfer data -->between each other. Directly no. Indirectly yes. --> --> --> -->Thanks for any input. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and Oracle
On Fri, Jan 19, 2001 at 04:07:59PM -0700, Jason Radley wrote: > I am currently using php and mysql and I was wondering if you can take the > data from a mysql database and move it to a oracle database? I'll be experimenting soon with using Oracle's ODBC Gateway to access MySQL data 'live' via MyODBC. Should be fun... Tim. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Oracle
Jason Radley wrote: > > I am currently using php and mysql and I was wondering if you can take the > data from a mysql database and move it to a oracle database? > Thank you, mysqldump exports data from MySQL database and them Oracle should be able to import it. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php