390 results found
-
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 vote
AdminDevart
(_, 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 -
Recent Files
Clear Recent Files (All) and single item by click right button
10 votes -
Creating constraints with nocheck
Recreating tables with data refill in some cases throw errors.
Please creat constraints with nocheck option first, and check it after if needed. Some ugly databases realy need this.16 votes -
3 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 -
Add option to check before insertion if record already exists
Add an option allowing to check if a record already exists when adding identical record.
4 votes -
Sound notification at the end of long-runnig script
It would be very useful to have an option to enable sound notification of completion of long script execution (when it lasts for more than n seconds)
11 votesAdminDevart
(_, Devart)
responded
In version 6.0, the feature Execution Notification is added. It’s managed by the ‘Environment → Documents → Notifications’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).
Will that be enough or should there also be an option to choose a file to play?
-
Ability to create schema from Database Explorer
Move the functionality of Security Manager to Database Explorer in order to access it in a more intuitive way.
0 votes -
Runtime modules.
SQL Query Builder, Data Editor, Data Report and Data Export available as runtime for distibution by developers.
1 vote -
Add schema name into DB diagram
Add schema name into database diagram tables names, eg into brackets like in SSMS
3 votes -
Temp Table to XML conversion
Most of the times we will take input parameters as XML datatype but finally output we are getting in table format. If we need to get the output on XML formal then we need option to convert datatable to XML.
1 vote -
Open schema/data comparison files
Opening a saved or recent file (schema or data comparison) should not start comparing directly but instead open the "Edit comparison" dialog in the Mapping tab, just in case the user wishes to change the items being compared. When using slow connections between servers, this would be very helpful. If you feel may users would not like such a change, it could be made configurable in the application options (a "Don't start comparison immediately when opening a comparison file" checkbox).
0 votes -
Unfortunately, Query Builder does not support CTE yet.
Per your response "Unfortunately, Query Builder does not support CTE yet."
You added support for CTE's to the application, but left it out of the query builder. So, the result is even though there is support now for CTE's, you still can't fully use it.
Can you you just add the WITH statement to the query builder along with the other (SELECT, DELETE, etc....) keywords it supports?
Seems like it would be a quick, simple, change.34 votes -
Multiline tabs
Please add multiline tabs. I often have many tabs and it's much easier to navigate between them visually (i know where is each of them) then with dropdown or arrows.
Also, please add more descriptive names in document tab names, something like SQL1.SERVERNAME.DATABASE, or options with parameters so that everyone can name tabs based on connection. Now everything is SQL1, SQL2, SQL3 regardles on which database I'm connected to (and I'm usually connected to more that one database). Coloring helps me to distinguish between development and production database, but it's not easy do distinguish between two or more production databases…
12 votes -
Ability to unpin Data window from query
It seems good if you add ability to unpin data window from query. For example, It will be nice (if you use two monitors) to edit query on the first monitor and view data on the second.
1 vote
- Don't see your idea?