On Thu, Jan 30, 2014 at 12:57 AM, Marc Delisle <marc(a)infomarc.info
<mailto:marc@infomarc.info>> wrote:
Chanaka Dharmarathna a écrit :
Hi,
I'm trying to support the feature request [0]. With that we need
to think
about export just triggers, just views, just
stored
procedures/functions/events etc. I think this would be practically
needful.
Anyway, I'm not sure about how we could
support this with the current
custom export form. By adding new radio button (views/triggers/SPs) to
'Format-specific options' parallel to structure, data, structure
and
data
Hi Chanaka,
you probably meant checkboxes instead of radio buttons, so that a user
can choose a combination of export sections.
I think that these should be placed under "object creation options" and
"data creation options". Note that you'll need more checkboxes than
you
mention, because, to implement this request, a user would want to
disable the normal definition statements likre CREATE TABLE, ALTER
TABLE, etc.
Hi Marc,
I include my suggestions to the custom export form UI [0] using fire
bug. I added two elements to the custom export form.
1. The radio button 'only view/trigger/SP' to the 'Format-specific
options'
2. The check box 'Add CREATE VIEW statement to the 'Object creation options'
We'll look at how this is going to work.
Item 2 will provide an option to the user, whether to include the view
for his export. Basically this will decouple views and tables. This will
make as a different feature request.
After item 2 is implemented, user can do export with/without
view/sp/trigger. But always export will include at least database structure.
So item 1 will provide an option to not to include database structure to
the export. With this option we can hide some options like '|CREATE
TABLE| options' in 'Object creation options' section which we don't
need.
What do you think on this ?
[0] :
http://i.imgur.com/Ri7m4O5.png
Hi Chanaka,
In our current form, we have clear choices: structure, data, structure
and data (could be improved with just two checkboxes, one for structure
and one for data, but this is another subject).
What I find confusing is that you are adding near these choices, another
choice which is (I think) a subset of the structure.
I would classify a trigger as being part of the structure (it's more
related to structure that to data, right?)
--
Marc Delisle