>Another person in the office has asked me to post the following question.
>
>I'm writing a script-generator.. which gen's BCP ".FMT" files.. and prepares VFP data via SQL SELECT and COPY to... to QUICKly copy data from VFP to SQL (the Upsizing wizard's much too slow... SQL7's DTS is a bit slow... and still has enough rough edges to warrant further investigation into alternative methods).
>
>Has anyone else done this? How have they handled date format?
>

Hi,

I'm currently migrating a fpw2.6 app to vfp5.0 and mssql server 6.5. The migration wouldn't be any different to 7.0.

I created the tables on mssql server 6.5 using script files. In vfp I created a remote view of these tables and set the update criteria to the necessary settings.

I 'used' the remote view and appended data to the remote from the fpw 2.6 tables. The append is more difficult when the field names in mssql server are different from the field names in the tables in fpw 2.6 but still not a big deal.

I'm using datetime in sqlserver and vfp to replace the date fields from fpw 2.6.

The upload was very quick.

Hope this helps.

Paul de Niverville