Unable to create Extension Manager for Target Platform "Microsoft. Data. Tools. Schema. SQL. Sql120DatabaseSchemaProvider", databaseschema

Unable to create Extension Manager for Target Platform "Microsoft. Data. Tools. Schema. SQL. Sql120DatabaseSchemaProvider", databaseschema

I haven't written a blog for a long time. During this time, my mood was not so stable, but I still had a mentality problem...

Let's simply write a solution to the problem. In fact, there have been a lot of problems recently, so let's take the solution and try again.

 

As in the title, VS2013 cannot create an Extension Manager (Chinese version) for the target platform "Microsoft. Data. Tools. Schema. SQL. Sql120DatabaseSchemaProvider)

Solution: Visual Studio 2013 --> Extensions and Updates --> Updates

Click the Update button after "Microsoft SQL Server Update for database tools. For example:

 

Download and install SSDTSetup.exe.

 

The reason is that this tool is used in the Team for design and check-in. Other members obtain and load this project.

The solution is as follows: update and install SSDT.

 

What is SSDT?

SSDT: Microsoft SQL Server Data Tools (SSDT) provides an integrated environment for database developers to support any SQL Server Platform (both internal and external) in Visual Studio) perform all database design work. Database developers can use the SQL Server Object Resource Manager in VS to easily create or edit database objects and data, or execute queries.

 

Refer: