Results 1 to 5 of 5

Thread: Replicate MS SQL 6.5 DB in Oracle 10.2.0

  1. #1
    Join Date
    May 2007
    Posts
    2

    Question Replicate MS SQL 6.5 DB in Oracle 10.2.0

    Could someone please point me in the direction on where to look for info on how to:
    Replicate an MS SQL 6.5 tables on an Oracle 10.2.0 server every 5-10min?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    What do you mean? Copy data from sql6.5 to Oracle? You may need higher sql version.

  3. #3
    Join Date
    May 2007
    Posts
    2

    Exclamation

    yup,

    Export data from SQL 6.5 and replicate those tables in Oracle. Then schedule DTS or whatever to routinely (5-10) min, check for changes in the SQL 6.5 database and update the Oracle accordingly. Would be faster to just update the changes, but if not, repopulating the whole table could work as well.

    I am not sure if you can use Data Transformation Services with version 6.5 though.

    Any suggestions?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    No you can't, dts is in sql7 and sql2k.

  5. #5
    Join Date
    Jan 2007
    Posts
    9
    search for 3rd party soft sinchronizing data between MSSQL and Oracle e.g. via ADO (OLE DB Provider for ODBC layered over the Microsoft SQL Server ODBC driver since MSSQL version 6.5). May be it includes command line interface makes it possible to shedule this proccess. But in case of complicated MSSQL DB structure there are "underwater stones" while data transformation from one RDBMS to other.

Posting Permissions

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