Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting to SQLserver
Message
 
To
17/04/2012 07:03:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01541411
Message ID:
01541811
Views:
42
>thanks to all for your help getting me started.
>I finally am starting to getting to know this beast.
>I even managed to use the vfpx.upsizing wizard. I guess the erros I had received before were caused by my dbc...
>
>now I have another question. Is there a whitepaper on how to use cursor adapters best with sqlserver
>
>Peter
>
>
>
>>>I did and it errors when I want to give the sql db a name
>>>
>>>>
>>>>Get the VFPX version of the Upsizing Wizard. It uses bulk update so it can do the job very fast.
>>>>
>>>>Tamar
>>
>>
>>Naomi's suggestion to dump to CSV and import from SSMS is a good one. Easy and fast.

Check Bernard Bout's articles about how to use CA class:
http://www.foxite.com/articles/read.aspx?id=49&document=creating-using-cursor-adapter-classes-a-simple-tutorial
http://www.foxite.com/articles/read.aspx?id=53&document=creating-using-ca-classes-a-simple-tutorial-part-ii
http://www.foxite.com/articles/read.aspx?id=54&document=creating-using-ca-classes-a-simple-tutorial-part-iia
http://www.foxite.com/articles/read.aspx?id=56&document=a-very-simple-ca-tutorial
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform