70 results found

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

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

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

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

5. Create Guid

   Add a new menu item "Set Value To" -> "New Guid" in context menu when clicking on a cell (if the cell is type of uniqueidentifier).

   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 →

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

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

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

11. Option to align the text in the table comparison panel

    It would be nice if there is an option to visually align the text on both sides in the table comparison panel.

    This would mean to align all exact lines on both sides and when the are lines which exist only on the left or the right to put an empty line on the other side.

    It makes the visual comparison easier and similar to how the Diff/Compare function works in Visual Studio.

    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 →

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

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

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

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

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

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

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