I developed two forms for that purpose: One reads the VFP database and creates each table, with its indexes,default values and constraints into a SQL Server database. The other one passes all the information from each DBF table into the corresponding SQL Server table.
I first change things like dates and logical fields to comply with the SQL Server field restrictions. I use varchar (MAX) in the case of memos. So far, it all works like a charm. Never liked the "built in" converters anyway Rafael Copquin El 04/05/2012 12:45 p.m., Lou Syracuse escribió: > I have similar problems in 2010R2. When I exported the VFP table to other > formats (CSV, XLS,.. etc.) I had to deal with the bizarre field conversions > SQL wanted to do... Woof! > > So now I just write VFP code to do it instead of using the SQL utility. > Problem solved. > > YMMV, but that's what works for me. > ls > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Garrett Fitzgerald > Subject: Importing from VFP into SQL2012 > > Hi, all. Last week, I installed SQL Server 2012 Express on a 64-bit Windows > 7 machine, and tried to import some VFP data into it. I selected the "Import > Data (32-bit)" utility and picked the Fox OLE DB provider, only to have the > app promptly hang and go bye-bye, without even letting me select a > DBC/directory. I checked the Data Explorer in the VFP Task Pane to make sure > it wasn't an issue with running the provider on that machine, but it worked > fine. > > Any thoughts? Thanks. > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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.
