301 results found
-
select as default when i right-click on a table
the context-menu should on top always display - "select data" (not retrieve?? - no other product shows this option)
currently, if i right click on a table - on top is "new table" which is ok when i select "tables" but here it is senseless.
1 vote -
It would be more reasonable if wizard has also a direct sql optimizer
It would be more reasonable if wizard has also a direct sql optimizer
1 vote -
Use SHOW ENGINE X STATUS
When an error occurs when you update a table you only get generic error messages that don't mean anything. Using the SHOW ENGINE INNODB STATUS in my case will give me a really nice description of what actually has happened.
It would be great if on errors dbForge queries the SHOW ENGINE INNODB STATUS and returns a more dev friendly error message.
3 votes -
Display field comments in the database diagrams
There are 3 options to display fields in the database diagram:
* Field names only
* Field name & type
* Field name & precise typePlease, add 1 more to display Field name, type and comment.
It will make the diagram more clear for a person who doesn't know the database structure well enough. As they won't have to click on every table to see what exactly those fields mean.
3 votes -
when debugging stored procedures, pass data to the procedure by string instead of a table input
It seems that data passed to a procedure can only be done via table input instead of by string as would be carried out by callableStatement in java. Otherwise awesome work.
1 vote -
Convert a LINQ query to Stored Proc/View
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 parameters
1 vote -
We need possibility to draw more
We need possibility to draw free any colored lines vith arrows from any diagram point to any other diagram point - small visio line drawing as sample. Without any column linking - only any line drawing.
19 votes -
Multirow update in data viewer
In the data viewer, I can update a single row, however, I often want to update all returned rows. It would be nice to right click on the column and set all rows to the same thing. As is, I have to recraft the query to be an update -- not hard, just annoying (unless I cant, in which case, the exporting of a list of pks into a update is more painful).
Love the software otherwise.
3 votes
AdminDevart
(_, Devart)
responded
This can be achieved with the functionality implemented in the new version by right-clicking in the data grid and selecting ‘Generate Script As → UPDATE’ from the popup menu.
-
Restore scrollbar position after refresh `object update`
Needs to Restore scrollbar position after refresh
object updatepressed.
Point: open data view on table with many rows and columns, then list it to some position for viewing certain data. Then this data changes by outside query and I need to view changes for that. After I pressupdate databutton, then data table position skipped to begining even the number of rows still same and only cell values had been changed.1 vote -
Add the ability set a global file->open language when opening SQL pages
Currently there is no way of setting the default language to read a SQL script.
Users must select 'File -> Open File...' in the main menu EACH time they open a file and tell the program which language the page is encoded in
Within my (local) Environment, my default language (set by Windows) is Western European, however I save all my scripts as UTF-8 (65001) by default as my deployment environment is on a UNIX server
it would be very much appreciated if I could save my default "Open As..." information somewhere in the IDE Options
I'm sure other developers…
3 votes -
Comma separated values when copying cell data
When you copy cell data, for example 5 ids, I would like to be able to copy them as comma separated data in order to use in IN statements.
For example, if you have 3 rows of results like the following:
id name
1 George
2 John
3 GregoryI wish to copy ids as comma separated values in order to use them in a Select statement like:
SELECT * FROM temp t where t.id in (1, 2,3)5 votes -
Pivot Table Generate (DDL/Scheme) to export SQL.
Example:
http://www.codeproject.com/Articles/363339/Cross-Tabulation-Pivot-
Tables-with-MySQL1 vote -
Use Code Compare for diff views
You have Code Compare, so using their logic/viewports to manage the data/schema diffs shouldn't be impossible. Right now the two views are just syntax highlighted blocks of text and it can be difficult to find what actually changed.
I often paste the two blocks into FC so I can see the diff, which is tedious. But important!
3 votes -
Support replace in data editor
So far I have never been able to reaplace a value with Search&Replace.
And yes, the tables are editable.
I can only Search (and find) but reaplace button NEVER works.1 vote -
Format binary column in data grid
I'd like to see a way to make the data grid display all values for a specific columns (in this case, a binary(16)) as a GUID.
Right now I have to create a view for each table and I would prefer it to be more efficient.
This could be solved in a robust and efficient way by allowing the user to apply a function of their choosing to the column. That's really all I'm doing in the view.
7 votes -
Data Import
import from odbc source: ability to import a whole odbc database at once , with the option to create new mysql database
4 votes -
Select all rows in a result windows by clicking on a top left corner
Select all rows in a result windows by clicking on a top left corner. Right now clicking on the square does not do anything. It would be a very convenient way to copy all rows into clipboard.
1 vote -
1 vote
-
Export and import all server definitions, in case we need to change machines
We need a way to export all or a subset, of our servers and be able to reimport them at another box, like our laptop. I need to travel for a month and I have too many servers to do it manually
1 vote -
In schema synchronization script add new columns before dropping old ones
When generating schema synchronization script, add new columns (which are existing in the Source object and are missing in the Target object) before dropping old ones (which are existing only in the Target object).
This will preserve data integrity.
1 vote
- Don't see your idea?