January 5, 2006 at 12:50 pm
Hi,
I wonder how much we can use SQL Server 2000 tools for SQL Server 2005. It is very important in the environment where we have many of 2000 servers and just starting to install 2005 servers.
I found out that I can not register 2005 server in 2000 EM. I am able to connect to 2005 server from 2000 Query Analyzer and run at least SELECT query.
Does anyone know what we can or can not use and if there is a reference on that.
Yelena
Regards,Yelena Varsha
January 5, 2006 at 1:41 pm
I don't know if there is a reference or not, but I know Profiler doesn't work, either. You've got to use Profiler90, which comes with the SQL 2005 tools. Third party products are also rather limited on support, as I found out testing a particular product which detects SQL Server 2005 servers as SQL Server 7.0. In that product's defense, it's a free offering, and it hasn't hit the development cycle yet because the company is upgrading the rest of their tools (which have to be paid for).
K. Brian Kelley
@kbriankelley
January 5, 2006 at 1:44 pm
You need to go the other direction. The 2005 toolset is backwards compatible with 2000 with a few exceptions. You'll still need to use EM to manage permissions & modify DTS packages. There is a DTS component for the 2005 tools but it's "view-only". You can find the backwards compatability componenets for the 2005 clien tools here http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en
January 5, 2006 at 2:17 pm
Could we have both versions on the client? I did not try it myself yet.
One thing I found out is that 6.5 compatible databases can not be managed through Management Studio. Do not tell me I have to change the compatibility level. This particular database is for the app by third-party who was notified last year and who says they did not develop 2005 compatible version yet.
Regards,Yelena Varsha
January 5, 2006 at 2:22 pm
I've got both sets of client tools installed, if that's what you mean. There are a few things to consider, like checking your path and deciding whether the SQL Server 2000 or 2005 client tools should be hit first. Doesn't affect all tools, but it hits some of 'em with the same names between versions, like osql.
K. Brian Kelley
@kbriankelley
January 5, 2006 at 3:07 pm
Brian,
Can you have EM and Management Studio both open at the same time? I do understand that you say we can have both of them installed on the workstation.
The reson I am asking is because Management Studio was developed as a replacement of EM. Only Microsoft Developers know if there are similar singleton objects. They are like global variables-only one instance of singleton object may be on the computer at one time. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpatterns/html/DesSingleton.asp
for the real-life examples. Hopefully they should have separated the environments, because different libraries are used (SQL-DMO and SQL- SMO) but one can not be sure.
Regards,Yelena Varsha
January 5, 2006 at 3:15 pm
Yes, you can. As a matter of fact, I have 'em both open right now.
K. Brian Kelley
@kbriankelley
January 6, 2006 at 8:32 am
I am running multiple instances of 2000, and one instance of 2005, and both sets of client tools on my laptop with no issues.
Though 2005 client tools are mostly backwards compatible, you need addtional plugins to work with DTS, and you can not view 2000 database diagrams.
Terry
January 6, 2006 at 8:50 am
Thanks Brian and Terry!
Regards,Yelena Varsha
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply