Perhaps GenDBCX as mentioned on the FoxPro Wiki and downloadable from the Leafe forum? Sounds like a good place to start.
On Wed, Nov 4, 2015 at 4:30 PM, Ken McGinnis <kamcgin...@gmail.com> wrote: > look for convgendbcxrun.prg or something like that. > > On 11/4/2015 12:51 PM, Ted Roche wrote: >> >> Hi, folks: >> >> Thought I'd break the quiet with an on-topic question. >> >> In several other database backends I deal with, there's a command to >> dump the contents of the database to text so that you can restore it. >> MariaDB has mysqldump, PostgreSQL pgdump. >> >> Is there a "simple" way to dump: >> -- table structures >> -- indexes >> -- actual data >> >> and use the resultant SQL or PRG to create an identical new database? >> Same structures, indexes and PK/FKs? I need to run a series of >> destructive tests and I'm looking for a solution more elegant than >> "ZIP the old data, break it, blow it away, unZIP the old data..." >> >> I've cobbled together bits and pieces of this before using parts of >> GenDBC and various COPY TO TYPE DELIMTED and various hacky commands >> like: >> >> ALTER table clients alter COLUMN iid int AUTOINC NEXTVALUE (MaxClientPK) >> STEP 1 >> >> but wondered if there was a Power Tool out there I'd missed. >> >> TIA, >> >> TR >> > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4uwT3gE7JiOZc5Re7NtX79Hu0v+=uhjqdoy9bohtdk...@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.
