Nightly transfer of Visual FoxPro 9 database (Windows 8) to MS SQL 2016 (Windows 2012 R2).

So you may use SQL pass-through FoxPro functions: https://msdn.microsoft.com/en-us/library/aa975908(v=vs.71).aspx
http://fox.wikis.com/wc.dll?Wiki~SQLPass-Through

1. SQLCONNECT() or SQLSTRINGCONNECT() to establish a connection to SQL Server (see more: http://fox.wikis.com/wc.dll?Wiki~ConnectionString, you just need to provide values from the first table)
2. Above function returns connection handle which you'll use for other function calls
3. Then you may call SQLEXEC() to send SQL commands to the server:

lnH = SQLSTRINGCONNECT("your conn string")
IF lnH <= 0
  *-- process error here
  RETURN
ENDIF
lnResult = SQLEXEC(lnH, "USE YourDatabase")
IF lnResult < 0
  *-- process error here
  SQLDISCONNECT(lnH)
  RETURN
ENDIF

*-- Exporting table columns ID, column1 - 3 to the table on SQL Server having the same structure (column names)
SELECT 0
USE SomeTable
SCAN ALL
  lnResult = SQLEXEC(lnH, "INSERT INTO dbo.sqlTableName (Id, column1, column2, column3) VALUES (?Id, ?column1, ?column2, ?column3)")
  IF lnResult < 0
    *-- Process error here
  ENDIF 
ENDSCAN

Select all Open in new window

Of course, you may update above code to handle UPDATEs of existing data on SQL Server. Also obvious is to build the SQL command in a variable and then use the variable in SQLEXEC. You may also test all above commands in the FoxPro Command Window etc. etc.

The code to process errors can do following:
1. Call AERROR()
2. Display the full error info
3. Exit the program

If you are able to connect the SQL Server on another computer the do it this way instead of copying the DBF files but that depends on your decision. FoxPro help also provides valuable information about SQL pass-through functions.