After installing SSDT for SQL Server 2017 in VS 2017, I still cannot load an earlier version's dtproj
file.
This project is incompatibility with the current edition of Visual Studio
The old .dtproj
looks like this:
<Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ProductVersion>10.50.1600.1</ProductVersion>
<SchemaVersion>9.0.1.0</SchemaVersion>
The newer dtproj looks like this:
<Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<DeploymentModel>Project</DeploymentModel>
<ProductVersion>14.0.800.60</ProductVersion>
<SchemaVersion>9.0.1.0</SchemaVersion>
In general they appear similar. I haven't really seen any documentation at https://learn.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt that addresses how to upgrade the project files.
Is there any tooling for performing upgrades?
SSDT 15.8.1 has an import .ispac wizard that will create the components for you. Setup is a bit tricky though.
Steps to Setup
All components should be created for you.