SQL is NOT supported on Visual Studio for Mac.
To see what tools are supported, click hereRazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases.
Modernize your database development lifecycle
Develop, build, test and publish your database from a source controlled project, just like you develop your application code. Start from scratch with a new Database project, or import an existing database with a few clicks
Validate T-SQL scripts as you type
Editing T-SQL in your database is easier thanks to enhanced IntelliSense and error highlighting. Identify syntax and schema reference errors, track the impact of your changes using Find All Reference and Go To Definition. By the time you finish typing, your T-SQL script is already tested and ready to run.
Focus on what your table should be. Forget how to get there.
Use Table Designer to design a new table, modify existing table, or quickly add new or modify existing columns, constraints and indexes. You don’t need to write the complex code to alter affected indexes, views, procedures and functions – Visual Studio writes the change script for you. Just focus on what your table should be.
View and edit data without writing a script
Viewing and editing data in a table is the most frequent task for developers but it usually requires writing a query. With Visual Studio, view and edit data in a tabular grid, filter the grid using a simple UI and save changes to your database with just a few clicks.
Diff your database
Do you ‘diff’ to know changes in your application’s source code? You can do diff on multiple versions of your database using schema compare and data compare in Visual Studio. The result of the comparison between two databases or database projects is analyzed and allows you to apply the change from source database to target, or simply generate T-SQL scripts you can view, modify and run at your control.
Essentials for success
Continuous integration and continuous deployment has become a common practice for modern application development projects. Use Visual Studio to bring databases into your end-to-end application development lifecycle (ALM) practice by fully automating build and deployment whenever a change is made to your application and database. Invest 10 minutes to significantly boost the chance of success for your project.
Microsoft Sql Query Tool For Mac Free
Free, fully-featured IDE for students, open-source and individual
developers
Professional developer tools, services, and subscription benefits for small
teams
End-to-end solution to meet demanding quality and scale needs of teams of all
sizes
Sql Server Tools Download
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris.
RazorSQL has been tested on over 40 databases, can connect to databases via eitherJDBC or ODBC,and includes supportfor the following databases:
| 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. |
Additional Information
RazorSQL provides both easy to use visual tools and advanced features to allowusers to do database browsing, editing, management, administration, and programming.Browse the database specific features or the complete feature reference.
Features
- A Database Navigator for browsing database objects.
- An SQL Editor for creating SQL queries.
- Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences
- Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers
- A robust programming editor that embeds the powerfulEditRocket code editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more.
- Export Tool - Export data in various formats
- Import Tool - Import data from delimited files, Excel files, or fixed width files into tables
- Ships with a built-in relational database engine (HSQLDB) that is up and runningout of the box and requires no end-user administration
- A Generate DDL Tool for generating table, view,and index DDL.
- Table / SQL Query Compare tool for comparing tables or queries across multiple connections
- Database Data Search tool for searching single or multiple database table and view data.
- Database Object Search tool for searching for database objects.
- Backup tools such as the Database Backup Tool and Table Backup Tool
- Database conversion tools for many popular databases such as MySQL, Oracle, DB2, PostgreSQL, SQLite, MS SQL Server, and MS Access.
- Auto column and auto table lookup
- SQL Query builder tool
- SQL Query Scheduler tool
- PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers
- An ASP bridge for connectingto MS SQL Server databases remotely via ASP enabled web servers
- SQL GUI Tools for generating SQL for various operations
- Edit, delete, and insert database data with the Database Editor
- Works with all major operating systems including Windows, macOS, Mac OS X, Linux, Solaris, and any other Java enabled OS
- Tested with Apache Cassandra, Apache Derby / JavaDB, Apache Hive, Daffodil DB, DB2, DBASE, Druid, DynamoDB, Firebird, FrontBase, H2, HSQLDB / HyperSQL, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MongoDB, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Redshift, Salesforce, SimpleDB, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, Teradata, and VoltDB