Drew Jensen wrote:
Instead found this Addon for WB 5.2 - SQLite export plugin for MySQL
Workbench http://dev.mysql.com/workbench/?p=227
Correction - it appears that this plugin should work with MySQLWB 5.1
also, but I have not personally tried it.
...after reading over H Schreibt's LUA script I have to think that
altering it to generate HSQLdb 1.8 compliant DML shouldn't be that
much work.
Ok - well put a little effort into this this afternoon. (yes it rained)
My goal is to generate a file that can be used as a Base embedded HSQLdb
database.
A few changes to SQLliste LUA script and I now have a second plug-in
running under WB - ExportHSQLdb - which works for a very simple test
case anyway.
Just wanted to get any ideas on a couple of decisions
1) will limit the script to generate only a single schema from the WB file.
-- Specifically this will be the first schema in the WB files schema
collection.
2) Collation Order
- HSQLdb uses a single collation order for the entire database.
- WB, it appears, only supports collation order set per table.
-- what I did today was simply read the collation order setting for the
first table in the first schema of the WB file and use this for the
HSQLdb collation setting.
3) Users - Only one supported SA - done.
---
OK - gone for now...gonna see if I can get the FK and Constraints to
export properly for the next test file..when I do I'll post the
file...somewhere.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
