267 results found
-
Database Diagram Foreign Key Improvements
The routed line that maps relationship of the table to the parent with a foreign key align the line drawn between them to the columns mapped, so that easy to visualize the exact FK column matching visually.
That an additional display option allowed. Instead of just CONSTRAINTS alone, offer a Foreign Key option. This pane at the bottom wouldn't be the name of the foreign key, but instead the myid - references Accounts(Id) This would make the documentation easier to use.
3 votes -
Save remote server address or add flag "Save this server address"
Save remote server address or add flag "Save this server address" for choosing from "Server" dropdown when new connection is created
3 votes -
Create Guid
Add a new menu item "Set Value To" -> "New Guid" in context menu when clicking on a cell (if the cell is type of uniqueidentifier).
3 votes -
Intellisense for tables in tempdb
When joining, querying, or trying to expand table.* column names for a table in the tempdb database, Intellisense does not work even for tables that existed when starting dbForge.
It would be nice to be able to have that feature even if it meant manually adding the table to the Intellisense cache.
3 votes -
Quick filter for Object Explorer
It seems to me that it would be convenient to quick filter or highlight objects in object explorer simply by typing (condition "contains" by default not only starting) or pressing the key combination. Thanx.
3 votes -
Quickly Update Source Schema
An option to quickly get the update script for a single table in the opposite direction. (From Target back to source). I need to get all changes done by other developers and some developers make changes to one of two different databases, and I need to merge changes to/from the two main databases.
3 votes -
Pivot Table should provide SQL
The Pivot Table is great, however it would be nice if it provided the SQL code, such that it can be used elsewhere. This would make for a great pivot builder.
3 votes -
CSV - Support importing data that uses brackets for negative values into money fields.
It is fairly common in other tools/database (like Access for instance) for exported money or currency type fields to represent negative numbers by putting brackets around the value. Currently when such values are imported they give a truncation warning and put the value in as positive.
(10.00) should go in as -10.00 instead of giving a warning and going in as 10.00.
3 votes -
column totals
Show column totals (sum) or average at the bottom of the column. This would be great with a right click of the column header then click then click Group Footer then click Sum or Average
3 votes -
LinqPad-like Script Browser
LinqPad has one useful feature that could be used here in dbForge Studio too. It has a panel which shows folder structure of one specific scripts folder (configurable location). In this folder users can organize scripts into subfolders (projects). And by double-clicking on script in this panel you open the script. This folder can also be synced (via dropbox or other cloud drives) so you have same structure and scripts on multiple machines. This is a similar feature request as project workspaces. Could be easy to develop and would really help us who work on lots of projects and databases…
3 votes -
Filtering code completion
When you filter the objects in the Explorer->Tables view
It only logical that the auto completion in the Sql script would be filtered too.Maybe an option inside Options -> Code Completion -> "Use filtering on objects" would allow the user to select the desired flavor.
If you have that option selected, when you do a filter in object explorer, when you are writing a sql sentence autocompleting tables, it only shows tables with that particular filter.
Thank you.
3 votes -
It would be extremely helpful to have "tab groups" for open SQL scripts. It would be nice to help organize multiple scripts.
When working with multiple scripts, being able to further organize them in the editor panel would be helpful, especially as a DBA. Or, as an alternative to tab groups, perhaps a project panel where scripts can be organized into virtual folders for quick access could be added.
3 votes -
Default Retrieve Data Query
Add the ability to define the query executed on a Right-Click / Retrieve Data.
I use this feature frequently and always go in and edit the query to order by id desc. It would be nice to be able to override the standard select *.
3 votes -
I would like to see a "File -> Rename" command (like in Notepad++).
I would like to see a "File -> Rename" command (like in Notepad++).
3 votes -
Add filter for Data search
Add filter for data search.
Example: search for '1234' value in tables containing 'abcd' substring in table name and/or in fields having 'id' name only.3 votes -
Export Data to SQL with Structure
I would like to export data from a table to SQL and have the option of the SQL doing a "DROP TABLE" "CREATE TABLE" to create the table and insert the data. Currently the options only allow for data insert, update, etc. Please add the ability to include the structure of the table and fields.
3 votes -
Have an option for unlocking a DB that dbForge has exclusively locked
When I try to restore a database (from SSMS on the server), sometimes dbForge has the DB exclusively locked and the restore fails. I end up then needing to close all my tabs in dbForge, and then shutting down dbForge.
Why not have an option to release dbForge's lock on the DB?
3 votes -
Add "By Name" filter to dbForge Search
Add a "By name" button next to DDL. This would be similar to DDL, but would exclude definitions (e.g., it would include SP name but not SP definition). This would allow use of dbForge to quickly look for for specific SPs or tables as a more convenient/faster alternative to SSMS object explorer. It is possible to set the object types to only include procedures, but doing so still includes contents, which makes for a search that is both slower and noisier.
3 votes -
See query that filter automatically is generating
When I filter the results grid in DBForge Studio for SQL Server, it's great to quickly get the results i need! However, there are times I'd like to see the SQL of the filter (i.e. what it is putting in the WHERE clause) so I can use it in my own SQL query. Currently I do not see a way to view or export that. This would be a nice feature to have!
3 votes -
Configurable Layout
It is typical to write or extend a sql stmt on the top of a query window and to see the result in the bottom.
dbForge has not that standard behaviour for this window. My Suggestion is to configure or save the last the window layout as it will be needed.
I know there are two buttons in the bottom to click on to change this layout but when you work the whole day with this tool and you have click 200 times a day these both buttons it's getting bothersome and not a good user experience.3 votes
- Don't see your idea?