48 results found

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

   It would be very nice if dbForge could have an option to jump to/from Begin/End statements. This allows us to clearly see where a structure begins/ends (in large scripts).
   Also faint lines connecting begin/end, ( and ), like DevExpress's CodeRush or Notepad++ would be very nice.
   Currently you have faint lines around select statements and so forth. That is very useful, but the suggestion above will enhance the usefulness of the current structural highlighting.

   2 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

5. Add ability to enter product key on trial versions

   Not a big deal, but it would be nice to be able to just enter a product key, instead of having to download a new version.

   2 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

6. Allow Backing up to UNC or Mapped network drive

   When creating a backup, I'd like the ability to store the .BAK file in a folder on another PC, either via a UNC file share (\servername\sharename\mybackup.bak) or a mapped drive (g:\backups\mybackup.bak). Right now dbForge Studio only lets you back up to the local hard drive of the server.

   2 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

   You can amend the existing path and specify a mapped network drive right in the ‘Backup to disk’ list on the ‘General’ page of the Backup wizard.

7. Open new tabs next to current one

   Opening up a new tab all the way at the end is so Internet Explorer (not in a good way). 99.999% of the time if I'm opening up a new tab it's intended to supplement my work in the tab I'm in, so visually it is most useful if it just starts up next to the current tab.

   2 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

8. Allow connection to SQL Server running on Ubuntu

   I was able to connect to SQL Server running on Ubuntu with SQL Server Management Studio. Be nice to do it with dbForge. Got the error message that the version of SQL Server wasn't supported when I tried.

   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 →
   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. Status-bar PER tab

   It is often quite hard to know that an update or insert statement, or DDL statement has actually happened. Data from a previous SELECT statement remains steadily there, and the only hint is to watch the right-hand corner and actually see this change from Ready to Executing to Ready - but if you miss that, even the Output window is not definitive. A status bar PER TAB - like Management Studio - including the last number of rows affected, the last execution duration IN THAT TAB, etc. would be immensely helpful.

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

10. View extended properties of objects easily

    Like MS_Description property for example on Table, Column, etc. Would be very useful on hover of object in browser or TSQL editor

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

    The full object information is available in the Standard and Professional editions of the product.

11. Redesign stored routine editor

    Suggestion to redesign the visual stored procedure editor of dbForge.

    Uh... there are a number of major misses here in 4.0.

    I login to a database, expand the Programmability section, then right-click a procedure and select 'Edit Procedure.' The script that is generated is a CREATE PROCEDURE method, which out of the box won't work because the procedure already exists.

    Okay, so I change it to ALTER PROCEDURE and press F5 to rebuild the procedure. I get a dialog box prompting me for parameters! Oh, I guess F5 means RUN the procedure? No, that's not what I want. It looks to me like there's some other command for 'run script' ... but I look and look and can't find it. I can't find a 'Run' button at all, or an 'Execute' button.

    Oh, wait, the SQL Toolbar is hidden by default. I show that, click the 'Execute' button - and get the dialog again!

    Why can't I just execute the script? Why is it forcing me to execute the procedure? Maddening.

    Worse -- I try to save my script and the program says 'Object has invalid source text and cannot be saved.' WHAT??? What if I am working on something and want to save it, even if it won't compile at the moment?

    I don't mean to sound snarky, but these problems make the program unusable, sorry! Back to SSMS for me.

    Suggestion to redesign the visual stored procedure editor of dbForge.

    Uh... there are a number of major misses here in 4.0.

    I login to a database, expand the Programmability section, then right-click a procedure and select 'Edit Procedure.' The script that is generated is a CREATE PROCEDURE method, which out of the box won't work because the procedure already exists.

    Okay, so I change it to ALTER PROCEDURE and press F5 to rebuild the procedure. I get a dialog box prompting me for parameters! Oh, I guess F5 means RUN the procedure? No, that's not what I want. It looks… 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…)
    completed  ·  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

12. Most recent executed queries

    Adding a list of most recent executed queries

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

    The Query Execution History feature is present in version 6.0.

13. Return automatic updates of studio

    Please return automatic background updates. I donn't want to enter the site, search «download» button and install updates manually. Old versions has 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…)
    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
    completed  ·  AdminDevart (_, Devart) responded

    This is present in version 6.0.

14. Licensing

    Every time I update db Forge I end up in the situation where it asks me for my license. This is so annoying because I then end up in this loop where I have to find my license details, enter them in, get an error message because it is not happy with it, then contact you guys to get a new license. Why can't you just remember the license and not ask me for it again until it expires. I have a team of developers who ran the update this morning and are now unable to do any work until we find the license.

    Every time I update db Forge I end up in the situation where it asks me for my license. This is so annoying because I then end up in this loop where I have to find my license details, enter them in, get an error message because it is not happy with it, then contact you guys to get a new license. Why can't you just remember the license and not ask me for it again until it expires. I have a team of developers who ran the update this morning and are now unable to do any work until… 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
    completed  ·  AdminDevart (_, Devart) responded

    We have just released a new build 5.4.211 where we fixed some issue with license activation https://www.devart.com/dbforge/sql/studio/download.html

    Once you install it, you have to activate your copy of dbForge Studio for SQL Server as described at https://www.devart.com/dbforge/sql/studio/docs/index.html?activation.htm

15. Add ability to sort/filter fields in data comparison results grid
    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  ·  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. Display records quantity and add ability to skip current table during export

    When selecting a data source, it would be nice to see the quantity of the records in the table.

    Also, when performing export, add the ability to skip the current table.

    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 →
    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. Spread connection categories marking to single objects

    Extend the connection categories marking feature so the objects (tables, views, procedures, etc) belonging to the connection also have the same marking as the corresponding connection.

    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 →
    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. Refresh option in Data Import wizard

    When I use the import wizard it would be handy to have a refresh option. If I'm partway through the wizard and decide I'd like to create a table manually, I can't then specify that table to import to without closing the wizard, force a refresh and start all over again

    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 →
    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. Bring back the single-DB Connection

    The Single DB feature was removed in V5, and I would like to see it brought back

    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 →
    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. In Database Explorerer it should be possible to see the data type and NULL/NOT NULL settings of fields like in SSMS

    In Database Explorer it should be possible to see the data type and NULL/NOT NULL settings of fields like in SSMS.

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