Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving very large volumes of VFP data to SQL Server
Message
From
26/05/2003 16:31:09
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00792866
Message ID:
00792882
Views:
13
I would look into using DTS, it's optimized for high speed data loads and supports things like transformation and lookups.

Roman


>Hi,
>
>I have to come up with a solution that will be responsible for moving between 250,000 to over 10,000,000 records from a VFP table into a table in a SQL Server Database (or MSDE for the clients with lower volumes).
>
>My initial thought was to write a little VB program to bring in about 1,000 records at a time, transform the data into the correct format, and insert into SQL Server using Bulk Insert - and keep repeating the process until all the records have been imported.
>
>Has anyone else had to do something similiar? If so, I'd be interested in hearing about the approach that you used.
>
>Regards,
>
>Al
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform