Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    3

    Question Unanswered: Can you replicate Access 2003 to Oracle?

    I have a VB6 front end application that updates,adds and deletes records in an Access 2003 DB. I also have set up an Oracle DB that I want to be an exact duplicate of the Access tables. Is there any way replicate Access 2003 tables to Oracle or keep them in sync some how so that the Oracle data stays live and accessible?

  2. #2
    Join Date
    Jul 2005
    Posts
    38

    Replication

    You cannot replicate like you would within SQL Server where you would use the Push/Pull metaphor.

    One solution would be to write your own VB and ADO script.
    Another would be to use DTS if you have SQL Server 2000 or 2003.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by billb442
    I have a VB6 front end application that updates,adds and deletes records in an Access 2003 DB. I also have set up an Oracle DB that I want to be an exact duplicate of the Access tables. Is there any way replicate Access 2003 tables to Oracle or keep them in sync some how so that the Oracle data stays live and accessible?
    Not only can the migration tool directly convert Microsoft access tables and views to there oracle equivilent

    http://www.oracle.com/technology/tec...ion/index.html

    But they even have a tool to convert over the entire application. See

    http://www.oracle.com/technology/pro..._to_htmldb.pdf

    So the bottom line is that you publish a web based version of the access database and you never have to use access at all.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •