401 results found
-
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 -
Modify table with foreign key constraints
Currently I always have to switch to SSMS to modify a table that is referenced by foreign key constraints, because I get errors that the table can't be rebuild.
Would be fine to get the same (or better) possibilities as in SSMS.30 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 -
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
-
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 -
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
- Don't see your idea?