473 results found
-
Create automation engine like VBA in MSOffice and CorelDraw or plugins Interface
It would be nice to have ability to develop automation scripts or plugins to allow extensibility of dbForge Studio for MySQL.
For example, I have repeating task:
1. Create backup of database A
2. Create backup of data in table b in database B
3. Overwrite database B with backup of database A
4. truncate table b in database B
5. Write data from backup of data in table b to database B
6. Performe some data modifications in database B
(all of this to produce developers copy of database from production database)I think that performing this feature will…
9 votes -
3 votesAdminDevart (_, Devart) responded
This can be workarounded by using the MySQL command “SOURCE”. For example, in the new SQL file, you can type the following:
SOURCE .\sqlfile1.sql;
SOURCE .\sqlfile2.sql;
…
SOURCE .\sqlfileN.sql;Here, instead of the local path .\ you can specify it explicitly as follows:
d:\folder\sqlfile.sql
-
Ability to import several tabs from single Excel file at once
add a feature to import excel tables with several Regions because when you import the first region (or TAB) the action finishes and you have to begin again open the same file and perform the same action. I'm importing a 300 tables with 262000 records each one and is very difficult to open each file 5 times!!
1 vote -
Error when importing DBF file with field type CURRENCY
A have dbf files with FoxPro database. When i trying to import file with CURRENCY datafields I get error: "Неверный или неизвестный тип колонки DBF"
1 voteAdminDevart (_, Devart) respondedCould you please provide us the CREATE definition of the table into which you are importing data and the imported .dbf file so we can reproduce this issue on our side?
-
Add filter to save and then use the previously introduced
Add filter to save and then use the previously introduced
8 votes -
3 votes
-
Add support for build variables/parameters
There are times when some arbitrary string or bit of code needs to be different for separate build configurations.
For example, in a project that contains numerous cross-database queries, one might need to specify the database based on which build configuration was selected.
This could be handled by providing a way to define variables (or parameters if you prefer that term) that could be placed in the table, stored procedure, etc. scripts. The variables would be replaced by values specified for each build configuration when generating the deployment (or schema change) script.
3 votes -
2 votes
-
Add switch key to mouse click to open table in different views
Add a switch key (SHIFT, CTRL or ALT) to the mouse click behavior to open a table in design, text or data view with a single click.
6 votes -
Add option to get one ALTER statement for each db change
Currently I have "nested" statements like the following and if one column add fails the rest of the query additional fails!
ALTER TABLE cmsgewaehltemodule
CHANGE COLUMN parentid parentid INT(10) NOT NULL DEFAULT 0 AFTER id,
CHANGE COLUMN seitenid seitenid INT(10) NOT NULL DEFAULT 0 AFTER parenteintragid,
CHANGE COLUMN systemmodus systemmodus ENUM('live','staging') NOT NULL DEFAULT 'live';1 vote -
Put SQL into Excel Export
when doing exports in excel, it would be perfect to have the SQL (used for this export) in seperate sheet called "SQL" in the generated excel file.
it happens very often that you send an export to someone, and after a few days he needs a modification of this export. then i always have to search for the SQL i used fot this export.
if the SQL would be inside the excel, it would never get lost.currently i put it inside manually, but it would be great to have this feature "by default" or as an option at the…
0 votes -
Make it understand macroses used in UniDac
It would be great if dbForge Studio for MySQL understood macroses, that are used, for instance, in UniDac, or just ignored them.
Currently, if you copy code from the TUniQuery SQL editor, you need to then edit it. Once it has passed debugging, you need to edit it once again in TUniQuery SQL editor. It's quite uncomfortable and sometimes takes much time.
Also, code formatter converts &dtstart into & dtstart (i.e adds space after ampersand (&).
0 votes -
Add '= <Name> = <Paste From Clipboard>' option in 'Quick Filter' sub-menu of Data Editor popup menu
When right-clicking in the grid, implement an option in the popup menu 'Quick Filter -> = <Name> = <Paste From Clipboard>'
3 votes -
Allow export on master detail browser of displayed data.
While viewing a set of data in the master-detail browser, it would be nice to be able to export the data that is shown on the screen. The export could be done for each master-detail tab separately or it would be nice to be allowed to export data from all currently displayed tabs; however, this would have to be separate files or Excel sheets for each tab.
If nothing else, allow copy on the data rows so they can be manually copied and pasted into Excel or other application.
1 vote -
Debug a cursor in a stored procedure
Can be able to see the input parameters of the SQL sentence that contains the cursor
3 votes -
Select font size in query builder
When designing a query with a lot of tables, the font size gets too small to read. You should be able to change the font to make it readable.
1 vote -
Add "Optimize for empty tables" option in Data Comprison wizard
Use case: Moving data from production environment into empty test environment.
If source or target table is empty then there is no need to compare rows. In the frontend it looks like every row is processed in a loop, takes half a minute to process ~30000 records, and a lot more time to process a million records.
I suggest to perform a record count on the target table. If target table is empty, just suggest to copy over all rows in the source. If target table is not empty, then check source table. If source table is empty, then suggest…
1 vote -
Ability to import nested xml tags
Your XML import only can deal with a single dimension of data. There is no way of dealing with the [Link] second hierarchy. Properly creating a schema and/or entities is very important now with web services and there are not many programs that can do it.
6 votes -
Sync edit object in tag with selection in the database explorer
Please could you add a feature where the tab you are editing, e.g. a table, is sync selected with the database explorer
2 votes -
Improve network performance. I store script on a network share. For some reason dbForge takes forever to load and save to the share.
I store scripts on a network share. For some reason dbForge takes forever to load and save to the share. Other programs do not have this problem.
1 vote
- Don't see your idea?