I have a set of foxpro tables, and I am trying to optimize for speed the import of the data either into Oracle or SQL server. The tables I have contain up to 1 million records and have a size of 1 to 1.5 Gig. What I am looking for is the fastest method for importing them into a RDMS.
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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Optimizing Data Import
- Thread starter Pollock
- Start date
TamarGranor
Programmer
For SQL Server, look for BCP, the bulk copy program.
Tamar
Tamar
- Status
