I notice that Visual Studio 2010 database projects have a re-distributable component to support the deployment on end-user systems.
Will this component work against .Net 3.5, or does it require .Net 4.0?
A:
From what I can tell, Visual Studio 2010 database projects will require .Net 4.0 on the target machine. If you inspect the redistributable components in %ProgramFiles%\Microsoft Visual Studio 10.0\VSTSDB\Deploy using Reflector, you'll see that they all depend on version 4.0.0.0 of the framework libraries.
In addition to this, the .deploymanifest files (which are really MSBuild files in disguise) specify 4.0 as the MSBuild tools version.
It looks like you would need to use Visual Studio Team System 2008 Database Edtion GDR R2 (which of course requires VS 2008) if you want to target .Net 3.5 on the database server.
Samuel Jack
2010-07-22 16:12:15