134 results found

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

2. 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 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  ·  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, this control was changed and new options were added.

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

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

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

6. Add synchronization option to exclude objects from synchronization by mask or template
   7 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 →
   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

7. Add option to ignore tables character set and/or COLLATION
   7 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  ·  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 is the ‘Ignore Collations’ option added.

8. syntax highlight variables

   Can we please have an option to select a color for variables?
   Having a selectable color for variables, allows us to more readily see where we are using variables in a large script, by making them stand out.

   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…)
   0 comments  ·  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 is now governed by the ‘Variable’ item in the ‘Environment → Font and Colors’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).

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. Add item in popup menu of Database Explorer to send objects to DB diagram
    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  ·  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. 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 →
    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

12. dbForge Studio Database Documention can´t create "Depends On" or "Used By"

    When dbforge Studio creates the Documention for a Database all "Depends On" and "Used By" refers are empty when the Database Name contains a "-".

    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  ·  Bugs  ·  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

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

14. Fix Find and Replace dialog annoyances

    The Find and Replace dialog has two annoyances :
    1. "Look in:" should indicate "Selection" whenever the dialog is open and there is text selected in the query window. Particularly important for replace actions !
    2. When switching to either the "Find what:" or "Replace with:" edit field, the content should be selected instead of placing the cursor at the end. This way, what the user types reaplces the content of the edit box.

    Thanks for voting :)

    5 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  ·  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 feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html

15. Ability to select between several color schemes for SQL document

    Implement at least two color schemes dark and bright so when changing to the dark scheme, a user is to be able to quickly change the text color as well.

    5 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  ·  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

    We would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
    http://www.devart.com/dbforge/sql/studio/download.html
    Thank you for your help in improving dbForge Studio for SQL Server.

16. Support SourceGear Vault

    Its website is at: http://sourcegear.com/

    5 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  ·  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. Sticky "Object has invalid source text and cannot be saved"

    Often, when editing functions, and I try to save something with invalid syntax, I will get a pop-up with "Object has invalid source text and cannot be saved" instead of the useful list of errors with line numbers. (However, the product still often red-underlines a problematic portion in these cases.)

    That annoyance is separately reported here:

    https://devart.uservoice.com/forums/177009-dbforge-studio-for-sql-server/suggestions/7488676--object-has-invalid-source-text-improve-error-i

    However, sometimes, after getting this once, every successive save will fail with that error, even after the problem has been resolved. Copying and pasting into SSMS will verify that it is correct. Then closing and re-opening the function editor window will allow me to paste it back in and save it. That is, the text which threw the "invalid source" error is valid and dbForge will allow me to save it once I re-open the window. It's like it gets stuck in a "this is bad SQL" state and won't re-evaluate until the window has been reopened. This is really annoying and is happening with increasing frequency.

    I'm on the Express Edition, version 5.2.177, which the product says is the latest version.

    Often, when editing functions, and I try to save something with invalid syntax, I will get a pop-up with "Object has invalid source text and cannot be saved" instead of the useful list of errors with line numbers. (However, the product still often red-underlines a problematic portion in these cases.)

    That annoyance is separately reported here:

    https://devart.uservoice.com/forums/177009-dbforge-studio-for-sql-server/suggestions/7488676--object-has-invalid-source-text-improve-error-i

    However, sometimes, after getting this once, every successive save will fail with that error, even after the problem has been resolved. Copying and pasting into SSMS will verify that it is correct. Then closing and re-opening the function editor window will allow me… 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…)
    3 comments  ·  Bugs  ·  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 issue is fixed in the latest version 5.4 https://www.devart.com/dbforge/sql/studio/download.html

18. Provide the ability to export data in MS Excel 2010 format.

    more than 65000 recordes can be experted in csv format files, but they cannot cope with ' or " is text fields.

    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  ·  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 feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html

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

20. Ability to change the location of the snippet folder.
    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  ·  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 feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html