Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Unanswered: SQL Statement Generator For Data Transfer

    Hi,

    We are using VB, COM+ and Oracle Database for Developing a Custom Application for Construction Company. We are using Disconnected Recordsets.

    The DML statements internally generated by the COM+ do all the modification to the database. (we do not have any Explicit SQL statements)

    There is a requirement of TRANSFERING SOME of the Database Tables Data to remote SITE(S) and vice a versa.

    I request all for a solution.

    What I feel is
    - If we have some mechanism to generate SQL statements (Insert/Update/Delete) and store these SQL statements into a Separate table which can be ported at the end of the day and Imported back to Destination database.

    WE DO NOT WANT TO USE export/Import utility. Reason that it will become too heavy due to reason that Oracle Incemental Export means INCLUDE COMPLETE Table even if one record has changed.

    Please Suggest.

    Best Regards
    Last edited by Kalyan; 01-16-03 at 04:19.

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Can't you just use the import/export utility of Oracle?
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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