Hi Laurie
Some time ago I developed my own upsizing form. It is actually two
forms, one that creates de SQL tables from the VFP database and another
one that passes the data from the DBF's to the SQL tables.
It's got all the labels and notes in Spanish but the code is self
explanatory. It works with SQL Server Express 2005 and 2008 (just switch
a property). Never tried it with 2012, but I am sure it would need very
little tweaking.
Caution, it will not take care of relations (I never embed them in the
DBC) or triggers. It will pass the indexes with no problem, except for
compound indexes (something like:"dtoc(date)+str(invnbr,5)" but will let
you create the indexes manually.
You need to change the following properties:
cBaseSQL (the name of the SQL Server database ie: widgetco)
cDataBase (path and name of the VFP DBC --"c:\myapp\tables\widgetco.dbc")
cDir (folder where all dbf's reside iE: "c:\myapp\tables")
nSQLversion (ie: 2008) could be 2005 or 2008
cConnString (your particular connection string, derived from a DSN)
I can send it to you if you would like to try it
Rafael Copquin
El 09/02/2015 a las 7:29, Laurie Alvey escibió:
Hi All,
I'm trying to export a VFP9 database to SQL Server Express 2008R2. I first
tried the Upsizing Wizard from VFPX but it told me I had to set the
database compatibility level to 6.5 (no, that's not a typo, 6.5!). The
lowest the SQL instance will allow is 2000.
I then tried the import/export wizard in SQL Server using the VFPOLEDB.
That failed as well, complaining it could not establish the code page for
the table columns.
Short of manually creating the SQL Server objects and importing from flat
files, any ideas?
Laurie
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
