48 results found

1. 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 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…)
   3 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminDevart (_, Devart) responded

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

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

   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  ·  5 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Add database documentation tool

   It would be perfect to add database documentation feature.
   Generate documentation as CHM or/and as documentation project which could be used by third party tools like Help&Manual.

   38 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…)
   5 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminDevart (_, Devart) responded

   You can download the new product dbForge Documenter for SQL Server at https://www.devart.com/dbforge/sql/documenter/download.html

4. 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 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…)
   3 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminDevart (_, Devart) responded

   It’s fully supported in version 6.0.

5. 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 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 →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminDevart (_, Devart) responded

   There are all databases displayed in the tree of version 6.0.

6. Show Column Description

   Add ability show|hide Field description in the Table entity additionally to the Field Name and Type

   9 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…)
   3 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminDevart (_, Devart) responded

   This can be setup as follows:

   1. Right-click in the diagram and select ‘Options…’ from the popup menu. The ‘Options’ window opens.
   2. Switch to the ‘Notation’ tab.
   3. Select the appropriate option from the ‘Field Details Level:’ drop-down menu.
   4. Click ‘OK’.

7. Export Data to JSON

   Please add support for new FOR JSON

   8 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 →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. DataCompare: Add option to turn ON\OFF Generation of "IF NOT EXISTS" on inserting

   I have to script data so it won't produce an error when running the sql statement.. 80% of the time I have to manually update the data synch scripts like this:
   IF NOT EXISTS (SELECT * FROM dbo.DescriptionReference WHERE DescriptionId = '0243b2d2-58b2-4aaf-8cfd-0011f036f0e3')
   INSERT dbo.DescriptionReference(DescriptionId, CultureCode, IsDefault, Description, LongDescription, SourceTable, IsActive, Created, CreatedBy, Updated, UpdatedBy)
   VALUES ('0243b2d2-58b2-4aaf-8cfd-0011f036f0e3', N'en-US', 1, N'2300 REF F8 - P', NULL, N'FormatRuleValue', 0, '2015-06-01', 'TESTA', '2015-06-01', 'TEST')
   If I don't and the data exists it throws an error and stops our DB Upgrade process..
   IT WOULD BE GREAT if you could have an option to turn on and off to generate the IF EXISTS line...

   I have to script data so it won't produce an error when running the sql statement.. 80% of the time I have to manually update the data synch scripts like this:
   IF NOT EXISTS (SELECT * FROM dbo.DescriptionReference WHERE DescriptionId = '0243b2d2-58b2-4aaf-8cfd-0011f036f0e3')
   INSERT dbo.DescriptionReference(DescriptionId, CultureCode, IsDefault, Description, LongDescription, SourceTable, IsActive, Created, CreatedBy, Updated, UpdatedBy)
   VALUES ('0243b2d2-58b2-4aaf-8cfd-0011f036f0e3', N'en-US', 1, N'2300 REF F8 - P', NULL, N'FormatRuleValue', 0, '2015-06-01', 'TESTA', '2015-06-01', 'TEST')
   If I don't and the data exists it throws an error and stops our DB Upgrade process..
   IT WOULD BE GREAT if you could have an option to turn on… more

   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  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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

   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 →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    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).

12. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    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

13. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminDevart (_, Devart) responded

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

14. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    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

15. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminDevart (_, Devart) responded

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

19. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close