sql 2k or 2005

[mikeleahy]

hi
we have a server with sql 7 and one with sql 2000. i want to do a course in sql. a company here does them in sql 2000 and sql 2005. is it a waste of time doing sql 2000. can you still buy it?? will the exam in sql 2000 be available in the future??? im fairly new to sql so dont really whats happening wiht it.

 

[onpnt]

Microsoft always has the master plan to phase out older versions. Well, any software company will of course when newer technology comes out. In the coming of 2008 there will be many things not available that are in 2000 such as DTS so it is a good idea to keep updated.

However in all that and to answer your question properly will require knowing what your business and company is going to do in the future. If they intend to upgrade to SQL Server 2005 then I would say training courses on implementation and maintenance in 2005 would be a good idea. Most of these courses cover upgrading strategies.

If your company does not plan to invest in this type of upgrade then I would go with 2000 training. The courses will still be available for some time. 2005 is still relatively young so it will be some time before training on SQL Server 2000 is phased out.



[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[mikeleahy]

what about the MCDBA cert, is there any point in getting it

 

[mikeleahy]

we are not a big sql company, just a couple of databases that are important. our edi server is running sql 7. wud it b a better idea to upgrade this to swl 2000 or 2005??

 

[onpnt]

Yes. If you do it on your own without training camps that give you the answers and are only worried about you passing without actually learning anything.

A good path rate now if you have 2000 instances on your environment would be the MCDBA (in a timely manner) and then there is a upgrade to MCITP SQL Server 2005. This will give you plenty to be dangerous

I want to stress again though. Training camps IMHO have ruined the certifications. You learn nothing if you ask me. By the self paced books and do it on your own. You will get much more gratification out of these exams and earning the certifications I think. That is how it felt to me anyhow

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[onpnt]

Regarding your EDI back-end. It will depend on the EDI sotfware you are using and what that vendor supports. They may not support 2005 yet. If your EDI system is home brewed then it will be a easy answered question based on resources to upgrade.

My opinion I would go with 2005 as it is a vast improvement over 2000 in many respects.

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[onpnt]

Please do not take my comment on recommending upgrading to literally. You'll need to do a complete and full payback analysis for any type of situation like this before saying do it or not

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[mikeleahy]

yeah but my biggest database is sql 7 and has to be changed fairly soon. surely it would be better for change this to sql 2005 and not 2000

 

[onpnt]

Correct. If it is supported by the system. 9 times out of 10 it will be but I would not go further without validating that

We had a box with 22 DB's on it supplying data to several applications and the upgrade to 2005 has been slowed due to one of those databases and vendors not supporting 2005. It can happen.

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]