255 results found
-
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 -
Rename foreign key constraints
I'm unable to rename constraints in "Edit Table" mode (expect primary key constraint).
In addition, in database explorer this is also not possible3 votes -
Sort the connections in schema/data compare by alphabetical order
When we go to a new customer site for an install, we typically get connected to the network, open schema/data compare for a deployment and then add a new connection. The problem is when we go back to that site (or remote connect in), it can be tricky to find the connection for the customer.
Can we have something in the connection manager to arrange the connections in alphabetical order so they are easier to find?
3 votes -
Add Space When Accepting an Intellisense Suggestion
Please add a space automatically after accepting an intellisense suggestion.
For example after a table name, when typing "w", "WHERE" appears, when hitting tab it adds that word to the text area, yet I need to then manually add a space. Why not add it as part of the intellisense (as we're used with VS) so I can simply keep on typing seamlessly?
3 votes
- Don't see your idea?