SQL Server Database Tools on a Mac

Question

I have a DB project which relies on SQL Server Database tools. I am trying to work on it on a Mac. The rest of the project is in .NET Core so that all works well. The database project throws an error on dotnet restore

/Users/mborozdin/src/ethos/FileRepository/src/FileRepository.Database/FileRepository.Database.sqlproj(63,3): error MSB4019: The imported project "/usr/local/share/dotnet/sdk/2.1.4/Microsoft/VisualStudio/v10.0/SSDT/Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found. Confirm that the path in the declaration is correct, and that the file exists on disk.

Is there an alternative to SSDT which seems to be only available on Windows?

Solution 1

When you develop on the Mac,
You will put your SQL Server on the docker or Virtual Machine.

In other to connect, You need SQL Operations Studio for the Mac Download Link

Solution 2

Is there an alternative to SSDT which seems to be only available on Windows?

The alternative is Azure Data Studio. As for:

SQL Database Projects extension

The SQL Database Projects extension brings project-based database development, well-known in SQL Server Data Tools (SSDT), to the cross-platform Azure Data Studio experience. From this early insiders release you can create, build, and publish a project from scratch or an existing database.

https://github.com/microsoft/azuredatastudio/issues/11105

Comments

[Larnu]

SSDT is only available for Windows at the moment, which is required for SSIS/SSRS/SSAS development.

[Adir D]

There are other tools, like SQL Operations Studio, which runs on Win/Mac/Linux. But SSDT proper, you're out of luck. Use a VM.

[Greg]

Note: 'SQL Operations Studio' has been renamed to 'Azure Data Studio'