168 results found
- 
Schema Compare /Sync logCurrently 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
- 
All Azure database server databases displayigWhen 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. 
- 
Modify table with foreign key constraintsCurrently 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.31 votes
- 
WorkspacesThe 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
- 
Export Data to JSONPlease add support for new FOR JSON 8 votes
- 
Ability to View Server LogsProvide the ability to view the SQL Server Logs 3 votes
- 
Database Diagram Export to PDFI'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
- 
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.
- 
Comparing and synchronizing Views using a different schema-mapping doesn't workWhen 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
- 
Quick jump to corresponding BEGIN <-> ENDQuick jump to corresponding BEGIN <-> END In bigger procedures with a lot of nasted BEGIN-ENDs it would be very useful to have a shortcut key or right mouse button option to jump to BEGIN/END corresponding to the one on which you currently have cursor. 21 votesThe feature Jump Between CASE and END is implemented. Please also see the following article https://blog.devart.com/dbforge-studio-for-sql-server-is-ready-for-devops-automation.html 
- 
Running database script against multiple databases on a serverFor example, on our server, we currently have over 400 event databases. We would need to copy and paste the line to call the execute function 400 times and change the database name on each line. It would a great feature if SQL Studio could give us a list of all databases on the server we connect to (with a check box next to each one), with an option to "select all". It would then automatically execute the query against all checked databases. This would save us a lot of time, and would mean your product has all the functionality… 54 votesIn version 6.0, there is now a possibility to select the ‘Run On Multiple Targets’ command from the popup menu of a SQL document. Please also see the following article https://blog.devart.com/dbforge-studio-for-sql-server-is-ready-for-devops-automation.html#run-scripts 
- 
Add code compare built in dbForge schema comparisonCode compare built in dbForge schema comparison is nice, but I miss bottom "Diff pane" like WinMerge has. This is very useful for long line code comparison. 13 votesIn version 6.0, this control was changed and new options were added. 
- 
XML Viewer for XML Data typeIn MSSQL Management Studio you have ability to view xml document returned from query or sp, as pretty formatted SQL document. It opens in separate window (fullscreen). 
 It is a must have feature in dbForge Studio for SQL Server60 votes
- 
Use SpaceBar to auto complete words and nameswhen auto complete drop-down appear, we need to use space-bar to complete the word like as visual studio or ssms. 3 votesThis can be setup as follows https://snipboard.io/uqb2m9.jpg 
 1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
 2. Navigate to the ‘Text Editor → Code Completion → List Members’ branch.
 3. Select the ‘Whitespace’ option in the ‘Commit Selection’ section.
 4. Click ‘OK’.
- 
Apply current grid filters to the queryYou can change the filter and modify sort order. Would be nice if there was an option to flush these settings into a below query. For example, you have "SELECT * FROM table1", execute that, pick to sort by column1, column2, and also where column3 = "AAA", then you use that option - and get "SELECT * FROM table1 WHERE column3 = "AAA" ORDER BY column1, column2". 6 votes
- 
Fix Refresh in 5.5.369Manual refresh appears to be broken in this version. This even includes doing an edit on a table and the script generated does not mirror the underlying table. Have repeatedly seen this. 1 vote
- 
Full text index sync orderWhen you sync the schema of a database that has a full text index in it and stored procedures that reference that index, you cannot sync the schema to an empty database in one step. You must do the tables and the index first, then the functions and procedures. 1 vote
- 
Implement ALT SelectYou should be able to (when virtual space is enabled) hold ALT+Shift and using the up/down arrow keys, select in a vertical line. Allowing you to modify / add or remove characters on multiple lines simultaneously. Similar to how this works in notepad ++ / SSMS etc 1 voteThis feature is present in the latest product version https://www.devart.com/dbforge/sql/studio/download.html 
- 
Option to align the text in the table comparison panelIt would be nice if there is an option to visually align the text on both sides in the table comparison panel. This would mean to align all exact lines on both sides and when the are lines which exist only on the left or the right to put an empty line on the other side. It makes the visual comparison easier and similar to how the Diff/Compare function works in Visual Studio. 3 votes
- 
Setting to customize the highlight color in the table comparison panelCurrently in the differences in the table columns are highlighted with some sort of blue/green, while the column names and the DDL are also in the blue/green color space. It is hard to easily figure out what is the difference. It would be really helpful to be able to change the highlight to any chosen color - for myself I would choose yellow :) 3 votesThis can be setup in the ‘Text Editor → Text Compare Control’ of the ‘Options’ window (select ‘Tools → Options…’ from the main menu) https://snipboard.io/07VTfb.jpg 
- Don't see your idea?
 
        