385 results found
-
The ability to save a set of scripts as a project or a solution.
Allow the grouping and saving of scripts into a project or solution. This would allow the grouping of related scripts into a single file set that can then be opened more easily. This would also allow a developer to more easily keep scripts related to a specific job synchronized and loaded.
For example, loading the Paycheck project will load all of the scripts related to the Paychecks task. Then, by loading the Employee project will switch out the scripts with the ones for the Employee task.
7 votes -
Comparing and synchronizing Views using a different schema-mapping doesn't work
When comparing and synchronizing views while using a different schema-mapping:
*) equal views are marked as different cause of the different schema in the view name and the different schema within the select -> please adapt the compare-logic to accept the correct displayed sqls as equal
*) the generated sql for updating views doesn't work because they contain the right schema (target) in the view name, but the wrong schema (source) within the select -> please replace objects with the source schema within the select of the view with the target schema7 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
-
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 -
Allow for the top filter row to be used on the DexExpress grid
Allow for the top filter row to be used on the DexExpress grid like the used to view table data.
6 votes
AdminDevart
(_, Devart)
responded
Could you please describe this in more detail?
-
Apply current grid filters to the query
You can change the filter and modify sort order. Would be nice if there was an option to flush these settings into a below query. For example, you have "SELECT * FROM table1", execute that, pick to sort by column1, column2, and also where column3 = "AAA", then you use that option - and get "SELECT * FROM table1 WHERE column3 = "AAA" ORDER BY column1, column2".
6 votes -
hide dbo
Please provide an option to hide the "dbo." prefix in the Database explorer
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 -
Save Window Layouts
The ability to save and restore different window layouts
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 -
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 -
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 -
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 -
Allow to enter which windows credentials to use
For example, I regularly work from home on a VPN from a non-domain joined machine. I would like to be able to able to type my domain credentials in so that I can authenticate as my Active Directory user.
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 -
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 -
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 -
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 -
5 votes
- Don't see your idea?