none
Query With Multiple Connections RRS feed

  • Question

  • Dear Friends,

     

    I am using vb.net 2005

    I have two different databases under MYSQL & ORACLE

    I want to write a query for MYSQL where i want subquery from ORACLE.

     

    object is:

     

    I have production schedules in mysql based ERP and i have to post them into oracle but always the only new schedules, the schedule transffered once should not be transferred again.

     

    if any one has done it with queries guide me.

     

    Regards

    SKAJ

     

    Saturday, January 26, 2008 1:47 PM

Answers

  • Oracle bought InnoDB one of the storage engines for MySQL so if your ERP software uses it you can do that with simple linked server.  If your software is not using InnoDB then you need to find a solution to run query connecting Oracle and MySQL in ADO.NET.

     

    http://www.oracle.com/innodb/index.html

     

    Sunday, January 27, 2008 6:21 PM