Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upsizing VFP tables
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00288470
Message ID:
00293758
Views:
21
If you check the option to create the SQL script than after the upsize is complete the project manager displays and you can open the table that has a memo field with the script in it.

HTH!

>I recently ran my VFP tables through the upsize wizard to create the SQL server tables. Everything worked perfectly and I can easily access the tables with remote views and SPT. Now I want to distribute my application and install my SQL server database on a user's server.
>
>My first instinct was to backup my database and then restore on the user's server, but I understand there are potential probelms with this if the user does not have the same char set or sort order on their server.
>
>So it seems that I need to create the database and tables through code. In reading through Chapter 20 "Upsizing Visual Foxpro Databases" of the MS VFP Guide, they say that "The script table stored on your hard disk contains all the SQL code generated by the SQL Server Upsizing Wizard ...". I haven't been able to locate this code, anyone familiar with it?
>
>Kind Regards,
>
>Mat
DLC
"Use the Right Tool for the Job!"
davidandcynthia@email.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform