253 results found
-
Include SQL text in data export
When exporting data to a spreadsheet, it would be nice if it would include the SQL that produced the data in a separate spreadsheet tab. Toad does this and it's a nice feature because if you produce data for someone and they later want the same data, you can just have them send you the spreadsheet so you can run the exact same query for them again.
6 votes -
Ability to navigate forward and backword in SQL Editor like in Visual Studio
Ability to navigate forward and backward in SQL Editor like in Visual Studio
6 votes -
Show the differences when comparing JSON columns
When using the Data Compare if I click on the JSON Data Viewer, the differences between the 2 values are not shown, it would be wonderful if the differences between 2 JSON columns could be displayed with highlighting !
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 -
FULL SCREEN
usefull for coding
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) respondedPlease 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.
-
Faster Way to Export Database Diagram
I'd like a hotkey option to copy database diagram to my chosen default format, like PNG. I'm currently having 3-4 steps to simply save the diagram as a PNG. I'd also like the option to COPY TO CLIPBOARD AS: PNG, JPEG, ETC.
One additional thought, attaching a comment to a table, not free floating. Kinda like a visio diagram. That would be nice for helping improve speed of documentation.
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 -
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 -
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 -
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 -
Additional Relation Notation for Database Diagram
To show a 'many' relationship on the child side, a 'crow's foot' shape is used now. SSMS uses 1 and * (asterisk sign) to show one-to-many relation. So you can add similar notation to the Diagram Document Options. (Now there are two options available: IE and IDEF1X)
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 -
Hide Relationships
Ability To Hide Relationships On A Diagram
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 -
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) respondedThis 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 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 -
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
- Don't see your idea?