Re: VFP equivalent of SQL Server 'script table'

[Ted Roche]

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  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]

___
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/cacw6n4tpdn+sfnjycdehass_vj4kus0cdsixx_hrptyhd3k...@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.

Re: VFP equivalent of SQL Server 'script table'

[Eric Selje]

Wasn't there a Thor tool that did that?

On Thu, Sep 2, 2021 at 8:13 AM Vince Teachout  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]

___
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/caawxvunkaldturb1zdn5zs33xmx66qkf2tgvmqfe+bzrgj-...@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.

Re: VFP equivalent of SQL Server 'script table'

[Vince Teachout]

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


___
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/ba78269b-2def-2a2e-8779-d2ce2b717...@caracal.net
** 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: VFP equivalent of SQL Server 'script table'

[Frank Cazabon]

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 



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
---

___
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/87eac7c4-b16d-8fc6-0f10-8c3850001...@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.

VFP equivalent of SQL Server 'script table'

[Alan Bourke]

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
---

___
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/c8289ef0-1f85-4355-aaa6-8e3d9891b...@www.fastmail.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.