That sounds like an ETL job that I would set up in SSIS There are plenty of youtube vids on this.
We use SSIS to extract data from our ERP database nightly for inclusion in the data warehouse and then for our data marts. On Sat, Nov 30, 2019 at 1:52 PM Chris Davis <chr...@actongate.co.uk> wrote: > 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 <profoxtech-boun...@leafe.com> On Behalf Of Stephen > Russell > Sent: Friday, 29 November 2019 16:08 > To: profoxt...@leafe.com > 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 <chr...@actongate.co.uk> > 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: ProFox@leafe.com 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/CAJidMYLkLiY07K-GCWrvCgg=tvQ-12PvMMDe=r0vyxrcfou...@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.
