SQL Server Performance Forum – Threads Archive
Upgrading from SQL 2000
Hi there, I am kinda new SQL 2005.Yesterday i was going through a tutorial for how to upgrade from sql 2000 to sql 2005 for one database at a time.In that i showed like we ran the upgrade wizard and selected the northwind database from sql 2000 to be upgraded to sql 2005.
My question is after upgrade where can i see my northwind database in same sql 2000 enterprise manager or in sql 2005 managment studio as 2005 have its own sample database.
I am kinda confuse, please advise Thanks
Danny
SQL 2005 do not have that sample database, as you have to reinstall MS downloads http://sqlserver-qa.net/blogs/tools…winds-databases-how-about-adventureworks.aspx fyi), in this case you will see them in SQL 2005 as it will be upgraded. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
You can’t connect to SQL SERVER 2005 using enterprise manager so you can’t see your upgraded sample database… but you can connect using Query Analyzer… It is better to use SQL Management Studio to connect and manage to sql 2005 databases…. I believe by default sql server 2005 will not install sample databases…
You can create them manually… SQL Server 2005 Samples and Sample Databases (February 2007)
http://www.microsoft.com/downloads/…f7-9f46-4312-af89-6ad8702e4e6e&displaylang=en
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Thanks alot for support! I have installed the sample database while installing the SQL Server 2005 by selecting the option for sample database. Thanks
Danny
Yes, you can use installation CD to install sample database but I believe it will not include new examples and data… Down loads will provide you the version released in 2/07….
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
True, although they are sample databases the latest downloads link would have the fixes with proper examples from Books online too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>