381 results found
-
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.
8 votes -
Vertical Guide Bar for Tabstops
Make an option for the editor to show vertical lines for each tab stop. On long scripts, I sometimes find myself putting a piece of paper up to the screen, which is of course silly.
It would be even better if the lines were distinguishable some way-- perhaps with a tiny number, or if you hovered over them, it could show a tooltip of the first few lines before the start of that indent.
8 votes -
Query Builder Union Support
hi guys
a simple UNION like
SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumber
UNION
SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumberwill create an error "1 Not unique table/alias: 'c' Query.sql".
It would be nice to see the querybuilder processing these kind of sql's.
kind regards
peter8 votes -
If exists then add or create behaviour while generating sync script
Can you please add functionality for if not exists condition while generating sync script for tables and procedures.
for example : if db compare tools detects that a column needs to be added into other database in such a way that it will first check if that column does not exists in target table then only create that column.
and if exist procedure then drop and create procedure.8 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.8 votes -
Database Explorer - group connections by document category
It would be nice to have an ability to group our connections in Database Explorer by it's document category.
7 votes -
Customize TAB name in multi queries
On a multiple execution query, allow to customize the name of the results tabs, by default only shows the table name, useless if the tables are the same.
7 votes -
Have a count on the number of filtered records on the result grid
When analyzing data I often filter the result grid from a query to see how many records there based on certain conditions. The problem is that it doesn't show the number of records after the filter has happened. I then usually export to Excel and then count it that way which is not that productive.
7 votes -
Ability to specify FROM and JOIN clauses when building complicated UPDATE queries in Query Builder
When building an UPDATE query in Query Builder, make it possible to specify the FROM and JOIN clauses in order to define source tables.
7 votes -
When I execute a Query, if the Results are hidden, I would like them automatically shown
When I execute a Query, if the Results are hidden, I would like them automatically shown.
7 votes -
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 -
Save Query as Object
While designing a query user should have possibility to save Query as Object - Microsoft Access approach.
Then user comes back to this query and re-use: execute or modify.
This would be advantage for those projects where user operates with similar entities.
Use Scenario: I create a query "Active Users", save this query.
Then I write another query which uses entity "Active Users". In my new query designed I drag and drop existing query as Table and e.g. join real table with "Active Users" entity.7 votes -
column mode
It would be nice to have a "column mode selection" or "vertical selection", just like the one existing on "Sublime"
7 votesAdminDevart (_, Devart) respondedCould you please describe this in more detail and specify what functionality of dbForge it relates to? Screenshots would be also of help.
You can reply straight to our support system at supportATdevartDOTcom
-
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 -
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 -
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 -
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 -
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
- Don't see your idea?