On Mon, Feb 9, 2015 at 3:29 AM, Laurie Alvey <[email protected]> wrote:
> 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? > > ------------------- In the DB in SQL Server you rt click the DB name. Tasks | Import Data. A sql server wizard will pop up and ask you the driver to use to read VFP. The table you want to import into. If you have a DATE column you may have an issue? This will gen the schema for you in SQL. It will run real fast compared to VFP pumping this out. Otherwise you can gen up some insert scripts from VFP if you wanted to. HTH -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/cajidmy+72da_b-ja1qxgw1gn+gj+dxbgxpn5ax9bgjo3nav...@mail.gmail.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.
