Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Upsize Wizard - too slow
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00136531
Message ID:
00136849
Views:
22
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform