SQL Server Data Tools CTP4 vs. VS2010 Database Projects

SQL Server Data Tools CTP4 vs. VS2010 Database Projects

Rate This
  • Comments 4

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 

Leave a Comment
  • Please add 7 and 4 and type the answer here:
  • Post
  • Will those functions missing from SSDT be added in the future?

  • I am with J.W.: Which of the missing features, if any, are going to be implemented by the final version? Especially Data Compare, Unit Testing and Data Generation seem to be big major missing features.

  • @J.W / @Speedbird,

    As shown here and stated on our FAQ page, several parts of the VSDB feature set will be absent from SSDT's initial release, but the plan is to integrate these features (in particular those mentioned by Speedbird) as quickly as possible into SSDT in future releases. Over time, SSDT will subsume the existing Visual Studio SQL Server Database project features.

  • As far as I know VSDB is a different team.

    While SSDT is trying to get on par with VSDB, wouldn't VSDB keep moving ahead?

    Or is there a reorg, where SSDT is the pet project of whoever is in power?

Page 1 of 1 (4 items)