156 results found
-
Git source control
Add Git source control option (SVN and TFS are already supported). I find that the concept of Git and how it works fits really well with our database development flow.
89 votesPlease have a look at v5.0 beta.
-
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. -
XML Viewer for XML Data type
In 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 -
Support for more source control systems
Especially systems that provide a command line tool to perform tasks like CheckIn/CheckOut/AddFile ...
E.g. Seapine Surround or others55 votesThis is implemented in dbForge Studio for SQL Server, v5.2 Beta https://www.devart.com/ru/dbforge/sql/studio/download.html
-
Running database script against multiple databases on a server
For 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
-
Ability to generate insert/update stored-procedures for given table
I like to right click a table name and dbforge should produce a stored procedure for insert/update out of it, like
CREATE PROCEDURE tblTest1_IU @id Int, @[user] Int, @stamp DateTime2(6) AS BEGIN IF EXISTS ( SELECT * FROM dbo.tblTest1 WHERE id = @id) UPDATE dbo.tblTest1 SET [user] = @[user], stamp = @stamp WHERE id = @id ELSE INSERT INTO dbo.tblTest1 ( id, [user], stamp) VALUES ( @id, @[user], @stamp) END
41 votes -
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
-
36 votes
We would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Export Database to SQL
Add an ability to export database schema and (optionally) data to an SQL script.
33 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Search query history like SSMS Tools Pack
It'd be great if dbForge Studio could periodically save a copy of the query file in some temp folder and also provide an interface to search all that history (and not just the current window).
32 votes -
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 -
Easy Way To Hide Results
In dbForge - as with SSMS - when you run a query, the results appear in a pane at the bottom. SSMS lets you easily toggle the visiblity of that pane with the Ctrl+R keyboard shortcut.
You can do the same thing with dbForge but there's no keyboard shortcut for it. Instead you have to click on the little double down arrow button at bottom right.
Please add a keyboard shortcut so it's easy to quickly toggle the visiblilty of the results pane.
Thanks!
28 votesThis feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html
-
Data generator
Redgate does a data generator that is quite useful. It looks at the schema for the tables and generates randomized (according to rules that you can select) data to fill them. It is quite useful when you need to say generate 100,000 rows for testing.
28 votesData Generator is available in dbForge Studio for SQL Server, v4.5. Feel free to leave a feedback.
-
Color for connection
Ability to associate a color to a connection, so that queries/tools open for that connection can have background or border of that color to remind you which connection you are working with. We have local dev/shared dev/qa/staging/production environments, and I would like to be able to visually differentiate which connection is being used.
27 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
25 votes
We would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Backup / Restore database
Implement the ability to backup and restore databases just like in dbForge Studio for Oracle and dbForge Studio for MySQL.
23 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Ability to create new database from popup menu in Database Explorer
one glaring omission seems to be that you cannot create new databases using this tool - so I have to still revert to Management Studio to create the database, then switch to Devart for everything else.
Is it possible you could add this functionality?
21 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Quick jump to corresponding BEGIN <-> END
Quick 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
-
Refactoring of existing queries
Especially: renaming table aliases. Other suggestons:
adding aliases, adding or removing AS keywords, replacing aliases with table names or vice versa, removing 'redundant' aliases or table names.18 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server.
- Don't see your idea?