Finally installed. There was the SQL 2005 Express necessary before, but according to what I’ve read should work well with any SQL Server 2005 edition. After install we have the new branch of projects ready to use. Unluckily projects for SQL Server 2005 aren’t working well in the CTP3, so we are limited to the 2000 version. It’s fortunate that I’m just working on project with SQL 2000 database. Without needless reflection I’ve decided to test the new CTP in real life.
After loading the solution and removing current database project I’ve tried to add the new database project. Unfortunately it was a vain attempt as I’ve got "Incorrect syntax near: 'ENABLE_BROKER'" error message that crashed my dreams into pieces. Luckily after a short search on forum I’ve found the solution. Important is to set up default database in VS options to SQL Server Express. In my case it was the default instance and it was SQL Server 2000. What is most interesting, when I’ve tried to use the SQL Server 2005 instance (Developers Edition) I’ve got a message that this instance isn’t installed, weird.
After successful adding the project to the solution I’ve made database schema import. It locked VS for a dozen minutes and next few for source control update. After all of this I’ve got beautiful database error log. Most of them were about unrecognised "dbo." in function calls. In spite of my astonishment I’ve decide to deal with this issue later. Very positive impression gave me errors founded in stored procedures. Just before installing VSTSDBpro I’ve made slight changes in one of the tables, column name and type, and VSTSDBpro found this as an error. Nice. I will play more with this great tool tomorrow so you can expect more.
The Big Brother (Microsoft) recently published CTP of Visual Studio 2005 Team Edition for Database Professionals for download. According to the webpage this will be great tool for team work with database. It have such cool features like change control or automatic tests. Unfortunately, it works now only on SQL 2000, but for install require new version of SQL Express 2005 (with SP1 and additional tools). Weird. I'm just installing it so more will come.