384 results found
-
Database Diagram Foreign Key Improvements
The routed line that maps relationship of the table to the parent with a foreign key align the line drawn between them to the columns mapped, so that easy to visualize the exact FK column matching visually.
That an additional display option allowed. Instead of just CONSTRAINTS alone, offer a Foreign Key option. This pane at the bottom wouldn't be the name of the foreign key, but instead the myid - references Accounts(Id) This would make the documentation easier to use.
3 votes -
1 vote
-
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 -
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 -
Theme Import from Visual Studio VSSETTINGS
Cannot import color scheme from visual studio vssettings or from corresponding sql complete export from ssms or visual studio. https://studiostyl.es/ offers a whole range of custom colors for code enviroment. I'd love the ability to import a color scheme without the needed to manually build item by item in the options menu currently offered in sql studio.
1 vote -
Keyboard Shortcut Missing: Delete Line
Standard shortcut in visual studio/ssms missing. LineDelete.
I currently map to shift+delete and it will delete the entire line the cursor is one. However, I cannot find a corresponding command to map in DbForge Studio15 votes -
default database
When click New SQL default to the database used last for the connection, do not default to the master database
3 votes -
Default Date Only on Datetime Picker for stored procedure parameters
When entering parameter values on a stored procedure of the type of datetime or smalldatetime the datetime picker defaults to the current time, but might better default to midnight or allow the user to quickly change the time to midnight (such as a button click) as it is too laborious to change all of the times to midnight, which I'd guess may be the most common usage for stored procedure/function datetime/smalldatetime entries (dates without the time).
3 votes -
Login Credentials for Internet Proxy
To look for and update dbFS requires internet access. Corporates often demand use of a proxy with login to open a path to the internet. I suggest that dbFS could at least present the login dialog box, and possibly remember my credentials for me when it strikes an internet proxy. This would allow the check for updates to work. Thanks
37 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 -
Don't resize results pane
It would be great if the results pane a consistent height rather than resizing to the take up all available space not used by the query. Sometimes you'll run a query that to get an idea of the type of data in a table but mean to expand on the query. With the current set up you have to resize the results window to write a multi line query after running the initial one line query.
3 votes
AdminDevart
(_, Devart)
responded
Please note that you can redirect the query result to the Data window:
1. Select ‘Tools → Options…’. The ‘Options’ window opens.
2. Navigate to the ‘Environment → Documents → SQL documents’ section.
3. Select ‘Redirect data to Data window if Data view is closed’. -
Generate Scripts Wizard Options
Generate Scripts Wizard should have another options (like those in Data Comparison) especially Ignore TIMESTAMP columns and Inculde/Exclude tables by mask.
1 vote -
Hide Relationships
Ability To Hide Relationships On A Diagram
4 votes -
Ability to designate connection as Production and define rules
I should be able to designate a connection as 'Production' and define rules as to which statements are allowed/disallowed.
Production will not allow any DELETE statements. UPDATE statements will need confirmation before they execute.
0 votes -
Create virtual foreign keys in database diagrams without writing them into database
I like to create visualizations of Data Warehouses using dbforge. In a Data Warehouse, foreign keys are typically not created physically.
If I could create data base diagrams in dbforge, importing existing tables and creating virtual foreign keys it would be the perfect tool for DWH documentation.3 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 -
Order by
In data comparison window, you can filter a table (WHERE) but you cannot sort the data shown on the resulting grid after the data comparison (ORDER BY).
1 voteAdminDevart
(_, Devart)
responded
To perform comparison, dbForge reads out data to the cache. It can’t sort the data, because, to display in the resulting grid, dbForge reads the data from the cache upon scrolling and doesn’t keep it in the grid in order to avoid out of
memory errors. -
Data comparison in multiple databases
When data-comparing two databases, one should be able to change the database in "edit comparison" screen without all selections in the "mappings" screen be initialized. In more details: if one has to compare several databases to a master one (which usually have the same or almost the same structure), there could be a checkbox to "keep previous mappings when changing the database". So, if the previously compared tables are also identical in the newly selected databases, the selected tables and selected comparison keys/columns/filters should be preserved.
2 votes -
1 vote
-
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
- Don't see your idea?