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
utf8 in mysql is a proprietary 3-byte format and doesn't support real utf8 encodings with 4-byte chars. As result, when dealing with real unicode, many scripts generated by dbforge fail with "Incorrect string value: \xF..." because mysql cannot understand 4 byte strings.
The correct utf8 encoding in mysql is 'utf8mb4' and everywhere dbforge puts utf8 by default (generated scripts, default connection encodings, etc), it should put utf8mb4 to improve support.
Currently I have to save all scripts and change utf8 to utf8mb4 manually.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.
Show dialog suggesting to select an action (SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) when drag'n'dropping object from Database Explorer onto SQL document like in EMS SQL Manager for MySQL.0 votes
Add gutter (aka right margin) for code inspections.0 votes
- Don't see your idea?