-
1 PDF per record export function in the Report-Designer
...including a "filename-builder" with query data:
[AddressID]-[InvoiceID]-[Date].pdf - for example
6 votes -
Support Multiple Cursors like visual studio or sublime text
I can go into detail upon this being developed. Sublime Text (and to a lesser degree visual studio) support multiple cursor editing which is a tremendous boost in efficiency of coding. At this time Dbforge SQL Studio doesn't support this. Recommend adding this functionality.
6 votes -
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 -
Relationship names on a DB diagram are not "comments". Need ability to show table descriptions independent of showing relationship names.
When "show comments" is selected, both table descriptions and the names of relationship lines are displayed. The relationship names are not comments, and mostly clutter up an otherwise clear and concise diagram. Show comments should only show table "comments"; a separate button/option is needed to display relationship names for those who want to see them (I do not).
6 votes -
hide dbo
Please provide an option to hide the "dbo." prefix in the Database explorer
6 votes -
Add status icon to tab when query is executing
When a query is executing for a long time, I sometimes switch to a different tab to continue other work. It would be great to have a status icon on the tab that shows whether a query is actively executing on that tab!
6 votes -
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 -
Preserve brackets arround stored procedure and function names or any database item
I need to keep brackets around stored procedure and function names, but dbForge keeps removing them.
Original
CRATE PROCEDURE [dbo].[SprocNameSample] After saving my changes to
the sproc:
CREATE PROCEDURE dbo.SprocNameSampleThis behavior goes against the convention established at my workplace.
Please allow us to keep the brackets in place when we save changes to Stored Procedures and Functions.
6 votes -
Schema snapshot standalone utility
Deliver with dbForge also small utility to make schema snapshot. Sometimes I need to get DB schema from customers and it would be nice to send them such utility. Them will create by this tool schema snapshot and send it to me. Then I could run schema compare in dbForge.
5 votes -
5 votes
-
Feature: Split Editor Window Horizontally
Copy of Request from Oracle Features Page:
dbForge Studio for SQL Server should provide users with the ability to split the editor window horizontally. This feature should be equivalent to that provided by tools such as Microsoft's Visual Studio. This feature will be specially helpful while working with large queries and result sets.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 -
More options to customize diagram
It's possible to have a fine grained control on several to render several element on diagram. For example now I see field with not null attribute with a font normal and field with Null attribute in Italic and not in black color but in gray.
Can we have full control on way this element be rendered?
Some times can help can change background of table box or header color to group related table that can appear anywhere on page without use the actual "container" feature.5 votes -
Add properties dialog and shrink option
Simple feature missing from dbForge Studio SQL - DB properties dialog, so I cannot, for example, view size of DB.
Also - a related feature - database shrink option is not there. Shrinking whole DB and/or just transaction logs is a common task in our workflow, to save space on DB server, after a backup was restored.Both features are present in MS SQL Management Studio. If dbForge is to replace MS tool, it must have these two features.
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 -
We really need the ability to backup and restore Azure SQL databases
SQL Server (non-Azure) makes it very easy to backup and restore. Not so with Azure. Even if we can't restore to Azure, it would be great to backup the database like any other SQL database, and restore it to a local SQL instance.
4 votesAdminDevart (_, Devart) responded
You could use dbForge SQL Azure Backup http://www.devart.com/dbforge/sql/sqlazurebackup/download.html
-
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. -
Add option to save data into snapshot
Optionally, make it possible to save data into a snapshot.
4 votes
- Don't see your idea?