66 results found
-
Provide an option to increase the font size of the Database Explorer.
Allow us to adjust the font size in the database explorer pane.
86 votesThis can be changed as follows:
1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Environment → Font and Colors’
3. In the ‘Show settings for’ drop-down menu, select
‘Database Explorer’.
4. Specify the needed font and size. -
Ability to include Text Compare results in SQL Schema Compare Report
In dbForge Schema Compare for SQL Server you can see actual code difference in UI in Text Compare section. But when it produces a report there is no option to include Text Compare details. Report only has object level details.
It would be useful to to have option of including actual Text Compare for automated notifications about schema changes.
39 votes -
Add database documentation tool
It would be perfect to add database documentation feature.
Generate documentation as CHM or/and as documentation project which could be used by third party tools like Help&Manual.38 votesYou can download the new product dbForge Documenter for SQL Server at https://www.devart.com/dbforge/sql/documenter/download.html
-
Find and Replace Dialogue: safer scope defaults
The Find and Replace defaults to a scope of "All Open Documents", which is quite irritating and potentially dangerous when Replacing. This causes a jump to a different open document and is an unnecessary distraction. A safer and more reasonable default would be "Current Document", as most of the time I am interested in finding something in the current document. Very rarely am I interested in finding text in all other open documents (Object Finder is a better tool for that kind of thing) and would only want to Replace in All Open Documents in very controlled circumstances.
29 votes -
Better support for 4k monitors
The scaling on 4k monitors is not very good. Most text is readable but some text like on the title bar and in code-completion dropdowns are being truncated. I have to override the high DPI scaling behavior and set it to System to make it more readable and user friendly. Of course, when I do this it makes some text like that on the start page slightly fuzzy.
17 votesIt’s fully supported in version 6.0.
-
All Azure database server databases displayig
When connecting to Azure database server with checked flag "Show all databases" - in the list present only "master" database under "System Databases" directory and database that was selected in "Edit connection" window. In case there was not selected any database(Filed "Database:" was empty) - program connection to some not specified nowhere default database and show "Tables", "Views", "Synonyms", "Programmability" and "Security" items under established connection name at "Database Explorer"
15 votesThere are all databases displayed in the tree of version 6.0.
-
Column / Box / Vertical Select using <Alt> key
In SSMS / Visual Studio you can select a box section / columns from multiple lines for editing using the <Alt> key (EG: Select area on a single line, press <Alt> and down / up arrow and you'll have those same columns then selected in other rows too).
This allows for quickly replacing / editing data that recurs across multiple consecutive lines - It's proved a HUGE time-saver.
I believe this is what was asked for here:
https://devart.uservoice.com/forums/177009-dbforge-studio-for-sql-server/suggestions/14157501-column-modeand it would be great to have that added into Studio.
13 votes -
Ability to set path for storing *.design files
When a sql script is being edited and saved in same directory automated created *.design file. The *.design files in working directories is no good. I suggest to add ability set path for storing *.design files in separate directory. By default it can be temp directory.
12 votes -
Workspaces
The software is great at restoring query tabs from the last session. It would be good to be able to save the current session's query tabs (and sql content) as a workspace. This would simplify working on multiple projects.
12 votes -
Show Column Description
Add ability show|hide Field description in the Table entity additionally to the Field Name and Type
9 votesThis can be setup as follows:
1. Right-click in the diagram and select ‘Options…’ from the popup menu. The ‘Options’ window opens.
2. Switch to the ‘Notation’ tab.
3. Select the appropriate option from the ‘Field Details Level:’ drop-down menu.
4. Click ‘OK’. -
Export Data to JSON
Please add support for new FOR JSON
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 votes -
Enable Autofilterrow
Please enable Autofilterrow in gridviews!
(Feature from DevExpress)Regards
8 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 -
Add ability to define object file name format in Source Control and Schema Compare
Currently dbForge Source Control generates files using <schema>_<objectname>.sql naming convention.
dbForge Schema Compare does the same if you script objects to a folder.Such naming convention does not match our naming conventions.
Can you please add ability to define object file name format in Source Control and Schema Compare? At least define separator between schema and object name and file extension.
6 votes -
DataCompare: Add option to turn ON\OFF Generation of "IF NOT EXISTS" on inserting
I have to script data so it won't produce an error when running the sql statement.. 80% of the time I have to manually update the data synch scripts like this:
IF NOT EXISTS (SELECT * FROM dbo.DescriptionReference WHERE DescriptionId = '0243b2d2-58b2-4aaf-8cfd-0011f036f0e3')
INSERT dbo.DescriptionReference(DescriptionId, CultureCode, IsDefault, Description, LongDescription, SourceTable, IsActive, Created, CreatedBy, Updated, UpdatedBy)
VALUES ('0243b2d2-58b2-4aaf-8cfd-0011f036f0e3', N'en-US', 1, N'2300 REF F8 - P', NULL, N'FormatRuleValue', 0, '2015-06-01', 'TESTA', '2015-06-01', 'TEST')
If I don't and the data exists it throws an error and stops our DB Upgrade process..
IT WOULD BE GREAT if you could have an option to turn on…6 votes -
Generate CRUD Matrix from a SQL Server database.
Generate a matrix showing tables vs. procs/functions that Create, Read, Update or Delete data in that table.
Perhaps this could be achieved by expanding the detail available in the "Used By" section of each table.
4 votesIn version 6.0, the new command ‘Generate Script As → CRUD’ is available in the popup menu of a table in Database Explorer.
This feature can be setup in the ‘Generate Scripts → CRUD’ section of the ‘Options window’ (select ‘Tools → Options…’ from the popup menu).
-
Comment / Un-comment a block of Code.
Frequently I have the need to comment or un-comment a section of my SQL code, e.g. a set of columns or a portion of a WHERE clause. It would be nice if I could select the block, right-mouse, and select comment/un-comment to place the "--" characters in front of the selected lines of code.
4 votes -
Add table triggers as an option to the Generate Scripts database scripting function
The Generate Scripts function under Tasks is missing the option to include database triggers in the list of available objects to include in the output. Triggers are a fundamental component for replicating database schemas and should be included in the scripted output.
4 votesTriggers are turned on by selecting the option ‘Script DML Triggers’ on the ‘Options’ page of the Generate Scripts Wizard https://snipboard.io/GJTyaf.jpg
-
Schema Compare /Sync log
Currently on the command line, the /sync option allows you to specify a file to write the sync script to, instead of executing immediately. When no file is specified, the sync is executed immediately. I would like a way to send the results of the sync operation to a log file of type .txt.
I think it would be beneficial to have a couple of different logging levels:
0 - verbose; each object start and stop time, warnings, and errors
1 - warnings; only objects causing warnings or errors to occur
2 - only errorsWarnings should include the object…
4 votes
- Don't see your idea?