dbForge Studio for SQL Server Erfahrungen

Great productivity tool

Kommentare: Productivity increases - for example in the past we needed to use a combination of SSMS, Excel and some query tuning utility programs - now dbForge Studio for SQL Server can replace and do them much better without needing to shift around dataTesting and debugging - ability to simply create tSQL scripts from output window or copy data from one server to another is fantastic for testing and debugging and saves a ton of time

Vorteile:

The worst part about SQL Server Management Studio is how it can just lose all Intellisense in the middle of a high-pressure situation. I have never had such a problem with dbForge. Additionally, the Intellisense is far superior and the ability to save (and share) customizable tSLQ templates saved so much time! Being able to see the history of query performance as you adjust it is also really good.

Nachteile:

No integration with SQL Sever Agent is the only downside, so one has to keep SQL Server Management Studio around for that - otherwise I would switch over whole heartedly.

After two years of usage

Vorteile:

DBForge SQL Server Studio stands out as a comprehensive and versatile tool tailored for database management, development, and administration, making it a valuable asset for SQL Server professionals. One of the most impressive aspects of DBForge Studio is its wide array of features designed to streamline and enhance the workflow of database developers and administrators.

Nachteile:

Learning curve: dbForge Studio for SQL Server is a powerful and comprehensive tool, offering a wide range of features. However, this richness can also translate into a steeper learning curve for new users or those without prior experience with similar tools. Beginners may find it confusing to navigate through the many features and options available.

Buggy, but with potential

Kommentare: I still kinda like it, but I'm having so much issues that I'm probably going back to SSMS in the near future. Unfortunately I got the 3 year subscription, so that's making me still use it. You know - you bought it, so use it!

Vorteile:

The promise of code completion and formatting with more affordable pricing compared to competition drew me to this software. I also liked the idea of a standalone product instead of using SSMS + plugins. Importing and exporting data has been such an easy task after bare SSMS.

Nachteile:

Even after testing the software for a while, I keep bumping into bugs. In the beginning I was reporting them, but it feels like its not worth it. According to support some issues are because I'm using Azure SQL Database and other issues were just acknowledged as bugs but nothing has been fixed and it's been 4-5 months.

Excellent work tool

Kommentare: I increased my productivity with greater development satisfaction

Vorteile:

Ease of use, convenient utility functions, such as data export, import, in many formats

Nachteile:

Before I used SQL Server Management Studio and I can't find things worse

Great help with SQL server management

Kommentare: We had a customer with a lot of stores where the items didn't match up.
With comparing tables between databases we found the issues and cound correct it fast.

Vorteile:

Compare and sync tables between databases is a lifesaver to find errors.

Nachteile:

I think it works great for what I have used it for.

Excellent MSSql IDE

Kommentare: I've relied on DBForge Studio to do my job.

Vorteile:

Ease of navigation, performance tuning tools, data discover/navigation tools, and data development utilities. This is a premium alternative to MS Sql Server Mgmt Studio.

Nachteile:

The database connection UI, wizards and db drivers UI is a little clunky. Could use better source control and 3rd party database migration utility integrations ( even if these are competitors to your IP, you can't control what others use and should instead be flexible and supportive) - liquibase, GOMigrate, etc.

Good choice for you to manage your SQL Server

Vorteile:

Easy to use and UI interface is clear. The function provided to manipulate SQL Server are fully provided in the Studio. You can select an edition to fit your need with difference price.

Nachteile:

It's kind of not so cheap software tool for an employee.

Great tool for managing, analysing, and querying SQL database

Kommentare: It's a great tool for maintaining multiple connections, and many multiple queries / files open at once. I use this tool daily for everyday queries, and I use it's schema and data compare functionality to mirror and sync changes between different databases. These tools have a lot of customisability which is fantastic. The software is rock solid, and the ability for the software to keep un-saved documents in case of a reboot or scratch pad situation is fantastic. No more getting spammed to name or save files when closing SQL Management Studio

Vorteile:

The autocomplete and various time saving features are a must have in the modern tech landscape.

Nachteile:

The separate pricing for different flavours of SQL (MySql, SQL Server, etc.)

great alternative to SSMS

Kommentare: it met our expectations, we are satisfied with the program

Vorteile:

debugging SQL procedures and functions - main reason better performance than SSMS familiar but better control than SSMS

Nachteile:

license price few improvements in the program lately

Excelent

Kommentare: Excelent software database administrator excelent

Vorteile:

Excelent software database administrator excelent

Nachteile:

Excelent software database administrator excelent

More intuitive than SQL Server Management Studio (SSMS)

Kommentare: I am not critical of SSMS because it's a great free tool but dbForge Studio for SQL Server is so much more convenient and efficient. It is a paid tool that is worth the money because it has saved me so much time and stress. The customer support is great, also.

Vorteile:

For me, it's the ease of use that makes this a joy to use. I am not a SQL Server specialist (I only use SQL Server Express) but I write a lot of TSQL. The features I love are (a) Debug of Stored Procedure (this feature seems to be removed in later versions of SSMS (b) Database Sync: you can first compare either Schema or Data between two versions of the same database. Then you can update the target (e.g. production) database from the source (e.g. dev) (after selecting the differences you want to update). Previously I used Visual Studio for this but it stopped working and many users have reported the same. The dbForge Data Sync has a 100% success rate for me. It just works. (c) Duplicate Object: 2 clicks to copy a View or Stored Proc. Handy when you want to backup an object before updating it. (d) Find Database Object: easy to search for existing tables, views, procs etc. (e) Find data (f) Format document(g) Manage Index Fragmentation.

Nachteile:

I can't really think of any. I can't speak to all the features because I don't consider myself to be a SQL Server expert.

A great replacement for SSMS

Vorteile:

The tabbed interface and ability to create tabs from several different SQL queries at the same time is a real time saver for me. I often do data comparisons and having several tabs each with a different view of the data makes my job much easier. Autocomplete and autojoin when creating queries also saves keystrokes. About the only thing I use SSMS for now is tracing, but you can also do that in some of the more expensive versions of dbForge Studio (I'm running the Standard edition).

Nachteile:

I can't really find anything not to like. I've not used all the features, but the ones I've used have all done exactly what I expect them to do.

Excellent Database Tool

Vorteile:

Features and Cost as compared to SQL Toolbelt.

Nachteile:

Very few negatives about this product. The suite is very helpful.

The "tool" for SQL Server

Kommentare: A nice smooth tool, a smart one, my go to tool when targeting SQL Server.

Vorteile:

Is how SQL Server Management Studio should be, fast, good UX, lot of features.

Nachteile:

The price is the issues, even though fair priced, the alternative is free.

dbForge Studio for SQl just makes my life easier!

Kommentare: This has made coding and creating large projects for data conversion from one billing system to another so much easier as well as moving massive amounts of meter data from system to another, and i am so glad i bought it.

Vorteile:

One phrase: One Stop Shopping! it is easy to find what i need in the feature rich studio, from searching for fields across giant database, to looking at formatted code, to creating data dictionaries and reports.

Nachteile:

I wish it had more integrations into SQL

dbForge Studio for SQL Server allows me perform many cyclical and daily tasks very quickly

Kommentare: For specific situations, I particularly like the interface linked to queries which allows me to easily consult or modify the data by facilitating the mapping between the different relationships of the tables.

Vorteile:

I have been using dbForge Studio Entreprise since 2013 to manage, develop, administer and maintain my MS SQL databases linked to my .net business applications. Given my workflow, I often have updates of my products, tests and other tasks on my development and production databases. dbForge allows me by simple script to perform these cyclical and daily tasks very quickly in addition to providing me with several tools to achieve this that can be found in the particularities of the product.

Nachteile:

I have nothing special about it because this product fully meets my needs.

dbForge the number 1 product to turn to for DB management

Kommentare: I had been using a competing product for some time and when ran into issues, I did a search for another solution and found dbForge and haven't regetted the decision.

Vorteile:

Creating, editing, and searching DB components.

Nachteile:

Changing DB objects that have foreign key constraints could made more convenient.

The swiss-army chainsaw of SQL Server development tools

Kommentare: I first purchased dbForge Studio for SQL Server for its database schema compare and synchronization features, and it does a wonderful job. I really like the SQL completion (e.g. predicting the JOINs that I'd want to do), so going back to SSMS to do something really sucks now.

Vorteile:

It's pretty comprehensive. I use it for all of my entire SQL Server and Azure SQL Database development workflow. Everything from designing my schema, tables, views and triggers to synchronizing these changes between development, test and production environments.

Nachteile:

Missing feature: I'm always writing and running SQL statements (some of them complicated), and I wish it would keep a history of my previously (successfully executed) SQL for each instance/database, so if I have a SQL tab that is connected to instance X on database Y that I can browse the history of SQL that I've run for that database (from newest to oldest) so that they're all automatically saved. Right now I do all that manually in a "handy SQL" file for each of my databases, but I often forget to save SQL that I end up re-writing again.

great, but still doesn't eliminate the use ssms

Vorteile:

data editor is best in class. very easy to use

Nachteile:

several features are missing: data classification in both discovery and management. also missing from column editor

Everything you need

Kommentare: Overall I am satisfied. Thanks to dbForge I save a lot of time.

Vorteile:

dbForge studio has everything you need for the daily work of a developer. All tools integrated in one program. I like the dependency search option the most. Comparing snapshots with the current database state.

Nachteile:

Very few software updates, no new features.

Good tools

Kommentare: Analyze customer database , performance, schema
Developpe database
distribute modification

Vorteile:

Data comparaison is a must have. the global ergonomy is good (devexpress inside).

Nachteile:

There is no Basic scripting the tools is not open to other databse. it would be nice if you merge différent database product in the same tools

Fast is DBA

Vorteile:

very fast coding and usage and code sniffer ver like me

Nachteile:

ssms result export to excel feature none

dbForge Studio for SQL Server review

Vorteile:

Autocomplete and Format works very well.

Nachteile:

Missing feature to configure the SQL Server Agent and the option to simplify statements as example switch CASE to IIF

Good bye RedGate!

Kommentare: I'm extremely happy with it, it is my goto SQL IDE now and a full replacement (its now gone) for the way too expensive SQL belt from Redgate.

Vorteile:

The schema and data comparison are up to or even over Redgate similar tools. I love also the option to automatically generate SQL for structures and for data with a single right click. e.g. Data from a query, CRUD statements, etc.

Nachteile:

There are some issues with the use of skins for the IDE (love the dark theme). You can see quite frequently refresh blinking while processing data. There are some small missing items to be a full replacement for MSSQL Studio e.g. schema creation, ability to see detailed information about the database (file location, db sizes, space available, etc)

A nice tool for all that develop over SQL Server

Vorteile:

Wealth of functionalities. Good "intellisense-like" auto-complete

Nachteile:

Unable to change the visualization date format without changing the locale