Re: VFP equivalent of SQL Server 'script table'

2021-09-02 Thread 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

Re: VFP equivalent of SQL Server 'script table'

2021-09-02 Thread 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 In

Re: VFP equivalent of SQL Server 'script table'

2021-09-02 Thread 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/0

Re: VFP equivalent of SQL Server 'script table'

2021-09-02 Thread 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 o

VFP equivalent of SQL Server 'script table'

2021-09-02 Thread 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