Information générale
Forum:
Microsoft SQL Server
>I am in the middle of a data migration from FoxPro free tables (with no code page) to SQL Server. This is a long term process where most of our applications will continue to manipulate FoxPro data and the SQL Server will be the mirror to the FoxPro data (hopefully with a better data structure).
>
>I have written many import programs that run anywhere from every 5 minutes to once per day. Most of them have been written in VFP because it seems that SSIS is just painfully slow when dealing with FoxPro tables. The most recent import I created took about 10-15 minutes to import 96k records where the VFP import did the exact same thing in about 1 minute. It seems that VFP works with SQL Server better than the other way around.
>
>Is anyone else experiencing this same kind of performance with SSIS?
>
>Thanks in advance
>
>Alan
Its been quite a while since I had to do large imports of data into SQL (ie: 500,000+ records), but when I did, I used the bulk copy program at the time (BCP). Anyhow, VFP would output to an sdf type file, then bcp would read via a formatted record layout structure. Process worked great and would read 1,000 records in less than a second into SQL.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement