Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

MYSQL - Creating a view/table which mirrors an ODBC source?

  • 19-09-2011 04:59PM
    #1
    lunacyfoundme
    Registered Users, Registered Users 2 Posts: 462 ✭✭


    Does anyone know if its possible to create a DB, Table or View in MYSQL which mirrors or replicates a table from an Oracle DB accessable through an ODBC connection.

    I basically want to be able to reference say an up to date table of customers in the Oracle DB but from within the MYSQL DB.

    Any ideas?


Comments

  • #2
    FSL
    Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭FSL


    Is there a MySQL equivalent to the MSSQL OpenDataSource function?


  • #3
    lunacyfoundme
    Registered Users, Registered Users 2 Posts: 462 ✭✭lunacyfoundme


    Ive no idea, I have a reasonably limited knowledge of MYSQL. From my research I dont think its possible without 3rd part sw. Might resort to writing a script which updates a MYSQL table with the required data every hour using Windows Scheduler.


  • #4
    ChRoMe
    Registered Users, Registered Users 2 Posts: 2,021 ✭✭✭ChRoMe


    lunacyfoundme wrote: »
    Ive no idea, I have a reasonably limited knowledge of MYSQL. From my research I dont think its possible without 3rd part sw. Might resort to writing a script which updates a MYSQL table with the required data every hour using Windows Scheduler.

    This gets my vote.


Advertisement
Advertisement