164 results found

1. Set Compatibility Level to SQL 2022 (160) on Edit Database Page

   Right click on a database on a SQL Server 2022 Enterprise Edition Instance and select Edit Database. Switch to the Options tab. Select the Compatibility level dropdown, I am only seeing up to SQL Server 2019 (150) as options, I am missing the SQL Server 2022 (160) option and need to manually write the ALTER DATABASE statement to set it.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Bugs  ·  Delete…  ·  Admin →

2. Schema added to properties when not required

   Currently when I use Query designer the resulting query is expressed as:

   SELECT
     Hygiene360Log.Hygiene360LogId,
     Hygiene360Log.RequestDate
   FROM dbo.Hygiene360Log
   

   Where what I want is the minimum length of text to correctly identify tables and objects, like this:

   SELECT
     Hygiene360LogId,
     RequestDate
   FROM Hygiene360Log
   

   It's very annoying

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Bugs  ·  Delete…  ·  Admin →

3. migration

   Migration Based Deployment System

   I’m searching for an option that the database keeps a log of the migrations (scripts) that are already performed. When I’m deploying new migrations it can simply look which migrations are already done (or set to not done) and continue from there.

   When my colleague is then updating his database he can execute all scripts which aren’t yet done on his database. This will results in his database being completely updated while saving, updating of removing the data (This is done without a compare (just script executions) which is great, because his changes aren’t removed). Then he simply add a new migration script with his changes as the newest script.

   Isn’t there an option like this that devart adds an extra table to my database which keeps the executed migration scripts? And maybe a bit that we can set to zero to execute a migration again?

   Migration Based Deployment System

   I’m searching for an option that the database keeps a log of the migrations (scripts) that are already performed. When I’m deploying new migrations it can simply look which migrations are already done (or set to not done) and continue from there.

   When my colleague is then updating his database he can execute all scripts which aren’t yet done on his database. This will results in his database being completely updated while saving, updating of removing the data (This is done without a compare (just script executions) which is great, because his changes aren’t removed). Then… more

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  1 comment  ·  Features  ·  Delete…  ·  Admin →

4. dbForge Search

   It would be extremely helpful if the results of a dbForge Search (within SSMS) could be exported (or at a minimum, be able to be highlighted and copied).

   Also helpful would be a way to narrow/filter the Found In results (to say just body). This would be moot point if data could be exported.

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Features  ·  Delete…  ·  Admin →

5. Use *Full* Intellisense Suggestion With Tab

   Typing "order" after a table name brings up the intellisense with "ORDER BY", yet when hitting tab to accept, only "ORDER" gets entered in the text area, the only way to get both words is by hitting Enter. Why not on tab like I'm used to?

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Features  ·  Delete…  ·  Admin →

6. Refresh from server when right click > modify a stored procedure, etc.

   It would be great if the system would automatically refresh an object when you open it to edit. SSMS does pulls the current version, but this system just opens the cached version. This has cost me hours over the time I've used this product. One example use case:

   • Right click a stored procedure > modify
   • Make changes
   • F5 to run update script
   • Close window
   • Sometime later, repeat and you get the version that was from before you made the first changes.
   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  1 comment  ·  Delete…  ·  Admin →

7. Schema comparison ignore users

   Add the ability to ignore Users in Schema Comparison.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  1 comment  ·  Features  ·  Delete…  ·  Admin →

8. 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 '' END
   , ToLocation = CASE JSONVALUE(J.JSONData,'$.fields.transferlocation') WHEN 15 THEN 'Receipt' ELSE '' END
   
   , Container = JSONVALUE(J.JSONData,'$.fields.custbodypcapcontainernumber')
   
   , DateOfArrival = CAST(JSONVALUE(J.JSONData,'$.fields.custbodypcapactualarrival') AS DATE)
   -- , ItemJSON = a.Value
   -- , A.*
   FROM NetSuite.JSONRecords J
   CROSS APPLY OPENJSON(JSONQuery(J.JSONData,'$.sublists.item')) AS A
   CROSS APPLY OPENJSON(A.value,'$')
   WITH (SKU VARCHAR(50) 'lax $.itemdisplay'
   ,Quantity INT 'lax $.quantity'
   ,QuantityFulfilled INT 'lax $.quantityfulfilled'
   ,QuantityReceived INT 'lax $.quantityreceived'
   ,Line INT 'lax $.line'
   ,CurrentUSDValue NUMERIC(18,2) 'lax $.custcolcurrentvalue'
   ,LandedCostPerUnit NUMERIC(18,2) 'lax $.custcollandedcostunit'
   ) AS B
   JOIN [SVR-DB-07].DW1.dbo.ProductDim PD ON pd.ProductName = b.sku
   WHERE J.RecordType = 'transferOrder'
   AND a.[key] != 'currentline'
   AND JSONVALUE(J.JSONData,'$.fields.location') = 16
   AND JSONVALUE(J.JSONData,'$.fields.transferlocation') = 15
   AND JSON_VALUE(J.JSONData,'$.fields.tranid') = 2816

   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… more

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

9. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

10. 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 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Delete…  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    This can be setup in the ‘Data Export → CSV’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).

11. hotkeys

    Please implement. Support of simple shortcuts for work with lines (that not implemented as well) like in notepad++ or Visual Studio or MSSMS. I mean such shortcuts and features as : Ctrl+D - duplicate line, Ctrl+L - remove line, Ctrl+J - join lines etc.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Delete…  ·  Admin →

12. 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 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Delete…  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    This can be performed by right-clicking the data grid and selecting ‘Copy Data As → CSV’ from the popup menu.

13. Support for Common Table Expressions (CTEs)

    Support for Common Table Expressions (CTEs)

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

14. 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

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Delete…  ·  Admin →

15. 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 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Delete…  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    It’s updated to version 20.

16. 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

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Questions  ·  Delete…  ·  Admin →

17. Ability to edit vertically selected text

    I am using dbForge Studio 2019 Express. I can select text vertically but I can not edit it. In other editors, when I edit text, all rows are updated.

    I suggest to copy this feature of Notepad ++ or SQL Server Management Studio.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Bugs  ·  Delete…  ·  Admin →

18. 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

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Delete…  ·  Admin →

19. 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

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

20. 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 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Delete…  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    This is governed by the ‘Field separator’ option in the ‘Data Export → CSV’ section of the ‘Options’ window
    https://snipboard.io/4OEiKT.jpg