134 results found
-
Improve code completion support for OPENJSON / WITH fields
When OPENJSON along with WITH to list fields to pull from the JSON data the fields are not visible for code completion purposes. For example in the query below there is no code completion for B.* in the select list and the fields need to be entered manually.
SELECT PD.ProductDimId AS ProductDim
, [Date] = CAST(JSONVALUE(J.JSONData,'$.fields.trandate') AS DATE)
, TONumber = JSONVALUE(J.JSONData,'$.fields.tranid')
, TransactionInternalId = J.InternalId
, [Status] = JSONVALUE(J.JSONData,'$.fields.status')
, Line = B.line
, B.Quantity
, TOCurrentValueUSD = B.CurrentUSDValue
, TOLandedCostPerItem = b.LandedCostPerUnit
, FromLocation = CASE JSONVALUE(J.JSONData,'$.fields.location') WHEN 16 THEN 'In Transit/On Water' ELSE…4 votes -
Cannot describe object
List object name when an error occurs. Example a synonym on a server that is off line. Generic error says can not connect to server.
1 vote -
Option to set comma as the default delimiter for CSV export and copy functions
Currently, unless you override it, the semi-colon is used as the default delimiter for all CSV export and copy functions. It would be very helpful to be able to set the comma as the default in options.
3 votesThis can be setup in the ‘Data Export → CSV’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).
-
copy column data as comma seperated string
I often find myself copying a list of data from a column to be used in another where clause and manually adding the commas. It would be great I could copy a list of values from a column and paste the values separated with commas
1 voteThis can be performed by right-clicking the data grid and selecting ‘Copy Data As → CSV’ from the popup menu.
-
It's not possible to remove object filter in scomp document
After searching for an object, if you clear the filter, data is not displayed
10 votes -
Update Developer Express Grids to current version
I see that you are using Developer Express Grids and controls but that you are using version 13 compared to the current version 19. Please update the grids and controls to the current version and allow users access to most of the features those grids provide.
3 votesIt’s updated to version 20.
-
Prevent auto format when opening stored procedure
When I open an existing stored procedure with Modify menu item, dbForge studio formatting is automatically applied. Is there a way to prevent this?
6 votes -
Crash when pasting tab-separated data
I have data in a text editor which is tab-separated. I copied one line from the text editor with 44 tab-separated integer values no higher than 788 to the clipboard. I then opened a table with 100 columns in edit mode, pressed insert to add a new row and pasted the copied line. The line looks fine at the moment (before sending crash report and restarting), i.e. the paste operation seams to work on the visual layer, but then the crash report showed up.
1 vote -
Change default encoding for saving script files
Default file save encoding is UTF-8. Would be nice to be able to change the default to something else, e.g. Western European (Windows) -Codepage 1252 to make it easier to work with those scripts in other tools.
1 vote -
better copy to clipboard feature of CSV data
when i view a query result, i see all the records selected. i need a quick way to select these records and import into excel. the current copy to csv to clipboard separates the data with a semicolon. when i paste this to xls, it puts each row into cell A. i have to save the file and then import to xls and change the field separator to a semi colon.
thanks
1 voteThis is governed by the ‘Field separator’ option in the ‘Data Export → CSV’ section of the ‘Options’ window
https://snipboard.io/4OEiKT.jpg -
Return back Ctrl+Shift
That combination is used to switch between Windows languages. In the latest update dbForge awaits pressing some additional key upon Ctrl+Shift. Because of this, the first letter is not printed after pressing Ctrl+Shift.
Let combinations with Ctrl+Shift to work only when these keys are hold down.
1 vote -
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.
-
Mouse wheel does not scroll the Database Explorer tree list
I have a database server with many dozens of databases containing many hundreds of objects (tables, views, etc.) each. I use the mouse scroll wheel to scroll this list in MS SSMS and I would hope to be able to do this with dbForge Studio.
1 vote -
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 -
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.
-
Export Data to JSON
Please add support for new FOR JSON
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. -
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
-
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
-
Add code compare built in dbForge schema comparison
Code 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.
- Don't see your idea?