July 30, 2003 at 1:07 pm
Problem: I am in a shop that is moving 75% of its applications to Oracle 9i. These applications are currently in production on a 250GB SQL Server (7.0). I would like to upgrade this to SQL 2000, however, I am getting pushed back with the "We are moving mainly to Oracle, why upgrade SQL Server."
I should note that the SQL Server will exist for at least 1 more year with its current workload (or greater).
I need to put together some selling points for upgrading from sql 7.0 to 2000 to convince management this is a needed upgrade. Anyone have any suggestions? Maybe any discussion threads or sites that touch on this topic?
Thanks in advance for feedback and suggestions.
ajroney
July 30, 2003 at 2:20 pm
If your current prod server is clustered, it is good to move to 2000. Also if the users doing any bulk insert operations, you must make them as DBO/DDL Admins/Sysadmins where as in 2000 there is separate role for the Bulk inserts. Also you can use the indexed views, with the help of instances you can also reduce the licensing cost by installing a named instances however it increase the hardware costs. Check the BOL there are many more
Shas3
July 31, 2003 at 3:58 am
You're in deep sh**. This is mainly about politics.
Unless there are some issues you can only solve with oracle, there is no reason to migrate. (guess not because now you have sql7)
Make a tco ($$$) for sql2000 for this project and compare it to the tco ($$$) for the same project with oracle.
Technology goes forward on both rdbms-ses.
To comparing sql2000 to sql7 check BOL for What's new. I know this doesn't say mutch, but experiances are good.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 31, 2003 at 7:45 am
Thanks to all for the feedback!
alzdba - some good feedback, and I agree there are definitely politics involved.
I should note that it has already been decided that our cheapest tco would be to host keep our internal applications (about 30% of our data) on SQL Server. Our customer and new development would happen on Oracle 9i. So anyway you slice it, we are a split shop. The SQL Server applications will be around for a minimum of 1 year (in my opinion it will be considerably longer!). So I still see benefit in upgrading to SQL 2000 (since I am 1 of the only SQL developers/dbas). It's just a matter of convincing some other folks that there is benefit.
Again, thanks for the feedback.
ajroney
July 31, 2003 at 7:47 am
Shas3 - I am curious. Our prodution SQL 7.0 server is clustered active/passive. Why do you say 2000 would be a good move for a clustered production server? Stability? Maintenance?
July 31, 2003 at 7:49 am
Another thought, does anyone have any good links to performance comparisons between 7.0 and 2000? We do mainly batch processing, and if SQL 2000 could perform better on bulk inserts, it would be a big selling point.
ajroney
July 31, 2003 at 8:05 am
I know this might be regarded as prejudiced source, but anyway :
- http://www.microsoft.com/sql/evaluation/compare/default.asp
- http://www.aw-bc.com/catalog/academic/product/0,4096,0201752832-TOC,00.html
- http://www.pinnaclepublishing.com/SQ/SQmag.nsf/0/73F96D35618BBF56852568D0007691CC
- http://www.benchmarkresources.com/?cat=3&Sel=Database
Edited by - alzdba on 07/31/2003 08:17:57 AM
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply