I recently used the VFPX upsizing wizard and don't recall that particular gotcha. There were others such as null support on Boolean columns but it ultimately did work. Because we have the source I was able to make a few tweaks, not to mention run through the debugger so I could figure out what was going on.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Laurie Alvey Sent: Monday, February 09, 2015 4:30 AM To: [email protected] Subject: VFP to SQL Server Migration 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/cy1pr10mb021803ee2b286a6e6bddad74d2...@cy1pr10mb0218.namprd10.prod.outlook.com ** 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.
