I’m playing around with SQL Server 2005 and the new management studio looks nice. It combines query analyzer and enterprise manager in a vs.net like environment. Great to have one tool instead of the two.
If you have used DTS packaces in SQL Server 2000 you need to download Microsoft SQL Server 2000 DTS Designer Components from Feature Pack for Microsoft SQL Server 2005 - November 2005. DTS has been majorly improved in 2005 - haven’t had a chance to look at it yet though. It is possible to migrate packages from 2000 to 2005 but it depends on the functions used in the package. The DTS designer is exactly like the one found in SQL server 2000.
Technorati: sql server 2005