Re: drug databases
On Sun, 20 Jan 2008, Karsten Hilbert wrote:
I suggest you provide two options:
--data-only
output INSERT statements only, no table creation
don't use MYSQLisms in INSERT INTO queries
--schema-only
output table defs only, can be mysql-specific
Sounds reasonable.
If none of those options is given, then output schema and
data for mysql (IOW, just like now).
I would (for PostgreSQL) then do:
- first run with --schema-only
- adjust tables for PG
Manually? Hmm, this sucks - I's strongly prefer to enhance the scripts
and it does not sound like a really hard task at all.
- import tables by hand into PG
This should be unnecessary if the scripts do their job right.
- second run with --data-only
- import data into PG by hand
Why "by hand"?
Kind regards
Andreas.
--
http://fam-tille.de
Reply to: