Hi John,
>I am about to start converting a large VFP5 system from native Fox Tables to Client Server data (SQL Server).
>I was wondering if there is any FAQ / Tips & Tricks document around realted to this.
>
>Basically I'm looking for some info on what to look out for, what does not work, and what commands,etc. are good/bad.
Take a look at the Data Transformation Services (DTS) in SQL Server 7.0. Basically its a wizard that makes migrating your VFP data (or many other types of data as well) upto SQL Server a snap. Check out the SQL Server books online for more on DTS.
Hope this helps...
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development