253 results found
-
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 -
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 -
Provide option to Search data locally or on the server
The search feature in the data view is very slow with large data sets both locally and remotely. In my case I use Azure SQL. Once the data has been retrieved I would like to be able to search the data in the gridview without an additional query to the remote server. You could implement this as a toggle button in the search dialog.
Thanks,
Karl3 votes -
Object Explorer details (Data space used, index space used, row count...)
In SQL Server Managment Studio there is an view: Object explorer details. Where I can see details for all tables in my database. And for example I can sort tables by row count. Similar view in DbForge has fixed columns: Schema, Principal, Partitioned, Create Date, Modify Date, filegroup, Change tracking, Lock_Escalation. But there is no possibility to add extra columns especially: Data space used, index space used, row count.
3 votes -
Custom Right-Click Scripts
Add the ability to create Custom Right-Click Scripts to perform on a given table from the Database Explorer window. Either under Truncate Table. Or as part of Generate Script As...
I frequently need Select count(*) from xxxxx as well as a few others. It'd be great if I could add my own!
3 votes -
use the repository name as the folder name in sql source control
I have a standard folder on my laptop for source control files that gets backed up automatically. I've changed the default folder for source control in the settings but instead of using the repository name as the source folder, it's using a scrambled name.
can you make the software use the repository name instead of the random name so I know which database I'm looking at when looking in my source control folder?
3 votes -
Rows affected not be summed up
When you do an insert and it fires a trigger, the rows affected returned is a lump sum. In SSMS, each row affected is a separate output. So for example, you would get the number of rows the 1st trigger caused and the the actual inserted rows in the prime table. Same applied to update and delete actions.
3 votes -
query shortcuts
Just like SSMS i'd like to use query shortcuts like
selecting a table
press ctrl+1
results is
SELECT COUNT(*) FROM {selected table}3 votes -
Output
Option for cleaning Output before every Execute of sql statement/script
3 votes -
Support for SQLDW (aka Dedicated Pools)
Add support for SQL Server PaaS editions such as SQLDW and SQLDB
3 votes
- Don't see your idea?