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