156 results found

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

17. Return back Ctrl+Shift

    That combination is used to switch between Windows languages. In the latest update dbForge awaits pressing some additional key upon Ctrl+Shift. Because of this, the first letter is not printed after pressing Ctrl+Shift.

    Let combinations with Ctrl+Shift to work only when these keys are hold down.

    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 →

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

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

20. Use SpaceBar to auto complete words and names

    when auto complete drop-down appear, we need to use space-bar to complete the word like as visual studio or ssms.

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

    This can be setup as follows https://snipboard.io/uqb2m9.jpg
    1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Text Editor → Code Completion → List Members’ branch.
    3. Select the ‘Whitespace’ option in the ‘Commit Selection’ section.
    4. Click ‘OK’.