Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

Creating VB App and Oracle Transfer to SQL Server

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.
0
InvisibleMan
Asked:
InvisibleMan
  • 2
1 Solution
 
Anthony PerkinsCommented:
Please maintain your open questions:
DATABASE SIZE SHRINKING AND LOG FILE QUESTION Date: 03/05/2002 11:06AM PST
http://www.experts-exchange.com/mssql/Q_20273575.html (This question should be deleted as there are no contributions)
MAPPING DRIVE LETTER ON STANDALONE PC IS THAT POSSIBLE? Date: 02/22/2002 09:14AM PST
http://www.experts-exchange.com/networkgen/Q_20269959.html

Thanks,
Anthony
0
 
InvisibleManAuthor Commented:
How do I delete a question Anthony?
0
 
Anthony PerkinsCommented:
Try posting a message in Community Support (http://www.experts-exchange.com/commspt/)

Anthony
0
 
paulllCommented:
I have done this in 2 ways.  Maybe one will work for you.

1 Have a form pop up for the user to enter values.  If no values are entered within a time period set by a timer on the form, close the form.  When the procedure that called the form gets no return value, set it to the default.

If ReturnedValue = "" Then
    'use default values
End If

--------------------------------------------------------

2 Have the program check for a command line parameter to override the default.

temp = Command$
If Len(temp) then
    'set varables to values in temp
Else
    'use default values
End If
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now