#1 2012-05-22 08:40:07

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

SynDBExplorer: multi tables direct export into SQLite3 DB

SynDBExplorer now features multi tables direct export into SQLite3 DB files.
There is a new button below the tables list: select one or more table, then click on this button.
You can specify an optional WHERE clause to each table (if you do not want the whole DB to be exported), if you want to include BLOB fields (for instance, having all pictures is not mandatory), or the column collation to be used (either the standard SQLite3 ASCII collations, or mORMot Unicode / Iso8601 enhanced collations - which are not standard, so may have problems when used with another tool than SynDBExplorer).

Such a feature may be very handy for remote customer support.
You would be able to export full DB content of multiple tables, then send it back to your own computer, and make any SQL request needed to investigate.
By using a SQLite3 file, you are able to make any JOINed query over several tables, as expected with the real DB.

Speed has been optimized, and creation time is quite good.

See http://synopse.info/fossil/info/0a12083a66

Note that SynDBExplorer is able to open any SQLite3 file: just specify this file name in its command line.
So you can associate all SQLite3 file (*.db3 extension) with SynDBExplorer in Windows, to open them directly.

Offline

#2 2012-05-22 14:00:30

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

Re: SynDBExplorer: multi tables direct export into SQLite3 DB

Now able to compress the exported database into a .zip file.
Compression will use as low memory as possible, so is able to handle huge files.

See http://synopse.info/fossil/info/b7e5a8712a

Offline

Board footer

Powered by FluxBB