[hemmerling] Data Processing 4/5 - Database Managment Tools and Database Application Development Tools

Database Administration Tools with Support of SQL Databases of a single Vendor

Microsoft SQL Server Administration

DB3NF

  • The free DB3NF - “Rapid Application Development platform (RAD for Web)”, for use with Microsoft SQL Server and Microsoft IIS.

fabFORCE DBDesigner 4

dbForge SQL Complete

  • The free devart "dbForge SQL Complete" for add-in for SQL Server Management Studio Professional (2012, 2008) and Visual Studio Profesional - “SQL code formatter offer powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense”.

Microsoft SQL Server Data Tools ( SSDT )

Microsoft SQL Server Data Tools ( SSDT )
"Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013" ( SSDT-BI ) [ formerly: "SQL Server Business Intelligence Development Studio" ( BIDS ) ]
  • Microsoft Curah! Curate the web and share what you know "SQL Server Data Tools and SQL Server Business Intelligence (SSDT-BI)" - “The tools and templates integrate into a Visual Studio 2012 shell that is also installed. The previous generations of this toolset was known as SQL Server Business Intelligence Development Studio (BIDS). SSDT-BI, like BIDs leverages the Visual Studio Shell for the common design environment where the BI templates can be used. NOTE: The SSDT 'BI' version is different than the standard SSDT version, which does NOT include the BI templates”.
  • History:
    • SQL Server 2008R2: Last version to ship BIDS included with SQL Server.
    • SQL Server 2012: Included SSDT, which included the BIDS functionality for BI.
    • Post SQL Server 2012, a separate download:
      • “Microsoft SQL Server 2012 Data Tools - Business Intelligence for Visual Studio 2012”.
      • “Microsoft SQL Server 2012 Data Tools for Visual Studio 2012”.
    • SQL Server 2014:
      • “Microsoft SQL Server 2014 Data Tools” are included in all editions of Visual Studio 2013.4, including Express 2013.4 editions and the Community 2013.4.
      • SSDT-BI is not included with SQL Server, but a separate download: “Microsoft SQL Server 2014 Data Tools - Business Intelligence for Visual Studio 2013”.

Oracle Administration

MySQL Administration

Oracle Database Administration

  • The free Oracle SQL Developer Data Modeler, a Java application on Windows and Linux.
  • The free database development IDE Oracle "Oracle SQL Developer", a Java application on Windows and Linux.
    • Oracle SQL Developer works with Oracle, Access,... databases.
    • Future versions of Oracle SQL Developer are promised to work with MySQL, too.
  • The integrated database management tool Oracle Database 12c: EM Database Express - “Oracle Enterprise Manager Database Express, also referred to as EM Express, is a web-based tool for managing Oracle Database 12c. Built inside the database server, it offers support for basic administrative tasks such as storage and user management, and provides comprehensive solutions for performance diagnostics and tuning”.
  • Tbe free Oracle Migration Analyse Tool, a Java application.
    • The Oracle Migration Analyse Tool can analyse “MS SQL Server”, “Sybase”, “DB2 (UDB)”, but not “Oracle” “MySQL”.

PostgeSQL Administration

Server-Side SQLite Administration

SQLite Administration

  1. The OpenSource Detlef Groth "dgSQLite" - SQLite-Database Clients for SQLite3 and SQlite2 in Tcl/Tk.
  2. The discontinued David Deraedt "Lita - SQLite Administration Tool", Github "davidderaedt / Lita", an Adobe AIR application for WinXP, Linux, MacOS.
  3. The OpenSource Igor Khanin's Homepage "LiteMan" in C/C++ for Qt on Windows or Linux.
    • You may load, save and work with several query windows, concurrently :-).
  4. The free Mike T's SQLite Database Administrator Tool for Windows, Linux, MaxOSX.
    • You may open several query windows concurrently.
    • You may not load a query to a file, due to a software failure ( a loaded query is parsed, resulting in an empty query window ) :-(. Instead, you must use copy+paste.
    • You may save and work with several query windows, concurrently :-).
    • You may not include comments ( /* comment */ ) in your query.
  5. The OpenSource Github "slashmili / PySQLiteGUI" in Python.
    • Support of the Lua script language.
    • There is just one single query window :-(.
    • You may not load a query from or save a query to a file :-(. Instead, you must use copy+paste.
  6. The free orbmu2k "SQLite Administrator" for Windows.
    • You may load, save and work with several query windows, concurrently :-). But though You may save queries created within “SQLite Administrator” to files ( by “Save To File” ), there is no “Load From File” option in the query menu :-(. So You may load contents to query windows just by copy+paste.
    • You may not rename saved queries:-(.
    • Unexpected & unwanted behaviour of the user interface: CTRL-S does not save anything, but deletes the current query window, including history :-(.
    • Trigger operations ( Create, Edit, Delete ) :-).
    • There is just one single query window :-(.
    • You may not load a query from or save a query to a file :-(. Instead, you must use copy+paste.
  7. The free SQLite Expert Personal for Windows #.
    • You may load, save and work with several query windows, concurrently :-).
    • Trigger operations ( Edit Trigger Table ) :-).
    • A query window is not linked with a loaded file. I.e. there is no “Save” function ( expected/ususal keyboard shortcut “CTRL-S” ), but just “Save as” :-(.
    • In case of unsuccessful queries, the reason for failure is explained in a modal window, but just after an extra click on a “Details” button. However, the native SQLite error message is not displayed.
    • You may load, save and work with several query windows, concurrently :-).
    • There is just one single query window :-(.
    • You may not load a query from or save a query to a file :-(. Instead, you must use copy+paste.
    • You may load, save and work with several query windows, concurrently :-).
    • A query window is linked with a loaded file, i.e. there is a “Save” function :-).
    • In case of unsuccessful queries, the reason for failure is explained in a modal window. However, the native SQLite error message is not displayed :-(.
  8. The DonationWare SQLite Studio for Windows.
    • You may load and save queries :-), in one single query window :-(.
  9. The OpenSource CodePlex "SQLite Studio Management" for Windows with .NET 2.0.
    • You may open several query windows concurrently, but you may not close it.
    • You may not load a query from or save a query to a file :-(. Instead, you must use copy+paste.
    • You may not include comments ( /* comment */ ) in your query.
  10. The DonationWare SQLiteToo in compiled Python, for Windows and Linux.
    • There is just one single query window :-(.
    • You may not load a query from or save a query to a file :-(. Instead, you must use copy+paste.
  11. The Opensource Github "nopri/sqliteweb" ( noprianto "sqliteweb" ( - 2010-02-22 ) ) by noprianto - “Very simple web-based sqlite management ( shell script + coreutils )”.
  12. The OpenSource TkSQLite - “A GUI database manager for SQLite implemented by Tcl/Tk”.
  13. The OpenSource Soft In The Box "wxSQLite+" for Windows, Linux.
    • There is just one single query window :-(.
    • You may not load a query from or save a query to a file :-(. Instead, you must use copy+paste.

Database Administration Tools with Multi SQL Database Support

Server-side Database Administration Tools with Multi SQL Database Support

Database Administration Tools for Windows with Multi SQL Database Support

Database Administration Tools for Linux with Multi SQL Database Support

Resources

PostgreSQL

SQLite

Appropriate OpenDirectory Directory Pages

 
en/dbadmin.html.txt · Last modified: 2017/06/29 05:31 (external edit) · []
Recent changes RSS feed Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki