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 &dt_start into & dt_start (i.e adds space after ampersand (&).0 votes
When importing files in the Mapping screen, the software shows which destination fields are and are not mapped to a source field. It would be great to know which source fields aren't mapped to a destination fields too.0 votes
When we synchronise a DB schema with another we push the SQL SECURITY INVOKER setting but editing the destination/target procedure afterwards the GUI ignores this and reverts to DEFINER.0 votes
A great feature would be a LINQ to SQL tool for SP/Views.
I write complex queries in LINQ with linqPad, grab the generated SQL and then create a SP/View from this code.
It's an error prone process with complex queries creating parameters0 votes
I don’t see how I can have a few VIEWs open simultaneously (in the designer). I’m used to having at least 5 open at a time, often 20 or more. Well, without names that’s impractical anyway. Right-Click / Design View seems to disable further exploring – I can’t minimize it. Wow! Hope I can have several instances open simultaneously.0 votes
When there are parameters in code, dbForge Studio for MySQL automatically offers to enter them.
Adapt the Edit Parameters window for macroses as well. Users should be able to enter macroses' parameters or select an option to ignore them.0 votes
Would be nice that all statements would be ";" terminated in logging in SQL log so I could copy paste execute a bunch of them on another database to replicate my changes.0 votes
Make it similar to query analyzer in MONyog.0 votes
compare source objects, table def & data via right-clicks (See Beyond Compare@ScooterSoftware.com)0 votes
Add a feature to preserve custom code in mapping and class files through "custom code region"0 votes
In SSMS when you drag'n'drop the Columns node from Database Explorer onto the text editor, a column list separated by a comma is inserted.
Also, you could make it to be able to drag'n'drop selected columns onto the Data Editor.0 votes
Make the constructor understand a variable with no @
Currently, the constructor doesn't understand a variable having not specified @, so you need to add it manually.0 votes
Add the ability to comment selected text in a SQL document using multi- line comment syntax /* ... */0 votes
When using code snippets, make it possible to replace selected fragments using a usual drag'n'drop without the need to manually delete them.0 votes
When making a table change, validate all source objects / views (in case of column name change). Provide list of objects that this update affects and allow double-click to edit or view update (with preview) Beyond Compare style!0 votes
A user variable (AKA:session variable) not showing in the autocomplete list. Variables defined using the DECLARE syntax show up fine but those created using the "SET @" method do not.
DECLARE v1 INT;
SET @v2 = 1;
users AS u
When working with a SQL document, make it possible to specify the default database of the document by simply selecting it in Database Explorer (similar to Heidisql) rather than selecting it from the 'Database' dropdown menu on the 'SQL' toolbar.0 votes
Whether used on my laptop with a touchpad or my desktop with a mouse, dbForge Studio doesn't support scrolling in any window by any means other than clicking or dragging the scroll bar. It will initially scroll for perhaps a second and then it stops.0 votesAdminDevart (Admin, Devart) responded
You could try the following instructions http://www.microsoft.com/hardware/en-us/help/windows-8/how-to/mouse/use-partialscroll-mouse
I'm creating a view using the valid SQL:
SELECT dateAsString(MAX(a.dateStart)) AS LastDate ...
dateAsString is a UDF in my database that accepts a DATE parameter.
The query executes fine. When I save it in a view, though, dbForge changes the query text to:
Which, obviously, won't work.
Any thoughts?0 votesAdminDevart (Admin, Devart) responded
Could you please provide us the following information:
1. Version of the MySQL server.
2. CREATE definition of the UDF.
3. The assembly file containing the functions called by the UDF.
- Don't see your idea?