In MSSQL you can script a table out to a Transact SQL script, including all CREATE statements and multiple INSERT statements for the data.
Is there a VFP equivalent that anyone knows of? This is for including test data in source control, it's better to have a PRG that can generate the database than adding binary DBF files etc.
Hi Alan,
maybe gendbc or gendbcx will do what you want?
You could also check Thor to see if there are any tools available that will do that for you.
The upsizing Wizard might be of some help as well.
There is also this tool available for generating sample data: Sample Data as Text to post on forums | Foxite https://www.foxite.com/faq/default.aspx?id=50
Visual MaxFrame Professional has a tool called XXDTGenAndPopCode to turn each record in a table into an INSERT statement.
Frank.
Frank Cazabon
On 02/09/2021 7:05 am, Alan Bourke wrote:
In MSSQL you can script a table out to a Transact SQL script, including all CREATE statements and multiple INSERT statements for the data.
Is there a VFP equivalent that anyone knows of? This is for including test data in source control, it's better to have a PRG that can generate the database than adding binary DBF files etc.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
I've got a tool that I wrote years ago that takes an open table and scripts it to a VFP Create Table or an MSSQL Create table.
Also one that creates SQL Select statements for an open alias and Insert statements (That last one is buggy)
If you're interested, I could send you the code.
On 09/02/21 7:05 AM, Alan Bourke wrote:
In MSSQL you can script a table out to a Transact SQL script, including all CREATE statements and multiple INSERT statements for the data.
Is there a VFP equivalent that anyone knows of? This is for including test data in source control, it's better to have a PRG that can generate the database than adding binary DBF files etc.
Wasn't there a Thor tool that did that?
On Thu, Sep 2, 2021 at 8:13 AM Vince Teachout vinny@caracal.net wrote:
I've got a tool that I wrote years ago that takes an open table and scripts it to a VFP Create Table or an MSSQL Create table.
Also one that creates SQL Select statements for an open alias and Insert statements (That last one is buggy)
If you're interested, I could send you the code.
On 09/02/21 7:05 AM, Alan Bourke wrote:
In MSSQL you can script a table out to a Transact SQL script, including
all CREATE statements and multiple INSERT statements for the data.
Is there a VFP equivalent that anyone knows of? This is for including
test data in source control, it's better to have a PRG that can generate the database than adding binary DBF files etc.
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]
There are also several utilities in the leafe.com downloads, by Kevin Cully and Ed Leafe. I searched for "create" and then selected VFP in the search dialogs.
On Thu, Sep 2, 2021 at 7:06 AM Alan Bourke alanpbourke@fastmail.fm wrote:
In MSSQL you can script a table out to a Transact SQL script, including all CREATE statements and multiple INSERT statements for the data.
Is there a VFP equivalent that anyone knows of? This is for including test data in source control, it's better to have a PRG that can generate the database than adding binary DBF files etc.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
-
Alan Bourke -
Eric Selje -
Frank Cazabon -
Ted Roche -
Vince Teachout