Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Upsize Wizard - too slow
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00136531
Message ID:
00136849
Vues:
23
The upsize wizard isn't great, but it should handle one table with 11,000 records with no problem. Does the table have any memo or general fields with large amounts of data? That can slow things down. You may want to try manually creating the table in SQL Server. Then create a remote view in VFP and append the table to the view. Create any SQL Server indexes after you upsize the data.

An even better option may be the SQL Server BCP utility. You'll need to export your table to ASCII first. BCP doesn't work with memo fields or generals, though.

>Hi, I tried to "upsize" a VFP database container with one table (11,000) records from a Win95 PC to our WinNT server (SQL Server 6.5). It was a tad slow in creating the database/device/log but ground to almost a halt when "sending" table data. In fact it took 4 hours to get to 6%. I left it going overnight in the hope it might finish by morning. It didn't and only Ctrl+Alt+Del could rescue the PC. Can anyone help?
>
>Rgds
>Petras
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform