255 results found
-
Ability to export/save font colors and settings
It appears that I can't export the font and colors settings in Options -> Environment -> Fonts and Colors. This would be a great feature addition that would allow me to export my personal theme design and apply it again whenever I do an upgrade or install the software again.
3 votes -
Implementation of Registered Server Groups
In SSMS, there is a feature called Registered servers, which allows for creation of groups of servers eg. Development, which contains sql server instances for all development servers.
With this option, a user can execute the same script against all the servers in the group.
This can be useful in a scenario such as if you need to execute a query against your database in each of your retail locations.
I would like to see this feature implemented in dbForge Studio IDE.1 vote -
helper for json script
Hi, we use a lot of json caluses in our db procedures e.g.:
select
*
into
#parcel_data
from
openjson(@parcelData, '$')
with
(
"ParcelId" int '$.ParcelId',
"ParcelTypeId" int '$.ParcelTypeId',
"ShipmentId" int '$.ShipmentId',
"BarCode" nvarchar(100) '$.BarCode'
);
Why don't You prepare such a helper in dbForge Studio ? It could be located on the level of "Generate script as" menu for each table for instance. To have the possibility to prepare our own plugins would be also a good idea.1 vote -
Include a System Procedure folder in a Database Explorer
Database Explorer doesn't include System Procedure folder which would be great to have.
Thanks.1 vote -
Allow to group/organize Functions or Stored Procedures within folders created by the user. This way, it is possible to group by functionalit
llow to group/organize Functions or Stored Procedures within folders created by the user. This way, it is possible to group by functionality.
Over time these kind of objects pile up and become increasely difficult to manage.4 votes -
Add related tables
The "Add related tables"-function (same as in SSMS) is very useful when creating a database diagram from an old database.
1 vote -
auto rename tab with regular expression
would it be possible to add a RegEx search in the script to automatically rename the tabs
"^(\s)(CREATE|ALTER|CREATE\sOR\sALTER)(\s\w\s)((([|)..(]|))|)(([|).(]|))\s*$"
1 vote -
Add progress when executing script
Show somewhere (the status line at least or perhaps in a new status window) the percentage of commands of a script that has been executed.
1 vote -
Add Space When Accepting an Intellisense Suggestion
Please add a space automatically after accepting an intellisense suggestion.
For example after a table name, when typing "w", "WHERE" appears, when hitting tab it adds that word to the text area, yet I need to then manually add a space. Why not add it as part of the intellisense (as we're used with VS) so I can simply keep on typing seamlessly?
3 votes -
Sort the connections in schema/data compare by alphabetical order
When we go to a new customer site for an install, we typically get connected to the network, open schema/data compare for a deployment and then add a new connection. The problem is when we go back to that site (or remote connect in), it can be tricky to find the connection for the customer.
Can we have something in the connection manager to arrange the connections in alphabetical order so they are easier to find?
3 votes -
Clone data comparison window
There are times that you may wish to perform two similar structure or data comparisons. It would be useful if when right-clicking on the tab of a data comparison window, in the context menu that appears, there was a "clone" option. This would generate a clone of the existing structure/data comparison window containing the exact same options of the original window. Then you would be able to just alter the few options you wish and perform the new comparison in the new window, without destroying the comparison that exists in the original window.
2 votes -
Support SHOWPLAN diagrams
Like in Management Studio, I would like to be able to see the Execution Plan of my query.
3 votes
AdminPMs
(Admin, Devart)
responded
This is already present in dbForge https://docs.devart.com/studio-for-sql-server/optimizing-sql-queries/working-with-plan-diagrams.html
-
remove one condition from filter list
To be able to remove only one filter condition from the grid (list). Not having to clear the filter and start all over again.
1 vote -
Filter on modified date
Hi,
It would be good to add a "modified date" filter to the defaults. Currently it is very hard to display only recently modified elements.4 votes -
Ignore File Locks on Excel Files During Import
The Excel file should be copied to a temp file to ignore file locks caused by the file being opened in Excel. The import should allow a refresh at the end of the wizard right before the import begins.
1 vote -
Clean Field Names on Data Import
Most spreadsheets I get have unsupported characters in column headers - like slashes, line breaks and spaces. It would be great to have the import wizard allow a regex or other way to clean up the columns in a batch. e.g. "sales rep" could become "SalesRep", or "district / group" could become "DistrictGroup"
1 vote -
the user should be provided the ability to download the results into an excel.
In the "dbForge Search for SQL Server" product, the user should be provided the ability to download the results into excel.
1 vote -
Return same data as SSMS Messages tab
In SSMS the number of rows affected by a tsql statement is printed to the Messages tab. In dbForge Studio only the number of rows returned to the application is sent to the Output->General window.
The details in SSMS are extremely useful, especially for UPDATE and DELETE statements or other code that returns no data to the application (e.g. selecting rows into a new table).1 vote -
Bulk data type adjustment for external import
When importing data, there needs to be a way to adjust the data type for multiple fields at the same time. I can select multiple fields and choose edit, but after adjusting to varchar(255), the data type only changes for one of the selected fields at a time. I have 134 fields to set the data type to varchar(255). I don't have time to set the data type for each field. Very frustrating and unproductive. I can't use this product until this feature is added.
2 votes -
Show the differences when comparing JSON columns
When using the Data Compare if I click on the JSON Data Viewer, the differences between the 2 values are not shown, it would be wonderful if the differences between 2 JSON columns could be displayed with highlighting !
6 votes
- Don't see your idea?