PLEASE ADD THIS! Save Wizard Queries as SQL files!
Posted: Thu 09 Feb 2017 10:50
I have asked about this, to me, very LOGICAL Inclusion to DB Forge Studio for mySQL:
Once I have used the Data Import Wizard to pull something like a CSV file into a mySQL table, and particularly when it required using the Wizard to manually select how the Mapping was to be set up between Column Names in the Source CSV versus the Target table
THEN
SHOW the Dang Query!
Let me SEE the Query it is going to Use after I have specified, APPEND or blah blah.. Conditions!
Even let me Alter the Import Query the Wizard thinks is correct to what I KNOW is Correct!
For my money into this program let me have CONTROL over the Final "Guessings" of the Wizard's Import Query.
And Automatically, By Default, SAVE the literal Query the Wizard applied after it reports success or failure.
This is, for me, absolutely essential for a PRO tool.
It would, also of course, help me tremendously to Analyze both a Successful Import and an Unsuccessful import.
Especially because quite a few of the Wizard Queries I have worked with over the past 3 years have some sort of "bug" under the hood that prevents execution of Queries that ought to work provided devart correctly applied the Wizard settings.
It is just crazy to simply report a failure with no code to read that I could manually alter for another try.
And when the Import goes Correctly 87% of the time then let me see a Good Query in all its Glory!
AT ANY RATE it would be really time-saving to be able to see the Wizard prepared Import or Export Queries either before or after execution as full SQL text in files.
Thank you for your kind consideration in Expanding the Query Wizard Import Data Controls to Show the Prepared Query Before Execution, to allow it to be Edited if need be, and the Default Option to always save the Queries as SQL files just as with any other Query created inside Studio Forge!
Once I have used the Data Import Wizard to pull something like a CSV file into a mySQL table, and particularly when it required using the Wizard to manually select how the Mapping was to be set up between Column Names in the Source CSV versus the Target table
THEN
SHOW the Dang Query!
Let me SEE the Query it is going to Use after I have specified, APPEND or blah blah.. Conditions!
Even let me Alter the Import Query the Wizard thinks is correct to what I KNOW is Correct!
For my money into this program let me have CONTROL over the Final "Guessings" of the Wizard's Import Query.
And Automatically, By Default, SAVE the literal Query the Wizard applied after it reports success or failure.
This is, for me, absolutely essential for a PRO tool.
It would, also of course, help me tremendously to Analyze both a Successful Import and an Unsuccessful import.
Especially because quite a few of the Wizard Queries I have worked with over the past 3 years have some sort of "bug" under the hood that prevents execution of Queries that ought to work provided devart correctly applied the Wizard settings.
It is just crazy to simply report a failure with no code to read that I could manually alter for another try.
And when the Import goes Correctly 87% of the time then let me see a Good Query in all its Glory!
AT ANY RATE it would be really time-saving to be able to see the Wizard prepared Import or Export Queries either before or after execution as full SQL text in files.
Thank you for your kind consideration in Expanding the Query Wizard Import Data Controls to Show the Prepared Query Before Execution, to allow it to be Edited if need be, and the Default Option to always save the Queries as SQL files just as with any other Query created inside Studio Forge!
