254 results found
-
hide dbo
Please provide an option to hide the "dbo." prefix in the Database explorer
6 votes -
Stacked query results
Add an option to display output for multiple queries stacked instead of as individual tabs (see how this works in SSMS)
6 votes -
Create internal repository for saved SQL Queries
Instead of saving an
.sql
file 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
File
menu
6 votes -
Generate instant INSERT, UPDATE, DELETE scripts (from Source, from Target) from data comparison results window
Generate instant INSERT, UPDATE, DELETE scripts (from Source, from Target) from data comparison results window for multiple records with Ctrl+click.
5 votes -
Enable SQL Studio to work on Microsoft Azure SQL Data Warehouse and Analytics Platform System (APS)
Please enable SQL Studio features to work on Microsoft Azure SQL Data Warehouse and Analytics Platform (APS). Both APS and Azure SQL Data Warehouse have similar parallel DW architecture (MPP). Azure SQL Data Warehouse is the cloud version of on-prem APS appliance. We want a tool that can work with APS / Azure SQL Data Warehouse. Right now dbForge SQL Studio can connect to APS, but nothing works beyond that.
Azure SQL Data Warehouse: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is
Microsoft Analytics Platform System (APS): https://www.microsoft.com/en-us/sql-server/analytics-platform-system
5 votes -
Rename tabs individually
There should be possible to rename a tab. This should override the SSMS Caption template. It should not override the filename if it is a file that is saved to disk.
4 votes -
Please, make it possible to connect MS SQL help in dbForge.
Please, make it possible to connect MS SQL help in dbForge. Following this improvement need to use sql server management studio completely disappear.
4 votes -
Add filter for Object Search
Please add a filter to Object Search results like 'Display distinct names of objects only' (or similar),. That will help with searching objects (tables/views) that contain certain data, but not data itself. Say when I search for string 'rufhweirfi' in my a database, it returns me 4000+ rows from 58 tables, but I need only names of objects that contain such data. That would help with searching pairs master-detail in database that has no relationships for tables.
4 votes -
Automatically Update Schema Cache when Editing Objects
When changing database tables or code with dbForge, auto-complete won't adapt to the changes until the cache is manually refreshed.
You can force a refresh using the Edit menu, Code Completion, then Refresh Local Cache. There's also a hotkey for this-- Control-Shift-R.
That said, when dbForge is making a change to an object, it should automatically update its cache for that object without us having to manually refresh the full cache.
This is also a suggestion for your MySQL product:
4 votesAdminDevart (_, Devart) responded
Please note that you can use the ‘Automatically refresh suggestions cache every xxx minutes’ option available in the ‘General’ branch of the ‘Options’ window that can be opened by selecting ‘Tools → Options…’ from the main menu.
-
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 votesAdminDevart (_, 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. -
Detach stored SQL query from SQL connection
At present, if I developed a SQL query, stored it and try to load it back into dbForge at a later date, dbForge 'remembers' the SQL connection it is associated with and tries to connect automatically. I want to be able to disable this behaviour via options - eg opening file does NOT try to be clever.
EXTENDED RATIONALE
In common usage, the feature is quite useful. Unfortunately, in some of the projects I am working with, I have to constantly switch between different environments (prod, pre-prod, demo, devops, etc) protected by external VPN. All environments are hosting the same…
4 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…
4 votes -
Copy to clipboard search results
In the search window has the ability to copy into clipboard current line. Is it possible to modify to copy all the rows or selected rows ?
4 votes -
Hide Relationships
Ability To Hide Relationships On A Diagram
4 votes -
"smart rename" to rename an object in database automatically and its reference and dependency
"smart rename" to rename an object in database automatically and its reference and dependency.
Just like competitive product "red-gate sql prompt" did.By the way , Devart DBforge Studio for SQL Server is very good and powerful IDE for me. I've bought a licsence.
Thank you and best wishes.
Happy New Year. ^_^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 -
One Database Diagram for All Sql Server
Like "Enterprise Architect" do it, But it UI design very Bad ,no friendly.
So, I Hope you can develop it.4 votes -
Interface / engine to work with SSIS / legacy DTS packages
Abitlity to view/create/modify SSIS packages
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 -
Add option to check before insertion if record already exists
Add an option allowing to check if a record already exists when adding identical record.
4 votes
- Don't see your idea?