Dear Andrus,

You can use VFP's upsize wizard, however, you may find problems when you have logical field, and you're using MySQL server

Also, I solve this problem by setting the table structure in SQL server using its administrators, then as usual, create remote view with updatable field, and set SendUpdate=.T., then

USE tableA_server IN 0 NODATA
FOR icount = 1 to RECCOUNT("TableA")   && local tables
   INSERT INTO tableA_server (FIELDS) VALUES (DATA)
   SELECT TableA
      SKIP
ENDFOR

In this way, I can change the fieldtype while I upsize as I want... BTW, you have problem on date field, you can use

INSERT INTO tableA_server (orderdate) values (DATETIME(YEAR(TableA.orderdate),Month(TableA.orderdate),Day(TableA.orderdate)))

That lets VFP to handle the date format for you... also I would use smalldatetime for orderdate, since I don't need fragments of seconds...