74 results found

1. Generate CRUD Matrix from a SQL Server database.

   Generate a matrix showing tables vs. procs/functions that Create, Read, Update or Delete data in that table.

   Perhaps this could be achieved by expanding the detail available in the "Used By" section of each table.

   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…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   completed  ·  AdminDevart (_, Devart) responded

   In version 6.0, the new command ‘Generate Script As → CRUD’ is available in the popup menu of a table in Database Explorer.

   This feature can be setup in the ‘Generate Scripts → CRUD’ section of the ‘Options window’ (select ‘Tools → Options…’ from the popup menu).

2. Comment / Un-comment a block of Code.

   Frequently I have the need to comment or un-comment a section of my SQL code, e.g. a set of columns or a portion of a WHERE clause. It would be nice if I could select the block, right-mouse, and select comment/un-comment to place the "--" characters in front of the selected lines of code.

   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  ·  1 comment  ·  Features  ·  Delete…  ·  Admin →

3. Show object (tables,views,etc) by schema in explorer

   View object by schema. This would make the explorer more clear and easier to find objects if you've lots of tables and views split by schema

   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  ·  1 comment  ·  Features  ·  Delete…  ·  Admin →

4. 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 →

5. Add table triggers as an option to the Generate Scripts database scripting function

   The Generate Scripts function under Tasks is missing the option to include database triggers in the list of available objects to include in the output. Triggers are a fundamental component for replicating database schemas and should be included in the scripted output.

   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…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   completed  ·  AdminDevart (_, Devart) responded

   Triggers are turned on by selecting the option ‘Script DML Triggers’ on the ‘Options’ page of the Generate Scripts Wizard https://snipboard.io/GJTyaf.jpg

6. Schema Compare /Sync log

   Currently on the command line, the /sync option allows you to specify a file to write the sync script to, instead of executing immediately. When no file is specified, the sync is executed immediately. I would like a way to send the results of the sync operation to a log file of type .txt.

   I think it would be beneficial to have a couple of different logging levels:

   0 - verbose; each object start and stop time, warnings, and errors
   1 - warnings; only objects causing warnings or errors to occur
   2 - only errors

   Warnings should include the object name and the SQL warning
   Errors should include the object name and the SQL error

   This log would allow me to automate database refreshes, allowing the sync to continue on error, and give me something to look at when it is completed. All of this would be for troubleshooting purposes when something goes wrong or to validate a successful sync

   Example call

   .\schemacompare.exe /schemacompare /compfile:"C:\MyComparison.scomp" /sync /synclog "c:\synclog.txt" 2

   Expecation

   A schema compare is performed based on connections and options in C:\MyComparison.scomp with subsequent sync operation based on the compare. The sync operation would be logged to c:\synclog.txt, containing only error information.

   Currently on the command line, the /sync option allows you to specify a file to write the sync script to, instead of executing immediately. When no file is specified, the sync is executed immediately. I would like a way to send the results of the sync operation to a log file of type .txt.

   I think it would be beneficial to have a couple of different logging levels:

   0 - verbose; each object start and stop time, warnings, and errors
   1 - warnings; only objects causing warnings or errors to occur
   2 - only errors

   Warnings should include the object… 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  ·  1 comment  ·  Features  ·  Delete…  ·  Admin →

7. Transaction log reader

   A tool to read transaction logs similar to http://www.apexsql.com/sql_tools_log.aspx

   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

   Please review the following tool https://www.devart.com/dbforge/sql/transaction-log/

8. Control-N in an SQL window

   When I press control-N in an SQL window, why does the new window not inherit the server and database of the current window?

   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  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

9. Please add the new sql server 2022 features

   SQL query window does not accept adding the 'WINDOW xxx AS' clause to a query with a window function.

   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 →

10. Card View Scroll

    Can you add the features in the Card View of the record to scroll the value with the scroll's button mouse?
    When I have many columns its long to press all the time the arrow

    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 →

11. Intellisense for tables in tempdb

    When joining, querying, or trying to expand table.* column names for a table in the tempdb database, Intellisense does not work even for tables that existed when starting dbForge.

    It would be nice to be able to have that feature even if it meant manually adding the table to the Intellisense cache.

    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 →

12. Make schema comparison in vertical windows rather than in horizontal ones

    Currently, the screen is divided onto two horizontal parts where the top window contains objects and the bottom one has their text representation which is not quite convenient because there is a lot of spare place left not used.

    Visually, it would be much more convenient to have the ability to place the windows vertically rather than horizontally unlike the current implementation.

    For example, like in AdeptSQL Diff.

    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…)
    1 comment  ·  Features  ·  Delete…  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    The feature is implemented in of dbForge Studio for SQL Server, v4.5.

13. Ability to set edition for trial mode.

    During the 30 day trial, the application runs in enterprise mode. It would be ideal to have the option to change the edition that it runs as so that we can easily see what features we gain/lose with each edition. For example: My company is looking at standard edition. I have to keep going to the website to see if the feature I am currently playing with comes with that edition. It is making my evaluation much more difficult.

    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  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

14. Script generating with table rename and reinsert data

    Here is some table need to recreate and refill data after if. Recreation reason- identity increment has been changed.

    This script was generated:

    IF OBJECTID(N'dbo.EDDevicesSHADOW', 'U') IS NOT NULL
    AND OBJECTID(N'dbo.tmpdevartEDDevicesSHADOW', 'U') IS NULL
    EXEC sprename N'dbo.EDDevicesSHADOW', N'tmpdevartEDDevices_SHADOW', 'OBJECT'
    GO

    IF NOT EXISTS (
    SELECT 1 FROM sys.indexes
    WHERE name = N'PKEDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
    AND EXISTS (
    SELECT 1 FROM sys.indexes
    WHERE name = N'PKEDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
    EXEC sprename N'dbo.PKEDDevicesSHADOW', N'tmpdevartPKEDDevices_SHADOW', 'OBJECT'
    GO

    IF NOT EXISTS (SELECT 1 FROM sys.columns WHERE name = N'SRowGUID' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW', 'U') AND defaultobjectid <> 0)
    AND EXISTS (SELECT 1 FROM sys.columns WHERE name = N'SRowGUID' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW', 'U') AND defaultobjectid <> 0)
    EXEC sprename N'dbo.DFEDDevicesSHADOWSRowGUID', N'tmpdevartDFEDDevicesSHADOWS_RowGUID', 'OBJECT'
    GO

    IF OBJECTID(N'dbo.EDDevicesSHADOW', 'U') IS NULL
    CREATE TABLE dbo.EDDevices_SHADOW (....
    ...

    As we can see some statements logic never fire. And we have incorrect database updating script.

    Here is some table need to recreate and refill data after if. Recreation reason- identity increment has been changed.

    This script was generated:

    IF OBJECTID(N'dbo.EDDevicesSHADOW', 'U') IS NOT NULL
    AND OBJECTID(N'dbo.tmpdevartEDDevicesSHADOW', 'U') IS NULL
    EXEC sprename N'dbo.EDDevicesSHADOW', N'tmpdevartEDDevices_SHADOW', 'OBJECT'
    GO

    IF NOT EXISTS (
    SELECT 1 FROM sys.indexes
    WHERE name = N'PKEDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
    AND EXISTS (
    SELECT 1 FROM sys.indexes
    WHERE name = N'PKEDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
    EXEC… 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 →

15. Source support for the online (www.visualstudio.com) version of TFS.

    The visualstudio.com online version of TFS will not authenticate with Source Control. I have tried alternate credentials and using the tool from http://nakedalm.com/tools/vso-service-credential-viewer/.

    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  ·  4 comments  ·  Features  ·  Delete…  ·  Admin →

16. See query that filter automatically is generating

    When I filter the results grid in DBForge Studio for SQL Server, it's great to quickly get the results i need! However, there are times I'd like to see the SQL of the filter (i.e. what it is putting in the WHERE clause) so I can use it in my own SQL query. Currently I do not see a way to view or export that. This would be a nice feature to have!

    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 →

17. 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 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 ‘Text Editor → Text Compare Control’ of the ‘Options’ window (select ‘Tools → Options…’ from the main menu) https://snipboard.io/07VTfb.jpg

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

19. Hierarchical data viewer

    Is it possible to add hierarchical data viewer? I mean, viewer where you can set parent and child field and it build a tree based on query.

    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 →

20. Configurable Layout

    It is typical to write or extend a sql stmt on the top of a query window and to see the result in the bottom.
    dbForge has not that standard behaviour for this window. My Suggestion is to configure or save the last the window layout as it will be needed.
    I know there are two buttons in the bottom to click on to change this layout but when you work the whole day with this tool and you have click 200 times a day these both buttons it's getting bothersome and not a good user experience.

    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 →