VS 2008 Team Edition Database Professional
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
Re: VS 2008 Team Edition Database Professional
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
Re: VS 2008 Team Edition Database Professional
I already tried that. There must be something else that tells it where to go since it is still created in the 2005 instance.