Thanks Russell I will get on google/youtube tonight and look into this , thanks for the heads up
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Stephen Russell Sent: Sunday, 01 December 2019 13:48 To: profoxtech@leafe.com Subject: Re: SQL Dump
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 chrisd@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-bounces@leafe.com On Behalf Of Stephen Russell Sent: Friday, 29 November 2019 16:08 To: profoxtech@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 chrisd@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]