Thanks everyone for all the ideas and advice, I will give them a try. Effectively what I am trying to create is a way to replicate a VFP DBC to a SQL Database daily.
-----Original Message----- From: ProfoxTech <[email protected]> On Behalf Of Stephen Russell Sent: Friday, 29 November 2019 16:08 To: [email protected] Subject: Re: SQL Dump What incorrect answers these were. IN the DB you made in SQL Server you can import the data at SSIS speed. Rt click on the DB in the DB pane. Tasks and Import Data. >From there you tell it to use VFP data via your oledb engine. From >there it will make all tables and indexes from VFP and import it very fast. Sorry I was driving when this was first posted. You can Youtube SQL Server Import data and see a few different vids on how to do this. The wizard has been around for decades and still does a great job of setting up what you need to do and allowing you to watch the process as it is cranking. Your single row inserts will waste a lot of energy updating the log for each row you inserted. This skips that altogether. On Thu, Nov 28, 2019 at 10:55 AM Chris Davis <[email protected]> wrote: > Hi All > > Is there any tricks I am missing which would speed up a dump of a VFP > table into a SQL table. > > I have predifined by SQL statement something like this > > "insert into mytable (myfield) values (?m.myfield)" > > I am then scanning through the VFP table performing a scatter memvar > and then executing the SQL. > > It works it just seems to take alot longer than I imagined it would. > > Thanks IA > > Chris. > > > --- 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: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/loyp123mb31675c5862926255b6f297868f...@loyp123mb3167.gbrp123.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.
