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
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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.
