Best Data Management Tool For Mac

The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.

Systems listed on a light purple background are no longer in active development.

Reviewing 24 of the best data collection software applications. GetApp lets you compare the list of tools and vendors that provide data collection software solutions. Part of selecting the best data warehouse software solution for your organization is making sure it aligns to business objectives. There a wide variety of great data warehouse software tools out there that focus on a specific use case or niche in the market. Text Mining Infrastructure in R(tm) provides a framework for text mining applications within R. R is a free software environment for statistical computing and graphics which compiles and runs on a wide variety of UNIX platforms, Windows and MacOS.

General[edit]

ProductCreatorLatest stable release dateLatest stable releaseLicenseRuns on WindowsRuns on Mac OS XRuns on LinuxOracleMySQLPostgreSQLMS SQL ServerODBCJDBCSQLiteOtherProgramming language
AdminerJakub Vrána2019-07-18[±]4.7.2[1]Apache License or GPLYesYesYesYesYesYesYesYesPHP
DaDaBIKEugenio Tacchini2019-07-23[±]9.4 Monterosso[2]ProprietaryYesYesYesYesYesYesYesNoNoYesPHP
Database Deployment ManagerThe Unauthorized Frog project2012-05-29v0.1iLGPLYesNoYesYesQt/C++
DatabaseSpyAltova2019-04-02[±]2019r3[3]ProprietaryYesNoNoYesYesYesYesYesYesIBM DB2, Sybase, MS AccessC++
Database WorkbenchUpscene Productions2017-06-295.3.2ProprietaryYesrequires Winerequires WineYesYesYesYesInterBase, Firebird, SQL Anywhere, NexusDB and MariaDBDelphi
DataGripJetBrains2017-09-062017.2.2ProprietaryYesYesYesYesYesYesYesNoYesYesSybase, DB2, H2, Hypersonic SQL, Amazon Redshift, Apache DerbyJava
DBeaverSerge Rider2019-03-106.0Apache LicenseYesYesYesYesYesYesYesYesYesYesMySQL, PostgreSQL, Oracle, EXASOL, IBM DB2, SQL Server, Apache Derby, Firebird all with JDBC driverJava
DBEditJef Van Den Ouweland2012-05-102.4.6GPLYesYesYesYesYesYesYesNoYesYesIBM DB2, HSQLDB, Apache Derby, H2Java
EpictetusAntilogic Software??ProprietaryYesYesYesYesYesYesSybase, InterBase/Firebird, H2, HSQLDBJava
HeidiSQLAnsgar Becker2019-06-15[±]10.2[5]GPLYesrequires Winerequires WineYesYesYesEmbarcadero Delphi
MaatkitBaron Schwartz2010-06-015247GPLYesYesYesYesPerl
Microsoft SQL Server Management StudioMicrosoft2019-07-28[6]18.2ProprietaryYesNoNoYesincluding SSAS management, and MDX, DMX, and XMLA languages.Net
ModelRightModelRight2016-12-??4.1[7][8]ProprietaryYesNoNoYesYesYesYesSQL Server, Oracle, MySQL, PostgreSQL, DB2, DB2/zOS, MS AccessC++
MySQL WorkbenchOracle Corporation2019-06-24[±]8.0.17[9]Community Ed: GPL

Standard Ed: Commercial Proprietary

YesYesYesYesC++/C#Objective-CPython (programming language)
NavicatPremiumSoft CyberTech Ltd.2018-07-2612.1ProprietaryYesYesrequires WineYesYesYesYesYesYes
Navicat Data ModelerPremiumSoft CyberTech Ltd.2015-12-102.1ProprietaryYesYesYesYesYesYesYesYesYes
Oracle Enterprise ManagerOracle Corp.2015-06-1612.1.0.5ProprietaryYesNoYesYesYesYesDB2, Sybase, TimesTenJava
Oracle SQL DeveloperOracle Corp.2018-04-0518.1.0.095.1630ProprietaryYesYesYesYesYesNoYesYesYesMicrosoft Access, Sybase, DB2, TeradataJava
OrbadaAndrzej Kaluza2016-12-06[±]1.2.5.395[10]GPLYesYesYesYesYesYesYesYesYesYesFirebird, HSQL, InterBase, Derby all with JDBC driverJava
pgAdmin IIIpgAdmin Development Team2012-09-111.22.2PostgreSQL LicenseYesYesYesYesC++
phpLiteAdminDane Iracleous2016-12-141.9.7.1[11]GPLYesYesYesNoNoNoNoNoNoYesPHP
phpMyAdminphpMyAdmin Development Team2019-06-04[±]4.9.0.1[12]GPLYesYesYesYesDrizzle, MariaDBphp
SQL Database StudioJan Prochazka2016-05-273.4.1ProprietaryYesNoNoNoNoNoYes.NET, WPF, C#
SQLyogWebyog Softworks Pvt. Ltd.2019-07-19[±]13.1.5[13]GPLv2Yesrequires Winerequires WineYesC++
SQuirreL SQLColin Bell, Gerd Wagner, Rob Manning and others2019-02-24[±]3.9.1[14]GPLv2 & LGPLv2YesYesYesYesYesYesYesYesYesYesAccess,Axion Java RDBMS, Apache Derby, Daffodil DB, FileMaker (JDBC), Fujitsu Siemens SESAM/SQL, Firebird, FrontBase, HSQLDB, Hypersonic SQL, H2 (DBMS), IBM DB2, Informix, Ingres, OpenIngres, InstantDB, InterBase, Mckoi SQL Database, Microsoft SQL Server, Mimer SQL, Netezza, Pointbase, SAPDB, Sybase, Sunopsis XML Driver, Teradata Warehouse, ThinkSQL RDBMS, Vertica Analytic Database, and others with JDBC drivers.Java
ToadQuest SoftwareVariousVariousProprietaryYesNoNoYesYesYesYesDB2, SybaseEmbarcadero Delphi, C#.NET
Toad Data ModelerQuest Software2009-03-053.3.8ProprietaryYesNoNoYesYesYesYesDB2, MS Access, SybaseEmbarcadero Delphi
TOraCommunity2017-07-043.2GPLYesYesYesYesYesYesTeradataC++/Qt

Features[edit]

Legend

  • Create/alter table:
    • Yes - can create table, alter its definition and data, and add new rows
    • Some - can only create/alter table definition, not data
  • Browse table:
    • Yes - can browse table definition and data
    • Some - can only browse table definition
  • Multi-server support:
    • Yes - can manage from the same window/session multiple servers
    • Some - can manage from a different window/session multiple servers
  • Monitoring server:
    • Yes - includes a headless server, that runs checks and reports failures
Best Data Management Tool For Mac
ToolsUser InterfaceCreate & Alter wizardBrowseAuto CompletionSyntax coloredMulti server supportMonitoring server
DatabaseTableProcedureTriggerDatabaseTableProcedureTrigger
AdminerBrowser-basedYesYesYesYesYesYesYesYesNoYes??
Altova DatabaseSpydesktopYesYesYesYesYesYesYesYesYesYesYes?
DaDaBIKBrowser-basedNoSome[note 1]NoNoNoSome[note 2]NoNoNoNoNo?
Database Deployment ManagerdesktopYesYesYesYesYesYesYesYesYesYesNo?
Database WorkbenchdesktopYesYesYesYesYesYesYesYesYesYesYes?
DataGripdesktopYesYesYesYesYesYesYesYesYesYesYesNo
DBeaverdesktopYesYesYesYesYesYesYesYesYesYesYesYes
DBEditdesktopNoNoNoNoYesYesYesNoNoYesNo?
EpictetusdesktopNoYesNoNoYesYesYesYesYesYes??
Microsoft SQL Server Management StudiodesktopYesYesYesYesYesYesYesYesYesYesYesNo
ModelRightdesktopYesYesYesYesYesYesYesYesNoYes??
MySQL WorkbenchdesktopYesYesYesYesYesYesYesYesYesYesYesSome
NavicatdesktopYesYesYesYesYesYesYesYesYesYesYes?
Navicat Data ModelerdesktopNoYesNoYesNoNoNoNoYesYesYes?
Oracle Enterprise ManagerBrowser-basedYesYesYesYesYesYesYesYesYesYes?Yes
Oracle SQL DeveloperdesktopNoYesYesYesYesYesYesYesNoYesYes?
OrbadadesktopYesYesYesYesYesYesYesYesYesYesYesNo
pgAdmin IIITDIYesYesYesYesYesYesYesYesYesYesYesSome
phpLiteAdminBrowser-basedYesYesNoYesYesYesNoYesNoNo??
phpMyAdminBrowser-basedYesYesYesYesYesYesYesYesYesYesYesYes
SQL Database StudiodesktopYesYesYesYesYesYesYesYesYesYesYesNo
SQLyogdesktopYesYesYesYesYesYesYesYesYesYes??
SQuirreL SQLdesktop????YesYes??YesYesSome?
ToaddesktopYesYesYesYesYesYesYesYesYesYes??
Toad Data ModelerdesktopYesYesYesYesSomeSomeSomeSomeNoYes??
TOradesktopNoYesYesNoYesYesYesYesYesYesYes?

Features (continued)[edit]

Legend:

  • User manager:
    • Yes - user manager with support for database and schema permissions as well as for individual object (table, view, functions) permissions
    • Some - simple user manager with support for database and schema permissions
    • No - no user manager, or read-only user manager
user managerPluginCompareImportExportDebuggerSource controlSpatial Visualization
AdminerYesYesYesSQL script, CSV, TSV or the above in zip (as a plugin); imports of server-site file in SQL or SQL in zip, gzip or bzip2SQL script, CSV, TSV or the above in zip, gzip, bzip2; XML (as a plugin)NoGit
Altova DatabaseSpyNoNoYesCSV, XMLXML, XML Structure, CSV, HTML, MS ExcelNo?
DaDaBIKSome[15]NoNoNoCSVYesNo
Database WorkbenchYesNoYesYesYesYes?
DataGripNoYesYesYesTXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIFNoYes
DBeaverYesYesYesYesYesNoWith Eclipse plugins
DBEditNoNoNoNoMS Excel, PDF, Text, SQL scriptNo?
EpictetusNoYesNoNoExcelNo?
ModelRightSomeYesYesYes - from supported databases using native interfaces, or from any ODBC sourceSQL; XML; DTD; Diagram as BMP, JPEGNo?
NavicatYesNoYesYes - TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitations[16])Yes - TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF (See link for limitations[16])YesNo
Navicat Data ModelerNoNoYesYes - Import Database from server/ODBCYes - Export SQLNoNo
MySQL WorkbenchYesYesYesYes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XMLYes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XMLYesNo
Oracle SQL DeveloperYes??YesYesYes?
OrbadaNoYesYesSQL scriptSQL script, CSV, XML, HTML, PDF, Excel, DBF, DataTextNoNo
pgAdmin IIIYesYesNoCSV, Text, or binaryCSV, text, HTML, XMLYesNo
phpMyAdminYesSomeYesYes - CSV, SQL, XML, Excel, ODSYes - CSV, LaTeX, Excel, Word, ODS, ODT, XML, SQL, YAML, Texy!, JSON, NHibernate, PHP, PDF, MediaWikiYesGit
SQL Database StudioYesYesNoCSV, XML, MS ExcelCSV, HTML, MS Excel, SQL INSERTS, Tab-separated, XMLNoNo
SQLyogYes?YesYesYes??
SQL Server Management StudioYesYes?YesYesYesYes[17]Yes
SQuirreL SQL?YesYesYes?No?
ToadSomeNoYesYesYesYesSVN, CVS, TFS, VSS
Toad Data ModelerNo?YesToad for Oracle ERD, ERWin 7.1(XML) via pluginSQL; meta data in XML; report in HTML/RTF/CSV; diagram as BMP, JPEG, PNGNo?
TOraSomeNoYesYesYesYesNo

Features - visual design and reverse engineering[edit]

Legend:

  • Visual schema/E-R design: the ability to draw entity-relationship diagrams for the database. If missing, the following two features will also be missing
  • Reverse engineering - the ability to produce an ER diagram from a database, complete with foreign key relationships
    • Yes - supports incremental reverse engineering, preserving user modifications to the diagram and importing only changes from the database
    • Some - can only reverse engineer the entire database at once and drops any user modifications to the diagram (can't 'refresh' the diagram to match the database)
  • Forward engineering - the ability to update the database schema with changes made to its entities and relationships via the ER diagram visual designer
    • Yes - can update user-selected entities
    • Some - can only update the entire database at once
Visual query builderVisual schema/model/E-R diagram designReverse engineeringForward engineeringER diagram groupboxes
AdminerYesYesYesNoNo
Altova DatabaseSpyYesYesYesYes?
Database Deployment ManagerYesYesYesNoNo
Database WorkbenchYesYesYes?Yes
DBeaverNoYesYesNo?
DBEditNoNoNoNoNo
ModelRightNoYesYesYesYes
NavicatYesYesYesYesYes
Navicat Data ModelerYesYesYesYesYes
MySQL WorkbenchYesYesYesYesYes
Oracle SQL DeveloperYesYesYesYes?
OrbadaNoNoNoNoNo
pgAdmin IIIYesNoNoNoNo
phpMyAdminYesYesYesNoNo
SQL Database StudioYesYesYesYesNo
SQL Server Management Studio?YesYes??
SQLyogYes[18]Yes[19]YesYes?
SQuirreL SQLYesYesYes[note 3]?No
ToadYesYesYesYes?
Toad Data ModelerNoYesYesYes[note 4]?

See also[edit]

Notes[edit]

  1. ^create CRUD interfaces, so create table data, not table theriselves.
  2. ^Browse table data, not table definitions.
  3. ^Only incremental, by manually going through each table and clicking 'Add to graph'.
  4. ^Generated SQL must be executed outside Toad Data Modeler.

References[edit]

  1. ^'Database management in a single PHP file'. adminer.org. Retrieved 2019-07-24.
  2. ^'Change log'. dadabik.com. Retrieved 2019-07-24.
  3. ^'What's New in DatabaseSpy'. altova.com. Retrieved 2019-07-24.
  4. ^'DBEdit 2 - Changelog'. dbedit2.sourceforge.net. Retrieved 2019-07-24.
  5. ^'Releases - HeidiSQL/HeidiSQL'. github.com. Retrieved 2019-06-06.
  6. ^'Download SQL Server Management Studio (SSMS)'. 11 Jun 2019. Archived from the original on 12 Jun 2019.
  7. ^'An Overview of Database Diagram Tools Available for PostgreSQL'. Severalnines. 2019-07-05. Retrieved 2019-07-24.
  8. ^'ModelRight Download full version trials'. www.modelright.com. Retrieved 2019-07-24.
  9. ^'Releases - mysql/mysql-workbench'. github.com. Retrieved 2019-07-24.
  10. ^'Orbada - Database manager - Browse /Orbada at SourceForge.net'. sourceforge.net. Retrieved 2019-07-24.
  11. ^https://bitbucket.org/phpliteadmin/public/downloads
  12. ^'Security fix: phpMyAdmin 4.9.0 is released'. phpmyadmin.net. Retrieved 2019-06-06.
  13. ^'SQLyog MySQL GUI 13.1.5 Released'. sqlyog.com. Retrieved 2019-07-24.
  14. ^'SQuirrel SQL Client - Browse/1-stable'. sourceforge.net. Retrieved 2019-07-24.
  15. ^can manage its own users, which override the DBMS users
  16. ^ abtitle= Navicat feature matrix
  17. ^https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/
  18. ^SQLYog query builder
  19. ^SQLYog schema designer

External links[edit]

Retrieved from 'https://en.wikipedia.org/w/index.php?title=Comparison_of_database_tools&oldid=908676818'

About iOS 12 Videos/Music/Photos Management

MacX MediaTrans will take care of all the videos, songs, photos saved in your iOS 12 devices. Users can batch edit music info like ID3 tags, artists, album names, preview images/video thumbnails and create playlists for a tidy management. You can also use this iOS file manager to delete files as you wish.

Test Data Management Tools

Tool data management software

Aside from that, users can transfer video music photos from Mac to iOS 12 iPhone iPad iPod for taking on the go or reversely for file backup. The extra credit for this transfer utility is its startling speed - transferring 32G 4K videos, 4K photos between iPhone and Mac within 9 minutes! Video auto rotate is another feature that might draw your interest. The vertical videos transferred from Mac to iOS 12 devices will be automatically rotated to horizontal and fit the full screen mode.

Master Data Management Tools

Important Notice: If you are users of iPhone 5S or newer generation, you can update to iOS 12 to enjoy the stunning features. Here we also provide the complete iOS 12/11/10 preparation and download tips as well as iOS 12 update problems to be possibly encountered.