SQL Server Data Tools CTP4 vs. VS2010 Database Projects

The table below provides a comparison between the feature set of SQL Server Data Tools (SSDT) CTP4 and that of the existing Visual Studio 2010 Database Projects (VSDB). To see an enumeration of common project conversion issues and their workarounds, please see the “Top VSDB->SSDT Project Conversion Issues” blog post. SSDT can be used side-by-side with VSDB if your application relies on features not included in SSDT CTP4.

  Features At a Glance

image

 

Project Conversion (VSDB -> SSDT)

Artifact Conversion/Preservation

SQL Server Data Tools provides a conversion option if you would like to bring your legacy Visual Studio 2010 Database Projects into the SSDT project system. Due to inherent differences in the two project systems and goals thereof, the conversion process is not 1:1 in all cases. The chart below is quick guide to artifact preservation on project conversion. For more detailed information regarding common conversion issues and their workaround, please see the “Top VSDB->SSDT Project Conversion Issues” blog post.

 

image