Skip to main content

Introducing SQL Operations Studio

SQL Operations Studio is a free lightweight modern database development and operations tool that you can use on Windows, Linux and macOS with SQL Server running anywhere, Azure SQL Database and Azure SQL Data Warehouse.

SQL extension for Visual Studio Code

Enable a T-SQL inner loop on your favorite code editor for Windows, Linux, or macOS. Connect to your SQL database running on Windows or Linux, on-premises or in any cloud. Access code editing features—such as IntelliSense and keyword completion—to more efficiently write T-SQL code, run queries, view results, and save to CSV or JSON formats.

Learn more

SQL Server Data Tools

Easily build, debug, maintain, and refactor databases inside Visual Studio. SQL Server Data Tools (SSDT) introduces a declarative model that spans all the phases of database development—enabling continuous integration and deployment for your databases. Work with a database project, or work directly with a connected database instance in Azure SQL Database, Azure SQL Data Warehouse, and SQL Server—running on Windows or Linux, on-premises or in any cloud.

Azure Data Studio

Azure Data Studio offers a modern editor experience for managing data across multiple sources with fast intellisense, code snippets, source control integration and an integrated terminal. Access, configure, monitor, and manage the Azure Data family of on-premises and cloud data platforms on Windows, MacOS and Linux with this graphical tool.

Command line interface and management tools

Automate numerous database development tasks on Windows and Linux by using the command prompt or scripts—including using SqlPackage and SQLCMD to run T-SQL statements, or creating a database snapshot .DACPAC file from a live SQL Server or Azure SQL Database.

Learn more

Data loading and migration

Use the Bulk Copy Program command-line utility to easily copy data between an instance of SQL Server and a data file in a user-specified format, import a large number of new rows into SQL Server tables, or export data out of tables into data files.

Learn more

Use SQL Server Migration Assistant to simplify migration to SQL Server and Azure SQL Database from Microsoft Access, IBM DB2, MySQL, Oracle, and Sybase ASE.

Learn more

Use SQL Server Integration Services (SSIS) to build enterprise-grade extract, transform, load (ETL) solutions with a rich set of built-in tasks and transformations that support a variety of data sources and targets. Easily clean and mine data, respond to events, update data warehouses, and manage SQL Server objects and data.

Learn more

Data science tools and services

Easily create your predictive models with Visual Studio using the Python Tools, R Tools, or F#, and run them as an Azure web service or by using SQL Server R Services.

Power BI data visualisation

Transform your company's data into rich, interactive visuals with Power BI. Use this suite of business analytic tools to help analyse data and share insights across your organisation.

Learn more

SQL Server Business Intelligence

Learn how to take complex data and turn it into business insights using a comprehensive, enterprise-ready business intelligence (BI) platform.

Learn more

Back To Top