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

Related page:

• Data Processing 1/7 - Databases, Webserver, Webservices, SQL, XML.
• Data Processing 2/7 - Descriptions of Data, Data Transfer and Data Protocols.
• Data Processing 3/7 - NoSQL Databases: Not Just SQL.
• Data Processing 5/7 - Business Intelligence.
• Data Processing 6/7 - Data Warehouse Modeling.
• Data Processing 7/7 - Machine Learning.

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

• The free fabFORCE DBDesigner 4 & free follow-ups.
  • fabFORCE DBDesigner 4 for Windows, Linux. Kylix 3 / Delphi 7 sources.
    • EN.Wikipedia "DBDesigner 4", DE.Wikipedia "DBDesigner 4".

• 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 Data Developer Center "Microsoft SQL Server Data Tools ..".
• SQL Server Data Tools Team Blog - “Offical team blog for SSDT, a tool for on and off-premise database development”.
  • SQL Server Data Tools Team Blog "SSDT and Visual Studio versions".
• “Microsoft Visual Studio 2013 for Windows Desktop” is shipped with SSDT, → see Software Development Tools.
  • You may do SQL unit tests with “Microsoft SQL Server Data Tools ( SSDT )” of “Microsoft Visual Studio Professional” and “Microsoft Visual Studio Ultimate”.
  • The free “Microsoft Visual Studio Express 2013” is shipped with an edition of “Microsoft SQL Server Data Tools ( SSDT )” which lacks the unit test feature.
  • All editions of “Microsoft Visual Studio 2013” are shipped with a “LocalDB” of SQL Server Express. So for development, you are not urged anymore to install “SQL Server Express” ( as a Windows service.. ) anymore on your development machines.
  • After you install Visual Studio 2013, you can go to “Tools / Extensions and Updates / Updates” to learn if there is an update to install.
  • Just the commercial editions of “Microsoft Visual Studio 2012” are shipped with SSDT.
• Tools shipped with Microsoft SQL Server:
  • Microsoft MSDN "bcp Utility" - “The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files”.
• Microsoft MSDN "Data Access and Storage / Lernen / SQL Server Data Tools" - "Microsoft SQL Server Data Tools ...".

• Microsoft Download Center "Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 ".
• 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”.

• MySQL Workbench, Community (OSS) Edition for WinXP and .NET 3.5.
  • MySQL Workbench Developer Central.
  • EN.Wikipedia "MySQL Workbench", DE.Wikipedia "MySQL Workbench".
  • MySQL Workbench, Community (OSS) Edition 5.0.30 - latest edition which can be patched to run on W2k.
• Sourceforge "DB Designer Fork", Sourceforge "DB Designer Fork" for Windows.
• phpMyAdmin for MySQL administration.
• MySQL GUI Tools Bundle for Windows and Linux.

• 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”.

• SourceForge "phpPgAdmin", SourceForge "phpPgAdmin" for PostgreSQL administration.
• The OpenSource SQL tools SourceForge "SQLTools for Oracle", SourceForge "SQLTools for Oracle".

• The OpenSource Zone.ee "DBED" - SQLite 3 database editor, written in PHP5.
• The OpenSource PEAR - PHP Extension and Application Repository "DB_Sqlite_Tools".
• The OpenSource Google Code "phpliteadmin. PHP-based admin tool to manage SQLite databases".
• The OpenSource SourceForge "SQLiteManager", SourceForge "SQLiteManager" in PHP4 / PHP5.
• The OpenSource SourceForge "phpSQLiteAdmin - Web-based SQLite administration", SourceForge "phpSQLiteAdmin - Web-based SQLite administration" in PHP.
• The OpenSource SourceForge "SQLiteFront", SourceForge "SQLiteFront" in PHP5.
• The OpenSource SourceForge "SQLiteWebAdmin", SourceForge "SQLiteWebAdmin" in PHP4 / PHP5.

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.
4. The OpenSource SourceForge "Icequake - SQLite 3 Query Browser", SourceForge "Icequake - SQLite 3 Query Browser" for Windows.
   • You may load, save and work with several query windows, concurrently .
5. 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.
6. The OpenSource Github "slashmili / PySQLiteGUI" in Python.
7. The DonationWare Osen Kusnadi "SQLite2009 Pro Enterprise Manager".
   • 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.
8. 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 ) .
9. The OpenSource SourceForge "SQLite Database Browser", SourceForge "SQLite Database Browser" for Windows with Qt.
   • 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.
10. The OpenSource SourceForge "SQlite Designer", SourceForge "SQlite Designer" for WinXP.
11. The free SQLite Expert Personal for Windows #.
    • SQLite Expert - Feature comparison.
    • 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.
    • SQLite Expert - Flash tutorials.
12. The free Mike Cariotoglou "Sqlite3Explorer" for Windows.
    • You may load, save and work with several query windows, concurrently .
13. The OpenSource Sqliteman - Sqlite Databases Made Easy, SourceForge "Sqliteman. Sqlite Databases Made Easy", SourceForge "sqliteman: sqlite3 admin and devel tool" for Windows and Linux.
    • Petr Vanek "The Sqliteman Handbook".
    • You may load and save queries , in one single query window .
14. The OpenSource browser add-on Google Code "sqlite-manager. Extension for Firefox and other apps to manage any sqlite database", Mozilla Firefox Add-Ons "SQLite Manager".
    • 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.
15. The DonationWare Ralf Junker, Delphi Inspiration – Delphi Components and Software Applications "SQLiteSpy" for Windows #.
    • 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 .
16. The DonationWare SQLite Studio for Windows.
    • You may load and save queries , in one single query window .
17. 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.
18. 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.
19. The Opensource Github "nopri/sqliteweb" ( noprianto "sqliteweb" ( - 2010-02-22 ) ) by noprianto - “Very simple web-based sqlite management ( shell script + coreutils )”.
20. The OpenSource TkSQLite - “A GUI database manager for SQLite implemented by Tcl/Tk”.
21. 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.

• The OpenSource Adminer - Database management in a single PHP file, SourceForge "Adminer - Database management in a single PHP file", SourceForge "Adminer - Database management in a single PHP file", for use with MySQL, SQLite, PostgreSQL, MS SQL, Oracle.
• The OpenSource bazdig.git, Github "slim/bazdig" - PHP SQL console/editor for PDO_sqlite and PDO_mysql.

• The free AnySQL Maestro Freeware for Windows.
  • Allows you to administer any database engine accessible via ODBC driver or OLE DB provider (SQLite, MySQL, Oracle, SQL Server, Access, and so on).
• The OpenSource Eclipse database manager plugin and standalone Eclipse-based database manager DBeaver, a Java application #.
  • From within DBeaver IDE, you may download and install a bunch of JDBC database drivers for the many supported SQL databases ( MySQL, SQLite, PostgreSQL, Microsoft SQL,...), easily and automatically!
  • You may load, save and work with several query windows, concurrently .
  • 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, by displaying the native SQLite error message.
• The free Nucleon Software "Database Master - Standard Freeware Edition" for Windows allows only Table Manager and SQL Query Editor with limited features .
  • Support for MongoDB, MySQL, PostgreSQL, FireBird, SQLite, MS SQL Server, SQL Azure, Oracle, IBM DB2, IBM Informix, Netezza, Ingres, EffiProz.
  • Nucleon Software - Database Master Editions.
• The free dbTools Software "DBManager Freeware/Standard" for Windows - “Specially designed for personal use, it has a minimun set of features that makes it ideal for new database users to perform basic database management. You can use this edition for FREE for non commercial use”.
  • DBManager - Features Sheet.
  • Support for MySQL (3.x, 4.x, 5.x), PostgreSQL (7,8), Interbase, Firebird, SQLite (2.8, 3.x) and DBF Tables.
  • DBManager 3.2.4, the current edition in 2013-02, is shipped with SQLite 2.8.16 ?! I failed to load a SQLite 3.x database .
• The OpenSource SourceForge "PlaneDisaster.NET", SourceForge "PlaneDisaster.NET" for Windows with .NET 2.0.
  • Support for JetSQL ( Microsoft Access File Format ) and SQLite.
  • There is just one single query window .
  • You may save a query to a file, but You may not load a query from a file . Instead, you must use copy+paste.
• Quest Software.
  • Quest "Trial Download and Freeware".
  • The commercial Quest Software "Spotlight on SQL Server Enterprise" - a test version with 30 days expiration is available.
  • The free Quest Software "Spotlight on MySQL" for Windows.
  • The free Quest Software "Toad for MySQL".
    • Toad 4.5, 4.6, 5.X require WinXP with .NET 3.5 SP1.
    • The legacy RoSoft Download -> "Toad for MySQL 4.1.0.220" is the latest edition for W2k.
  • The commercial Quest Software "Toad for SQL Server".
    • Toad 5 requires WinXP with .NET 3.5.
    • The legacy Brothersoft -> "Toad for SQL Server 4.1.0.226" is the latest edition for W2k.
  • Toadworld.
    • The Toad Data Modeler Community.
      • Toad's World MySQL Community.
        • The free “Toad Data Modeler” for Windows.
        • The free “Toad for MySQL” for Windows.
    • Toadworld - Freeware Downloads.
  • The free limited Quest Software "Toad Data Modeler" ( formerly: “CASE Studio 2”).
  • TOADSoft.com - Home of the World's #1 Tool for Database Application Developers and DBAs.
  • Quest Software "Document Library" - whitepapers.
• Quest Software.
  • Quest "Trial Download and Freeware".
  • The commercial Quest Software "Spotlight on SQL Server Enterprise" - a test version with 30 days expiration is available.
  • The free Quest Software "Spotlight on MySQL" for Windows.
  • Quest Software "Toad for MySQL".
    • Toad 4.5, 4.6, 5.X require WinXP with .NET 3.5 SP1.
    • The legacy RoSoft Download -> "Toad for MySQL 4.1.0.220" is the latest edition for W2k.
  • Quest Software "Toad for SQL Server".
    • Toad 5 requires WinXP with .NET 3.5.
    • The legacy Brothersoft -> "Toad for SQL Server 4.1.0.226" is the latest edition for W2k.
  • Toadworld.
    • The Toad Data Modeler Community.
    • Toadworld - Freeware Downloads.
  • The free limited Quest Software "Toad Data Modeler" ( formerly: “CASE Studio 2”).
  • TOADSoft.com - Home of the World's #1 Tool for Database Application Developers and DBAs.
  • Quest Software "Document Library" - whitepapers.

• The OpenSource SourceForge "knoda - Knorr's Datenbank", SourceForge "knoda - Knorr's Datenbank" for Linux with KDE.
  • Support for Dbase/Xbase, Firebird, MS Access/Mdbtools, Mysql , Paradox, Postgresql, SQLite and ODBC.

• Wiki PostgreSQL Wiki.
  • PostgreSQL Wiki "Community Guide to PostgreSQL GUI Tools".
• PostreSQL.de.
  • PostreSQL.de "PostgreSQL & Co. - Grafische Benutzerschnittstellen für PostreSQL".

• BareFeedWare "SQLite Applications Comparison". *Solutions, better "Commercial and freeware Sqlite tools list".
• SQLite CVSTRAC Wiki "Management Tools".
• Stack Overflow "Which SQLite administration console do you recommend?".

• OpenDirectory "Top: Computers: Software: Databases".
• OpenDirectory "Top: World: Deutsch: Computer: Software: Datenbanken".