Unknown SQL Server Platform - The target platform for this project is not supported by the installed SQL Server tools. I clicked ‘Next’, and that’s where things got wacky. I chose two databases on my local SQL Server 2017 instance. I clicked ‘Get Started’, and proceeded to the step to configure my connections.Īt this point, I was prompted to specify my development database and deployment target.

This launched the wizard to set up the project. In the ‘SQL Change Automation’ window, I clicked ‘Create Project’, selected ‘SQL Change Automation Project’ and gave it a name, and click OK. I used the default checkboxes on the right there, installing everything except F# desktop language support. When I installed Visual Studio 2017, I selected the ‘Data storage and processing’ workload, which contains SQL Server Data tools as well as some of the Redgate tools: Spoiler: Visual Studio suggested updating Microsoft’s SQL Server Data Tools, which failed for me and wasted a lot of time. Updating Visual Studio did fix my issue. For any other folks out there searching on “Unknown SQL Server Platform,” here’s how I got past it. I recently set up Redgate’s SQL Change Automation in Visual Studio 2017, and I ran into a confusing error when I started trying to use it.

Database visual studio 2017 sql server