Athena | Greenplum | Mimer SQL | Salesforce |
Aurora | H2 | MongoDB | SimpleDB |
BigQuery | Hive | MonetDB | Snowflake |
Cassandra | HSQLDB | MS SQL Server | solidDB |
DB2 | Informix | MySQL | SQLite |
DBASE | Ingres | Netezza | SQL Anywhere |
Derby | Interbase | OpenBase | SQL Azure |
Druid | Int.Sys. Cache | Oracle | Sybase (ASE) |
DynamoDB | JavaDB | Paradox | Sybase IQ |
Filemaker | kdb+ | Pervasive | Teradata |
Firebird | MariaDB | PostgreSQL | Vertica |
Frontbase | Microsoft Access | Redshift | VoltDB |
Database Browser | SQL Editor |
Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures,functions, and more. | Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Uses the powerfulEditRocket code editor that supportsover 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, Java, XML, and more. |
Database Tools | Database Query Tool |
Visual tools to create, alter, describe, execute, and drop database objects such as tables, views,indexes, stored procedures,functions, triggers, and more. | Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more. |
Import Data | Export Data |
Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files. | Export data in various formats such as delimited files, XML, HTML, Excel spreadsheets, JSON, and SQL insert statements. |
SQL Query Builder | Built-in Database |
Create select, insert, update, and delete SQL statements. Create multi-table joins. | Includes a robust relational database (HSQLDB) that is up and running with no manual configurationout of the box. |
Edit Table Tool | Data Compare |
Insert, update, and delete table data in a spreadsheet like format. Find and replace data, previewgenerated SQL, and more. | Compare table data across databases, or compare the results of queries. |
docker pull mcr.microsoft.com/mssql/server:2017-latest-ubuntu
to download SQL Server 2017. docker pull mcr.microsoft.com/mssql/server:2019-CTP3.2-ubuntu
.microsoft/mssql-server-linux
with the one you downloaded.-d
--name sql_server_demo
-e 'ACCEPT_EULA=Y'
Y
shows that you agree with the EULA (End User Licence Agreement). This is required in order to have SQL Server for Linux run on your Mac.-e 'SA_PASSWORD=reallyStrongPwd123'
sa
database password.-p 1433:1433
microsoft/mssql-server-linux
reallyStrongPwd
as the password (but of course, it’s not a really strong password!). I was able to overcome this by adding some numbers to the end. However, if it wasn’t just a demo I’d definitely make it stronger than a few dictionary words and numbers.Please try running this command again as root/Administrator, try again, but this time prepend
sudo
to your command:mssql
command, followed by the username and password parameters.