|
One of the most common
activities when working with MySQL is exporting and importing data, this
article focuses on that while using DreamCoder for MySQL.
The DreamCoder for MySQL
has several mechanisms that facilitate the process of exporting data which are
detailed below:
Export Manager: This
option facilitates the complete or partial exportation of database in SQL
format. This option is very practical since you can export scripts and other
data at the speed of light.
Export Data: This
option is available in the table view and the SQL editor, and it allows us to export
data from grids whether it is a consultation result. With this option we can
export the data in 14 well known formats, which are, excel, word, html, access,
pdf, xml, txt, csv among others. It also includes special export options within
each format.

Advanced grid options:
On this menu we find several options that facilitate direct exportation of data
to MS Excel or to the clipboard.
Possible options:
1. Copy all records to clipboard
2. Copy selected grid
3. Copy rows to grid
You can copy all the data or a group directly to excel or a clipboard.
Also, there are four more options called "export custom grid" which allows
us to export grid data, which includes data of groups and operations you are
currently working on.
These export options
are available on the commercial version of DreamCoder for MySQL.
|