| Author |
Topic |
|
jane77515
Starting Member
6 Posts |
 Posted - 2006-11-06 : 03:12:24
|
| Hi, everyoneI have two question to ask after I migrate my DB 2000 to 2005.1. Do I need to correspondingly upgrade the enterprise Manager of the client? that is to say, Is that possible to connect a 2005 server using 2000 enterprise manager?2. what is different between SQL 2000 and SQL 2005? Is there some influence if our live server is 2005, but test server is 2000?I will appreciate if anyone else give some advice.Thank you! |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-06 : 03:26:27
|
quote:
Do I need to correspondingly upgrade the enterprise Manager of the client? that is to say, Is that possible to connect a 2005 server using 2000 enterprise manager?
SQL Server 2005 has the seperate mangement stdio called as Microsoft SQL Server Management Stdio (SSMS), which is installed when you install the client tools. No you can not connect to the SQL Server 2005 using EM of 2000. Throught QA yes you can connect to 2005. what is different between SQL 2000 and SQL 2005? Is there some influence if our live server is 2005, but test server is 2000? Read the following link and you will get some idea on it. http://msdn2.microsoft.com/en-us/library/ms189465.aspxChiraghttp://chirikworld.blogspot.com/ |
 |
|
|
jane77515
Starting Member
6 Posts |
Posted - 2006-11-06 : 03:40:07
|
Thank you for your reply.About the first question, yes, the SSMS will be installed in the same computer with 2005 by default. But there are many other people need connect 2005 server from their own computer. Now their computer is installed with EM of 2000.About the second question, I will read these material, hope can get some idea about that.quote:
Originally posted by chiragkhabaria
quote:
Do I need to correspondingly upgrade the enterprise Manager of the client? that is to say, Is that possible to connect a 2005 server using 2000 enterprise manager?
SQL Server 2005 has the seperate mangement stdio called as Microsoft SQL Server Management Stdio (SSMS), which is installed when you install the client tools. No you can not connect to the SQL Server 2005 using EM of 2000. Throught QA yes you can connect to 2005. what is different between SQL 2000 and SQL 2005? Is there some influence if our live server is 2005, but test server is 2000? Read the following link and you will get some idea on it. http://msdn2.microsoft.com/en-us/library/ms189465.aspxChiraghttp://chirikworld.blogspot.com/
|
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-06 : 04:02:27
|
| yes, then you have to install ssms on every computer again.. since its the client tool for sql server 2005Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
jane77515
Starting Member
6 Posts |
Posted - 2006-11-07 : 19:40:12
|
But our client also need to connect our SQL Server 2000, that is to say, out client need to connect both 2000 and 2005.Is that OK?The next week we will begin to migrate our DB.quote:
Originally posted by chiragkhabaria
yes, then you have to install ssms on every computer again.. since its the client tool for sql server 2005Chiraghttp://chirikworld.blogspot.com/
|
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-08 : 02:38:59
|
| i think using SSMS you can also connect to the SQL Server 2000 also..Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-16 : 23:02:00
|
quote:
Originally posted by chiragkhabaria
i think using SSMS you can also connect to the SQL Server 2000 also..
that's correct. SSMS can manage a 2000 instance.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-11-17 : 13:32:32
|
You can connect to a 2000 instance using SSMS. IF they have a 7.0 instance, it doesn't work (either 7.0 or 6.5....I can't remember what that crazy department is using  ). Just an fyi. The best thing to do would be to uninstall the 2000 tools completely and just leave the 2005 tools IMO. That way, you don't have as many users calling to complain about their 2000 tools not working. They will call. They'll even call multiple times.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
Migrate DB from SQL 2000 to SQL 2005