385 results found
-
Shortcut Ctrl +Alt+o conflict with windows Alt+o - local alphabet letter
Shortcut Ctrl +Alt+o is in conflict with windows Alt+o . So you can't get the Polish letter 'ó' what is annoying when try to comment your code in Polish not only because the letter, but especially because jumping out of your current context. Suggestion: option for you own definition of the short cut.
10 votes -
Generate CREATE script for filtered objects (e.g. Procedures)
Filter Objects in databse explorer and then select contecxt menu item to generate the CREATE script.
This would be much faster and easier to handle than the newly integrated Generate Script Wizard.9 votes -
Allow :param bind variables like we use in our Code
In my development, I use :variable for paramters. I come from the Oracle world. This @ thing causes me 2 issues. First, it stops my query from working with copy/paste once I debug it. Second, when I copy a query from the web, or my app, and try to paste it in, I have to edit it.
It would be nice if EITHER:
1) The : worked as a bind variable (even if I had to turn on a flag)
2) The : REPLACED The @ if that makes it easier for you to do...9 votes -
Locate in database explorer
In SQL Complete the F12 (Go to definition) expands the item in database explorer. In dbForge Studio this opens table in new window.
I would like similar option in text editor context menu, for example Locate in Database Explorer, which will expand to the wanted node, whether it is table, column, procedure, view etc.
9 votes -
Add option to specify display format for numeric values
Many large numbers are hard to read, and only Date / DateTime formats can be specified. I'd like to add thousand separators (either komma or dot) at least
9 votes -
Auto-refresh before editing a view or table
When right-clicking a view or table, please have SQL Studio do a background "refresh" of the view or table before opening the edit window so the user can be assured of getting the current code or view. If I don't remember to hit F5 or 'refresh' I get old, cached data which can be very confusing and frustrating.
9 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 -
Enable Autofilterrow
Please enable Autofilterrow in gridviews!
(Feature from DevExpress)Regards
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 -
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 -
Database Diagram Export to PDF
I'd like to be able to export the database diagrams to a pdf, or something more scalable when publishing my diagrams to my teams documentation library.
8 votesAdminDevart (_, Devart) responded
Please note that you can export Database Diagram to one of the available formats with the ‘Export to Image’ feature available in the popup menu of the diagram. Please also see the following article http://blog.devart.com/how-to-save-database-diagrams-as-an-image.html
-
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 -
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 -
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 -
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 -
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 -
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) responded
Could 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
-
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
- Don't see your idea?