RE: SQL Dump
Sorry! Thanks Stephen even! -Original Message- From: ProfoxTech On Behalf Of Chris Davis Sent: Sunday, 01 December 2019 14:30 To: profoxt...@leafe.com Subject: RE: SQL Dump Thanks Russell I will get on google/youtube tonight and look into this , thanks for the heads up -Original Message- From: ProfoxTech On Behalf Of Stephen Russell Sent: Sunday, 01 December 2019 13:48 To: profoxt...@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 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 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 > 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/loyp123mb316720b5102d5fd680f8462e8f...@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.
RE: SQL Dump
Thanks Russell I will get on google/youtube tonight and look into this , thanks for the heads up -Original Message- From: ProfoxTech On Behalf Of Stephen Russell Sent: Sunday, 01 December 2019 13:48 To: profoxt...@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 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 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 > 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/loyp123mb3167ca14761cf90701c5b51f8f...@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.
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 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 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 > 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.
ProFox List Statistics for November 2019
== ProFox List Statistics November 2019 == Subscriber Count at End of Month: ProFox: 292 ProFoxTech: 181 == Total Posts: 196 (Up 18.79% from October 2019) Total [OT] Posts: 0 (Unchanged from October 2019) Total [NF] Posts: 4 (Down 86.21% from October 2019) Daily Message Counts for November 2019 DOW Date Count --- - F 1 - 4 S 2 - 2 M 4 - 3 T 5 - 1 W 6 - 11 T 7 - 15 F 8 - 1 T12 - 3 W13 - 2 T14 - 8 F15 - 7 M18 - 1 T19 - 2 W20 - 18 T21 - 25 F22 - 26 S23 - 5 S24 - 2 M25 - 17 T26 - 18 W27 - 5 T28 - 6 F29 - 10 S30 - 4 Message Counts By Day of Week for November 2019 DOW Count --- - Sun -2 Mon - 21 Tue - 24 Wed - 36 Thu - 54 Fri - 48 Sat - 11 Distinct Posters to the List (changes relative to October 2019) Non-OT messages: 35 (Down 10.26%) OT messages: 0 (Unchanged) NF messages: 4 (Down 71.43%) Total number: 35 (Down 10.26%) Top 20 Contributors by Number of Non-OT Posts |Posts Contributor | 1. 38MB Software Solutions, LLC 2. 21Alan Bourke 3. 13Eric Selje 4. 11Koen Piller 5. 11Frank Cazabon 6. 10Gene Wirchenko 7.9Stephen Russell 8.9Tracy Pearson 9.8Paul Newton 10.7Jürgen Wondzinski 11.5Chris Davis 12.5AndyHC 13.4Charlie Coleman 14.4Richard Kaye 15.4Vince Teachout 16.4Ed Leafe 17.4Paul H. Tarver 18.3Kurt at VR-FX 19.2Jean Laeremans 20.2Darren Top 0 Contributors by Number of OT Posts |Posts OT% Contributor | Top 4 Contributors by Number of NF Posts |Posts Contributor | 1.1MB Software Solutions, LLC 2.1 3.1M Jarvis 4.1krdib...@stny.rr.com Top 20 Contributors by Total Number of Posts |Posts Contributor | 1. 38MB Software Solutions, LLC 2. 21Alan Bourke 3. 13Eric Selje 4. 11Koen Piller 5. 11Frank Cazabon 6. 10Gene Wirchenko 7.9Stephen Russell 8.9Tracy Pearson 9.8Paul Newton 10.7Jürgen Wondzinski 11.5Chris Davis 12.5AndyHC 13.4Charlie Coleman 14.4Richard Kaye 15.4Vince Teachout 16.4Ed Leafe 17.4Paul H. Tarver 18.3Kurt at VR-FX 19.2Jean Laeremans 20.2Darren Top 15 Contributors by Number of New Threads Started |Posts Contributor | 1.6Jürgen Wondzinski 2.4MB Software Solutions, LLC 3.2Johan Nel 4.2Paul Newton 5.2Stephen Russell 6.2Chris Davis 7.1List Administrator Account 8.1Vince Teachout 9.1Matt Slay 10.1 11.1Frank Cazabon 12.1Jean Laeremans 13.1M Jarvis 14.1krdib...@stny.rr.com 15.1Tracy Pearson Top 20 Non-OT Threads by Total Number of Posts -- |Posts Subject | -- 1. 24So, about this VFPA thing... 2. 18File Sync 3. 18Fatal error issuing CALCULATE command 4. 17X# code for drag and drop 5. 16VFP Advanced (was Fwd: Fatal error issuing CALCULATE command) 6. 16Exporting Tables 7. 14SQL Dump 8. 12Gartner Analyst Relations 9. 11We''re getting old ;) 10.8AW: So, about this VFPA thing... 11.8The JVP line still exists after all these years 12.5Windows 10 X to support Win32 apps 13.5Using XML String as part of query in SQL Server 14.4How common is Table Buffering with DBFs?? 15.3VFP TSQL concordance 16.3AW: How common is Table Buffering with DBFs??