473 results found
-
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 votesAdminDevart (_, Devart) respondedThis 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.
-
Backup/Restore does not order Views so that a View that references another View is after the referenced View
When doing a Backup / Restore, It does order the Views so that if one View references another, the referenced View is defined first. I assume it orders them by case. Could you make it so that it defines the prerequisite views first or ahead of the views that require them.
Thanks for the amazing program, I realize this probably isnt a bug in dbForge but more a generic SQL issue but it would be nice if dbForge would transparently order them when making a backup.
1 vote -
Restore scrollbar position after refresh `object update`
Needs to Restore scrollbar position after refresh
object update
pressed.
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 data
button, 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 -
Bring back "is not blank" quick filter in Session Manager
It used to be, until version 6.3, that in the session manager, you could filter a column for "is not blank", which made it easy to see only active sessions. Now we have to go in a dialog for that.
Either bring back the quick filter, or make the session manager save it's state so that it comes back with the same filters when you restart dbForge Studio.
1 vote -
Colors for datatypes
Displaying fields of different types in different colors, as example int* - blue, char* - green etc, in data editor and table editor. Maybe in compare tool.
As HeidiSQL: http://www.heidisql.com/screenshots.php?which=grideditors
65 votes -
Capability to spell check the text that is entered into the database
I suggest for the developer to have capability to spell check the text that is entered into the database. The current software does not permit spell check so with that I currently have to put info into another database file that can check for spelling, export to excel and then upload to the program, which is taking time to export/import. If I have to tweak a record, I have to be sure to do it in both files, which if not done correctly could cause files down the road to not be the same.
3 votes
- Don't see your idea?