476 results found
-
Execution of a single query to multiple databases
Execution of a single query to multiple databases
8 votes -
When adding revisions, allow searching by commit hash
A nice improvement to the process of adding revision(s) to a review would include the ability to search by commit hash.
In our agile process, a "story" that is ready for code review generally has the last commit hash (or a list of the commit hashes) documented somewhere on the card/case/whatever-you-call-it. Given this information, it would be really nice to simply copy that hash and be able to search for revision(s) when starting a new review.
7 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 -
[Data Compare] Replace a column value with a static string
When synchronizing the database it would be nice to be able to replace a certain column with a string. For example, when you sync the user table to a test database, you dont want to get all the production email address, but would like to replace it with 'test@test.com' or something.
11 votes -
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 -
Todo/Task list for Database Project feature
To expand on the Project feature a Todo/Task list would be awesome as it would help me keep track of things I've done and haven't!!
2 votes -
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 -
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.
-
Pivot Table Generate (DDL/Scheme) to export SQL.
Example:
http://www.codeproject.com/Articles/363339/Cross-Tabulation-Pivot-
Tables-with-MySQL1 vote -
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 -
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 -
restrict the restore option
if any of the users accessing or using the database please restrict the restore option.
35 votes -
rename database
Rename mysql database using dbforge studio
227 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 -
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
- Don't see your idea?