VFP 9.0 and SQL
Question
Answers
All replies
-
Well, there are several ways, easy, fast and/or by using wizards
For a one time transferring you might directly use SSMS, create a linked server using VFPOLEDB and execute queries like:
select
* into SQLTable1from
OpenQuery(MYVFPLinkedServer, 'select * from ("c:\MyFolder\\myFreeTable")')This would get with data and create a structure for you. You can edit the structure in SSMS. You could execute this from within VFP as well. During conversion empty dates would be a problem and/or you might want to change types on the fly, then cast() come to the rescue:
select * into SQLTable1
from
OpenQuery(MYVFPLinkedServer,'select cast( evl(myDate, .null.) as datetime) as myDate,
cast(myFirstName as varchar(20)) as myFirstName,
cast(myGeneralThatIShouldHaveNeverUsed as Blob) as myGeneralThatIShouldHaveNeverUsed
from ("c:\MyFolder\\myFreeTable")')
etc.
If you don't want to or can't create a linked server, then you might roll your own series of SQLExec() with "create table ...", "insert ...". Sounds too much work but I found it to be easier than clicking N times in wizard (of course I didn't type them all but instead wrote code generators).
You could use upsizing wizard in VFP (I don't know the details because I don't use it). If it doesn't support free tables, then easy to solve, copy your tables to a work folder, createa dbc and using a loop with adir(), add all to that dbc and use the wizard for upsizing.
Yet another option is to keep them as DBF files and use Advantage Database Server for ODBC C/S access. Check that out. Local server ODBC driver is free but you have to pay if you need to use as C/S.
