VS 2008 Team Edition Database Professional

[GaryMazzone]

OK this might be a little of the norm here but here goes.

I have VS2005 Team Edition Database Professional installed on my laptop along with VS Team Edition Database Pro, not a problem so far. When I installed the VS2008 we were using SQL Server 2005 as your databases so when asked to the database for database projects I selected my SQL 2005 installation. Now we have moved some of your databases (all new projects) to SQL 2008. When I try and create a Database Schema compare I get an error on Field types (we decided to use Date data type for one field instead of DateTime). I have since installed SQL 2008 Express so that I can create the projects in the 2008 version of SQL Server.

No here is the question (sorry for being long winded here). How do I change the database that the projects are built in from SQL 2005 to the new SQL 2008 Express that I installed?


Hope someone has some idea here.

Thanks
Gary

[jmcilhinney]

I'm guessing that this is the right place because I haven't actually tried it:

Tools -> Options

Database Tools -> Data Connections -> SQL Server Instance Name

[GaryMazzone]

I already tried that. There must be something else that tells it where to go since it is still created in the 2005 instance.