Creating VB App and Oracle Transfer to SQL Server
Posted on 2002-07-20
Hello all. I have a question and I want the best practice that I should use to do this. I need to run some code against a Oracle database to populate some tables. After this is completed I need to transfer all this data to SQL Server. The oracle population has to be completed via VB Code. My initial thought was to run a VBS file or something then schedule a DTS transfer from Oracle to SQL of the tables needed. Do a truncate on the tables in SQL then a DTS transfer. This would be scheduled to run once a night. However, I also need a VB exe to allow the user to enter certain criteria based on a Date and then manually click to run the same process anytime they want. Do you think what I should do instead is write all ADO code to grab from Oracle and insert to SQL via all VB Code instead? Is there a way for me to have a VB exe that has a button but also I could schedule at night to run starting at a certain procedure call so it would automatically run with a default date I provide it, Instead of creating 2 seperate exe programs. Any suggestions would be appreciated.