What are the best apps for SQL server database administration?

asked by Rob Russell
40 contributors
9 solutions
  1. 9

    #1SQL Power Architect

    SQL Power Architect
    The SQL Power Architect data modeling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect.
    Software

    Windows

    Free- Varies by plan

    Amit Pawar
    Written on January 19, 2018
    "SQL Power Architect is one of the best apps out at the moment for SQL server database administration. I have found that my workload became a lot easier to manage after becoming acquainted with this app."
  2. 6

    #2ErWin

    ErWin
    ErWin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage your complex data environment.
    Software

    Windows

    Free

    Eugene Allen
    Written on January 21, 2018
    "ErWin is my preferred tool to mange complex data infrastructure. I have been using ErWin for some time now and it has yet to let me down."
  3. 4

    #3DbSchema

    DbSchema
    Integrated database tool featuring diagrams, data explorer from multiple tables, schema compare and synchronization, query builder, query editor, HTML5 documentation, random data generator, forms and reports and more.
    Software

    Windows, Mac

    $63- Free trial available

    Aaron Taylor
    Written on January 29, 2018
    "When it comes to managing the backend of my website I utilize DbSchema for just about everything. The database tools on offer here allow me to spend less time struggling with making things work and more time managing my data as efficiently as possibly."
  1. 4

    #4Embarcadero ER/Studio

    Embarcadero ER/Studio
    With ER/Studio Data Architect's extensive data modeling and metadata capabilities, you can document critical data elements, business data objects, and regulatory data elements and show their sources, interactions, and dependencies, in logical and physical data models.
    Software

    Windows

    Price upon request

    Zhu Deng
    Written on April 16, 2018
    "I got this product for a group project, and while I'm still wading through all the tools and capabilities, so far it seems to be a powerful platform that we can work off of. I do I like all the services it provides. So I think I'll keep it and continue learning the ins and outs. "
  2. 4

    #5dbForge Studio for MySQL

    dbForge Studio for MySQL

    dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database administration, development, and management. The IDE allows to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface. 

    Software

    Windows

    $79.95- Free trial available

    Andrea Smith
    Written on January 31, 2018
    "Really great tool!"
  3. 2

    #6dbForge Studio for SQL Server

    dbForge Studio for SQL Server

    dbForge Studio for SQL Server is an all-in-One SQL Server GUI Tool that will allow developers perform complex database changes operations more effectively. This is a powerful IDE for SQL server management, administration, development, data reporting and analysis.

    Software

    Windows

    Free- Express edition. Varies by plan

    Andrea Smith
    Written on January 31, 2018
    "dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis."
  4. 1

    #7dbForge Developer Bundle

    dbForge Developer Bundle

    dbForge Developer Bundle is an enhanced SQL Server Management Studio package from dbForge. It includes most of the dbForge's database management tools and comes with a year of support and upgrades.

    Software

    Web

    $849.95

    Ekaterina Sklyarova
    Written on July 26, 2018
    "This is so useful set of tools, all I need is gathered together."
  5. 1

    #8SQL Buddy

    SQL Buddy
    SQL Buddy is an open source web based application written in PHP intended to handle the administration of MySQL and SQLite with the use of a Web browser.
    Apps

    Windows

    Free

    Sharon Lane
    Written on January 25, 2018
    "SQL Buddy is the best app for SQL server database administration that I've used to date. It's smart, intuitive, and does everything I need it to do. HIghly recommend!"
  6. 0

    #9TablePlus

    TablePlus
    TablePlus is a modern, native and intuitive software for making database management easier, faster and efficient. It also offers many security options like native libssh and TLS to protect your database.


    Software

    Mac

    Free- $49

    Tung Thanh
    Written on February 24, 2018
    "* With native build, we eliminate needless complexity & extraneous details in the app that it can run really fast and doesn’t take much memory. * Modern & well designed graphical user interface (GUI) * It’s equipped with many security features to protect your database, including native libssh and TLS to encrypt your connection. * Active development"

Summary

Best What are the best apps for SQL server database administration
RankSolutionsTypeVotesPrice
1SQL Power ArchitectSoftware 9 Free
2ErWinSoftware 6 Free
3DbSchemaSoftware 4 Paid
4Embarcadero ER/StudioSoftware 4 Paid
5dbForge Studio for MySQLSoftware 4 Paid
6dbForge Studio for SQL ServerSoftware 2 Free
7dbForge Developer BundleSoftware 1 Paid
8SQL BuddyApps 1 Free
9TablePlusSoftware 0 Free
Close

This action requires you to be logged in

Quickly sign in with your social media account:

What interests you most? (Select at least 3)

This will help us to keep things fresh and relevant!

Close

Now that you’ve found a solution...

Why not join our community of sharp minds and pro-active posters?

Be part of a rewarding interactive knowledge exchange!
Close

Join These Inquisitive Minds

Engage, learn and share with a friendly community versed in a massive range of trending topics.