>To all,
>
>Has anyone actually managed to *get* to MSDE from VFP? Everything I've seen describes getting to MSDE from Access. If VFP is mentioned at all, its only to say "oh, by the way, MSDE also ships with VFP".
>
>I can't even get something as basic as the VFP Upsizing Wizard to work.
Since it's really a SQL server without the graphic interface, you can simply write TSQL scripts in text files and run them line by line from Fox:
nHandle=SqlConnect(cString)
=sqlexecute(nHandle, cCommand1)
=sqlexecute(nHandle, cCommand2)
...etc, where cCommandx would be lines from your script (filetostr(), alines() and then for...endfor).
Yes it's pretty much back to dot prompt, you have to do everything manually, but it's doable.