254 results found
-
6 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
6 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.
5 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 -
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 -
Hide Relationships
Ability To Hide Relationships On A Diagram
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 -
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 -
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 -
FULL SCREEN
usefull for coding
4 votes -
Data compare / Copy selected records with foreign keys into another DB
Please implement selective export of certain records and all related records in child tables (by foreign key).
Doing whole data compare in our case is estimated at 7.5hrs, which is too long for practical use.
This feature would be very useful in our reproduce/troubleshoot workflows, replacing whole DB backup/restore, which is roughly 150GB, times 2, to be moved over network.4 votes -
Interface / engine to work with SSIS / legacy DTS packages
Abitlity to view/create/modify SSIS packages
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 -
"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 -
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 -
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. -
When adding a column to existing table with existing data, provide option to update the column to the default value for all existing rows.
In SQL it is possible, when adding a column with a default value to a table with existing data, to set the value of the column in the existing rows to the default value:
ALTER TABLE {TABLENAME}
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
CONSTRAINT {CONSTRAINTNAME} DEFAULT {DEFAULTVALUE}
[WITH VALUES]I would like to select this option when adding a column to the table in the designer, and also be able to include the option when scripting the changes to the table - when a schema comparison is done, have the WITH VALUES option included in the script.
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.
-
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
- Don't see your idea?