Results 1 to 2 of 2

Thread: Oracle & Ms Sql

  1. #1
    Join Date
    Jun 2006

    Question Unanswered: Oracle & Ms Sql

    My client require e-commerce website and expected to have more than 100,000 products online. All products currently manage on Oracle Application server which is behind the firewall.

    Initially all products will be uploaded to online ms sql server and then whatever the products get change on oracle should be updated online on ms sql db.

    We need proposed solution under secure and easy method to keep online products DB according to the oracle system.

    All this process should be Automatic and Oracle application server send only updated data to MS SQL SERVER because client has more then 100,000 products on their ORACLE Application Server.
    Attached Thumbnails Attached Thumbnails ecommer-connectivity-with-oracle.jpg  

  2. #2
    Join Date
    May 2006
    1. build ftp connection bewteen your oracle app server and sql online server (you need change the firewall settings)
    2. On oracle app server, you can create a shedule a job to export your updated data to a xml/csv file and encypt the file. and then transfer the data file to you sql online server via Ftp
    3. Shedule a job for your sql server, if receive the data file, import to database.

Posting Permissions

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