Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Upsizing VFP tables
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Upsizing VFP tables
Divers
Thread ID:
00288470
Message ID:
00288470
Vues:
60
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
Matthew Kennedy
Decision Support Technology Inc.

"I try to take one day at a time, but sometimes several days attack me all at once." ~ Ashleigh Brilliant

New Jersey Dot Net User Group
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform