381 results found

1. Existence logic needed for triggers

   When a new trigger is created, the script tests for existence first. So if the trigger does not exist, it will not create it. It should not test for existence as it will never create the trigger. It's unnecessary to check the object's existence if the product is using CREATE OR ALTER trigger.

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

2. Auto re-draw causing loss of user specified relationship lines on diagraming tool

   Fix issue with diagram tool auto redrawing relationship lines when tables are dropped and recreated with no changes to relationships from old to new tables.

   Specifically I reverse engineered my tables into the database diagraming tool. Then painstakingly organized the tables then adjusted all the relationship lines so they take a short path and do not cross then saved the diagram.

   When re-opening it everything is fine. But - if I ever drop and recreate the tables (e.g. with a script to change the schema) the diagram tool auto-redraws all the relationships and the diagram becomes a mess.

   Please fix. This is a show-stopper for me using the diagraming tool.

   Fix issue with diagram tool auto redrawing relationship lines when tables are dropped and recreated with no changes to relationships from old to new tables.

   Specifically I reverse engineered my tables into the database diagraming tool. Then painstakingly organized the tables then adjusted all the relationship lines so they take a short path and do not cross then saved the diagram.

   When re-opening it everything is fine. But - if I ever drop and recreate the tables (e.g. with a script to change the schema) the diagram tool auto-redraws all the relationships and the diagram becomes a mess.

   Please fix.… more

   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…)
   1 comment  ·  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

3. formating Value and Numbers in result of Query Like show numbers separated by separators

   There is an option to change the way Date and Date-Time shown is the result of Query if you add other thing like show numbers separated by separators etc.

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

4. Clear google sheet before exporting

   Would be great if before exporting data into from SQL Server to google sheets the sheet is cleared, that way if in a second export less rows are exported there are no risk in export duplicates records.

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

5. Executing a query across multiple servers

   The only thing that prevents me from using DBForge is the inability to run a single sql query on 10 different SERVERS simultaneously and see the aggregated resultset. In SSMS you can simply create a folder and put all of your server connections into that folder and then when you right click on the folder it allows you to connect to all X servers in that folder simultaneously. If you run a top10 query and you have 10 servers configured in that folder you get back a single 100 record resultset. Without a feature like this I can't leave SSMS because we have our system sharded across multiple servers. Thank you!

   The only thing that prevents me from using DBForge is the inability to run a single sql query on 10 different SERVERS simultaneously and see the aggregated resultset. In SSMS you can simply create a folder and put all of your server connections into that folder and then when you right click on the folder it allows you to connect to all X servers in that folder simultaneously. If you run a top10 query and you have 10 servers configured in that folder you get back a single 100 record resultset. Without a feature like this I can't leave SSMS… more

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

6. Data Pump pass through imported file name

   When it comes to bulk Data Pump imports from multiple files (e.g. Excel, *.csv), I'd really appreciate the ability to pass through the source import file name (as text) to a dedicated column within the destination SQL Server data table against each imported record.

   Personally, I use the DevOps PowerShell Automation import pathway and would find it a really handy addition for basic audits if it was accessible as a parameter on Invoke-DevartDataImport

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

7. Orderly Fashion Data Pump (From parent to children + referential integrity)

   I am trying to do a data pump but once it is finished the data is almost useless because I don't need 1,000 records per-table, but as many as meaningful are, the children records derived from smaller amounts of records in its corresponding Mater or Parent tables

   So If have for instance ... let's say Businesses (1) and Stores (2) so I'd like to pump data just for these entities not 1,000 business and 1,000 stores but 1,000 billing records, 10,000 stock count records, 8,000 items catalog for each store ... derived from previous node ... like a tree structure of data-pumps (data-pump01, data-pump02, data-pump03, ... , data-pump99 ... and so on

   It would be good if we could go increasingly seeding data to the master tables and later going on adding non-initially-added-tables so the newest data-pump will pump data into the newly selected tables using the values alredy stored in the database via the initial data-pump and in that way using the data stored in those previous records to create the children-ones

   Just an idea !!!

   P.S.: FOREIGN LANGUAGE DICTIONARIES WILL BE GREAT TOO (Caps just for distinguishing the 2 different ideas written here)

   I am trying to do a data pump but once it is finished the data is almost useless because I don't need 1,000 records per-table, but as many as meaningful are, the children records derived from smaller amounts of records in its corresponding Mater or Parent tables

   So If have for instance ... let's say Businesses (1) and Stores (2) so I'd like to pump data just for these entities not 1,000 business and 1,000 stores but 1,000 billing records, 10,000 stock count records, 8,000 items catalog for each store ... derived from previous node ... like a tree structure… more

   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…)
   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. As a developer, I'd like to be able to check in custom data generator configurations...

   As a developer, I'd like to be able to check in custom data generator configurations with the rest of my project's configuration into source control.

   Currently, the xml configuration files are stored in a separate far-off location /Users/Public/... and this makes it not ideal if you want to version your generator configurations to share with the rest of the team through Git, as an example.

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

9. I'd like to be able to edit or delete user defined (custom) data generation configurations directly from the GUI

   I'd like to be able to delete user defined (custom) data generation configurations directly from the GUI.

   Currently, you can create (but not delete, nor edit) user defined custom data generator configurations easily.

   Often it is necessary to delete these custom configs because you've created new ones...or saved it too many times...or for other reasons. However, there's no option to delete from the GUI. In order to delete them, you have to find their location and delete xml files found under C:\Users\Public\Public Documents\Devart\dbForge...\Data Generators... there you're presented with only timestamped files with no naming that indicates which user defined generation this is.... because of this you have to open each one in a text editor (there may be, as in my case, more than a couple dozen) to see if that file is the right one you want to delete. This is tedious and error prone. Here is an example of the list of files you need to sort through to determine what you want to delete:

   "C:\Users\Public\Documents\Devart\dbForge Studio for SQL Server\Data Generators\UserDefined_2024-02-27-205254863.xml"

   I'd like to be able to delete user defined (custom) data generation configurations directly from the GUI.

   Currently, you can create (but not delete, nor edit) user defined custom data generator configurations easily.

   Often it is necessary to delete these custom configs because you've created new ones...or saved it too many times...or for other reasons. However, there's no option to delete from the GUI. In order to delete them, you have to find their location and delete xml files found under C:\Users\Public\Public Documents\Devart\dbForge...\Data Generators... there you're presented with only timestamped files with no naming that indicates which user defined generation… more

   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…)
   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. When you have an existing data compare and you change the target, it doesn't work

    Take two identical databases on different SQL Server instances (or on prem vs Azure). Ensure they are identical by doing a schema compare. Take a data generation file that is configured and works for one database. Take that file and change the target to the new database. The pre-existing configuration does not get applied to the new database.

    The workaround is to create a copy of the existing data generation file, open the new configuration .dgen file in a text editor and change the ConnectionString line in the xml to match the new database's properties. In order to get the new databases connection properties, you have to create a brand new database generation file for the new database and take it from that.

    ...Kris

    Take two identical databases on different SQL Server instances (or on prem vs Azure). Ensure they are identical by doing a schema compare. Take a data generation file that is configured and works for one database. Take that file and change the target to the new database. The pre-existing configuration does not get applied to the new database.

    The workaround is to create a copy of the existing data generation file, open the new configuration .dgen file in a text editor and change the ConnectionString line in the xml to match the new database's properties. In order to get the… more

    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…)
    1 comment  ·  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

11. Is it possible to change the default location of .dgen files?

    The default location for custom data generation configs is:

    C:\Users\Public\Documents\Devart\dbForge Studio for SQL Server\Data Generators

    This is different than the location for the other project-related files and this makes it tough to check in and share, etc.

    Is it possible to change this default location?

    I have a feature request in about this, but maybe there's a hack or even something I'm missing to set this location?

    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…)
    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. Autocomplete Improvement Suggestion

    Dear Devart Team,

    I suggest enhancing your autocomplete feature by making the first option selectable with the tab key. This would reduce the current two-step process (typing additional letters or using the mouse) to a single action, improving efficiency and user experience.

    Thank you for considering this improvement.

    Best regards,

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

13. Default column for datetime added getdate() as default.

    It will not save that column. I get an error about the )

    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…)
    under review  ·  2 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

14. More options for sorting in List Members

    In previous versions, custom snippets were in the first positions. This is not the case in the current version.

    It would be nice to be able to choose in the settings what to sort the results by and the possibility to prioritize custom snippets to the first positions

    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…)
    under review  ·  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

15. remote changes source control

    For source control (GIT) at the remote changes tab add a ignore/delete option.

    I started working with the database and deleted/renamed some stored procedures. When I detached and attached my source control (GIT) it wants to add the procedures which I have removed.
    This is fine when someone else changed it, but now I specifically want to delete this procedures. When working with this I can add them again, to delete them afterwards, or I can delete them in the folder and check them in with GIT, bypassing dbForge.

    The easy solution would be to add a ignore/delete/keep local option which would ignore the 'Remote changes' and save my database version to GIT.

    For source control (GIT) at the remote changes tab add a ignore/delete option.

    I started working with the database and deleted/renamed some stored procedures. When I detached and attached my source control (GIT) it wants to add the procedures which I have removed.
    This is fine when someone else changed it, but now I specifically want to delete this procedures. When working with this I can add them again, to delete them afterwards, or I can delete them in the folder and check them in with GIT, bypassing dbForge.

    The easy solution would be to add a ignore/delete/keep local option… more

    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…)
    planned  ·  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

16. Detach stored SQL query from SQL connection

    At present, if I developed a SQL query, stored it and try to load it back into dbForge at a later date, dbForge 'remembers' the SQL connection it is associated with and tries to connect automatically. I want to be able to disable this behaviour via options - eg opening file does NOT try to be clever.

    EXTENDED RATIONALE

    In common usage, the feature is quite useful. Unfortunately, in some of the projects I am working with, I have to constantly switch between different environments (prod, pre-prod, demo, devops, etc) protected by external VPN. All environments are hosting the same databases, but, due to security, I could only be connected to one environment (and hence one particular database) at a time.

    It is common for me to use the same stored SQL (after all, all environments contains essentially the same schema). But right now, if I open SQL script which was previously executed in a different environment, dbForge freezes while it tries to connect (which it cannot), which is annoying and time wasting.

    To be clear - I do NOT want to get rid of existing functionality - it remains highly useful in some projects. But I want to be able to control it via Options or Settings, to be able to switch it on and off, as needed.

    At present, if I developed a SQL query, stored it and try to load it back into dbForge at a later date, dbForge 'remembers' the SQL connection it is associated with and tries to connect automatically. I want to be able to disable this behaviour via options - eg opening file does NOT try to be clever.

    EXTENDED RATIONALE

    In common usage, the feature is quite useful. Unfortunately, in some of the projects I am working with, I have to constantly switch between different environments (prod, pre-prod, demo, devops, etc) protected by external VPN. All environments are hosting the same… more

    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…)
    planned  ·  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. Set Compatibility Level to SQL 2022 (160) on Edit Database Page

    Right click on a database on a SQL Server 2022 Enterprise Edition Instance and select Edit Database. Switch to the Options tab. Select the Compatibility level dropdown, I am only seeing up to SQL Server 2019 (150) as options, I am missing the SQL Server 2022 (160) option and need to manually write the ALTER DATABASE statement to set it.

    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…)
    planned  ·  1 comment  ·  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

18. Integration with Windows Task Scheduler
    0 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  ·  Edit…  ·  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

19. Ability to perform Load Test for query after being modified in Profiler
    0 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  ·  Edit…  ·  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. Create a named default constraint when add column
    0 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  ·  Edit…  ·  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