Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

do9wnload/upload using delphi

Status
Not open for further replies.
z222

z222

Programmer
Sep 24, 2003
2
0
0
US
Hi;
I need to write a Delphi program to download entire oracle data base then upload it to MS SQL data base, could any body help on that?
 
Sort by date Sort by votes
I'd suggest skipping the delphi step altogether, and writing a Data Transformation Package in the SQL server to grab the Oracle data directly.
 
Upvote 0 Downvote
Or dump the data to text and import it, assuming the DTP fails or looks too hard.

But if you have to write the program (for school or something), it's not too hard. Put two TDatabase components on a form, link each to a TQuery, and go from there. You can speed things up by using direct data acess components, but the BDE approach will work most easily.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

delphi2024
  • Locked
  • Question
delphi xe8 Pls help copy the bold richedit1.text goin to edit1.text
Replies
1
Views
129
delphi2024
delphi2024
RElmaaroufi
  • Locked
  • Question
After programming in Delphi since i
Replies
6
Views
176
RElmaaroufi
RElmaaroufi
nosty1741
  • Locked
  • Question
Some Struggles with Delphi 10.4 Community edition
Replies
1
Views
140
majlumbo
majlumbo
ori_1
  • Locked
  • Question
Populate Excel file (like forms) with data from Delphi
Replies
0
Views
107
ori_1
ori_1
Steveinalab
  • Locked
  • Question
cannot compile if using a public function in another unit 1
Replies
4
Views
113
Steveinalab
Steveinalab

Part and Inventory Search

Sponsor

Back
Top