Skip to content

dbForge Studio for SQL Server

dbForge Studio for SQL Server is an SQL server development tool incorporating query builder, data import/export and compare tools for managing and analyzing data.

To consider your idea as soon as possible, follow the guidelines:
  • Describe the goal you want to achieve and what result you want to get
  • If you have a solution, add it to the description
  • Give examples that we can use to implement your ideas
  • Add one suggestion per post. If you have several ideas, share them in separate posts
  • Add comments to the suggestion

dbForge Studio for SQL Server

Categories

JUMP TO ANOTHER FORUM

401 results found

  1. Please enable SQL Studio features to work on Microsoft Azure SQL Data Warehouse and Analytics Platform (APS). Both APS and Azure SQL Data Warehouse have similar parallel DW architecture (MPP). Azure SQL Data Warehouse is the cloud version of on-prem APS appliance. We want a tool that can work with APS / Azure SQL Data Warehouse. Right now dbForge SQL Studio can connect to APS, but nothing works beyond that.

    Azure SQL Data Warehouse: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is

    Microsoft Analytics Platform System (APS): https://www.microsoft.com/en-us/sql-server/analytics-platform-system

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Azure doesn't support linked servers. It has an external data source feature instead. SSMS allows creation of a template. It would be great if dbForge Studio supported the same but with a wizard that would allow connection of an excel spreadsheet OR another Azure database on the same Azure elastic server.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. I used to work with Apex SQL where there was test mode. This is a very simple, but convenient feature. There was a button "Test Mode" beside the "Execute Script" button. The button had two states - pressed and unpressed. Clicking the button added two rows. "BEGIN TRANSACTION" was added at the beginning of the script and "ROLLBACK TRANSACTION" was added at the end. When unpressing the button, the two rows disappeared.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. I have a standard folder on my laptop for source control files that gets backed up automatically. I've changed the default folder for source control in the settings but instead of using the repository name as the source folder, it's using a scrambled name.

    can you make the software use the repository name instead of the random name so I know which database I'm looking at when looking in my source control folder?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. I need refresh button when restore database and browse folder, sometimes I forgot to extract the BAK files into folder.
    In current release, I have to cancel the wizard, extract backup files, and start over the restore wizard.
    If there is a REFRESH button in browse folder it make easier to restore, I just click the button and choose the backup file without start over the wizard.

    thanks

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. It would be nice to be able to group connections to folders in Data Explorer.
    Ablility to create folder structures in Data Explorer and move connections to different folder.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. I am using dbForge Studio 2019 Express. I can select text vertically but I can not edit it. In other editors, when I edit text, all rows are updated.

    I suggest to copy this feature of Notepad ++ or SQL Server Management Studio.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. After running a data comparison, I want to edit the comparison and make some changes, then save the comparison... without having to re-run it first. This means being able to click "Save" while the "New Data Comparison" dialog is open before clicking "Compare".

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. I click "New Data Comparison" (or "New Schema Comparison"), then ALT-W to open the "Database Connection Properties" dialog, then TAB to get into the "Server" input box. Once there, I type a part of the name of the server and the list of available servers works nicely!

    It seems that I must use down DOWN ARROW to select the server from the list and press ENTER before I can get out.

    However, if I type the entire server name, I can't get out of that box! Pressing TAB or ENTER does nothing.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Please add in the Database explorer frame a simple quick object search / filter to so we can find quickly needed object. Thanks

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Enable option to fix tabs

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. From a SSMS Query window execute a statement like:
    CREATE TABLE #tempAllBin (ID Int);
    Then, in your query designed, browse to the TempDB and locate the new temp table. It will have a name like: "#tempAllBins________________________________________________________________________________________________________000000090BC2".
    Select this table name and drag it into the query designer window in your tool. - The length of the table name makes it impossible to view the column names in the column window, as well as a number of other complcations arising from the length of that table name. I see no way to assign a SHORTER ALIAS Name in your query designer…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. On Windows 10, when you tear off a query window and drop it on a secondary monitor, it will cover up the task bar on that monitor when the window is maximized. If you put it on the main monitor and the main app on the secondary, then both windows will maximize properly and not cover the task bar.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Add the ability to create Custom Right-Click Scripts to perform on a given table from the Database Explorer window. Either under Truncate Table. Or as part of Generate Script As...

    I frequently need Select count(*) from xxxxx as well as a few others. It'd be great if I could add my own!

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. On the database diagram, add ability to create virtual relationships between tables in different databases. This would help in documenting the implied relationships between databases.

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. In data pump, I need to be able to import memo field from a FoxPro database. Currently only dbase is supported

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. In SQL Server Managment Studio there is an view: Object explorer details. Where I can see details for all tables in my database. And for example I can sort tables by row count. Similar view in DbForge has fixed columns: Schema, Principal, Partitioned, Create Date, Modify Date, filegroup, Change tracking, Lock_Escalation. But there is no possibility to add extra columns especially: Data space used, index space used, row count.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Currently it appears column customization (sort order, filter, column width) is only preserved between executions for the first tab and only when it is the active tab then the queries are run. Would be nice if it was preserved for all tabs.

    In one query window:

    SELECT Data= 1 UNION SELECT 2 UNION SELECT 3;

    SELECT Data= 'A' UNION SELECT 'B' UNION SELECT 'C';

    Run the query and the results are put on to results at tabs. If you change sort orders for the second tab and re-run the sort order is lost. If you change the sort order of…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
1 2 5 7 9 20 21
  • Don't see your idea?