70 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 -
Link Data from Tables to SourceControl
Link the Data from selected Tables to SourceControl.
Like the Datacompare.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 -
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 -
Retrieve Data select top n rows
Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).
I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).
11 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’. -
Enable Autofilterrow
Please enable Autofilterrow in gridviews!
(Feature from DevExpress)Regards
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 -
Export Data to JSON
Please add support for new FOR JSON
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 -
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 -
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).
- Don't see your idea?