253 results found
-
FULL SCREEN
usefull for coding
4 votes -
Hide Relationships
Ability To Hide Relationships On A Diagram
4 votes -
jobs
Add ability to also search in SQL Server Agent Jobs for references to stored procedures, tables etc. to dbForge Search.
Redgate SQL Search has this functionality.
4 votes -
Extensions, plagins, add-in
Do you plan adding user extensions for the IDE (plagins) or some other mechanism to extend the functionality with external utilities?
For example:
- Using the external xml (you could include the editor), add an ability to add menu items (main, popup menu for a database, object, in the editor) where an external program with parameters will run (on a modal window) upon a click: current connection string (with a password, asking the user's permission), current database, current object type, current object name, etc.
A return code will tell what to do ( -1 - error, 0 -nothing to do, 1-update…
4 votes -
Rename Tabs
It would be very helpful to rename tabs, or at least provide a customisable format beyond the default. It's very hard to remember which SQLx.sql tab you need to switch to when you've got several open at once.
4 votes
AdminDevart
(_, Devart)
responded
This feature is available in dbForge SQL Complete and can be setups as follows:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘SSMS Caption’ section. -
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 -
Find results highlighted on scrollbar
In SSMS, when you search for a term, all locations of that term are highlighted on the scrollbar, making it easy to navigate to the locations of that term and to know where they appear in the file. In dbForge Studio, you can bookmark all, but that requires you to scroll through the entire document to find all instances and does not provide a complete picture of all of the places the term appears.
This is a very important feature that is missing for me as I rely on that heavily in SSMS. I would like to see similar functionality…
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 -
Create internal repository for saved SQL Queries
Instead of saving an
.sqlfile in a path, create a managed store with the following features:- Title, description - use AI to generate a suggestion for both fields
- Category and assiciated category management tool
- Extract and save any variables and target DB used by the query (to be used when recalling)
- Editing, deletion, importing and exporting of stored queries
- Recall stored queries with intelligent search functionality
- Dialog when recalling function that would prompt for confirmation or changes to target db, and variable values.
- recent and most used sorting in
Filemenu
3 votes -
Don't resize results pane
It would be great if the results pane a consistent height rather than resizing to the take up all available space not used by the query. Sometimes you'll run a query that to get an idea of the type of data in a table but mean to expand on the query. With the current set up you have to resize the results window to write a multi line query after running the initial one line query.
3 votesAdminDevart
(_, Devart)
responded
Please note that you can redirect the query result to the Data window:
1. Select ‘Tools → Options…’. The ‘Options’ window opens.
2. Navigate to the ‘Environment → Documents → SQL documents’ section.
3. Select ‘Redirect data to Data window if Data view is closed’. -
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 -
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 -
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 -
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 -
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 -
On the customer License Information page, add a user editable field where we can log who has which license.
I purchase the licenses for my dev team, so when I purchase two licenses, one for myself (SQL Tools) and a separate on for one of my devs (Schema Compare) I would like to indicate which is assigned to whom. Currently on the License information page, both appear assigned to me. While two folks is easy, if we grow our usage of your products further, I would like to know who I've assigned which licenses to, while keeping them all under the one account.
All I'm looking for is a field that I as the customer can note this type…
3 votes -
Default Date Only on Datetime Picker for stored procedure parameters
When entering parameter values on a stored procedure of the type of datetime or smalldatetime the datetime picker defaults to the current time, but might better default to midnight or allow the user to quickly change the time to midnight (such as a button click) as it is too laborious to change all of the times to midnight, which I'd guess may be the most common usage for stored procedure/function datetime/smalldatetime entries (dates without the time).
3 votes -
Create virtual foreign keys in database diagrams without writing them into database
I like to create visualizations of Data Warehouses using dbforge. In a Data Warehouse, foreign keys are typically not created physically.
If I could create data base diagrams in dbforge, importing existing tables and creating virtual foreign keys it would be the perfect tool for DWH documentation.3 votes -
Please add the new sql server 2022 features
SQL query window does not accept adding the 'WINDOW xxx AS' clause to a query with a window function.
3 votes
- Don't see your idea?