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

    Unanswered: SQL Statement Generator For Data Transfer


    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
    Can't you just use the import/export utility of Oracle?
    Ruud Schilders
    Oracle DBA
    e-mail :
    URL :
    Twitter :

Posting Permissions

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