48 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.
-
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.
-
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 -
Implement ALT Select
You 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
-
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.
-
Option to align the text in the table comparison panel
It 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 panel
Currently 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
-
Better performance for large SQL documents
For large documents, say 100,000 lines of insert statements, shut down all language classification, lexing, parsing, etc services during a Find and Replace operation so that one isn't waiting forever for the process to complete. In my experience I waiting forever and had to kill the process. Shut down the services, perform the operation, then turn them back on.
1 vote -
Most recent executed queries
Adding a list of most recent executed queries
1 voteThe Query Execution History feature is present in version 6.0.
-
Restore from source control
Today I search a long time for an option to restore a database directly from source control. I think there is no way, correct? Please add this feature.
1 vote -
Return automatic updates of studio
Please return automatic background updates. I donn't want to enter the site, search «download» button and install updates manually. Old versions has it!
1 voteThis is present in version 6.0.
-
Licensing
Every time I update db Forge I end up in the situation where it asks me for my license. This is so annoying because I then end up in this loop where I have to find my license details, enter them in, get an error message because it is not happy with it, then contact you guys to get a new license. Why can't you just remember the license and not ask me for it again until it expires. I have a team of developers who ran the update this morning and are now unable to do any work until…
1 voteWe have just released a new build 5.4.211 where we fixed some issue with license activation https://www.devart.com/dbforge/sql/studio/download.html
Once you install it, you have to activate your copy of dbForge Studio for SQL Server as described at https://www.devart.com/dbforge/sql/studio/docs/index.html?activation.htm
-
Allow connection to SQL Server running on Ubuntu
I was able to connect to SQL Server running on Ubuntu with SQL Server Management Studio. Be nice to do it with dbForge. Got the error message that the version of SQL Server wasn't supported when I tried.
1 vote -
Transaction log reader
A tool to read transaction logs similar to http://www.apexsql.com/sql_tools_log.aspx
3 votesPlease review the following tool https://www.devart.com/dbforge/sql/transaction-log/
-
Add ability to enter product key on trial versions
Not a big deal, but it would be nice to be able to just enter a product key, instead of having to download a new version.
2 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
- Don't see your idea?