migration or Upgradation from sql 2000 to sql 2005

Question

migration or Upgradation from sql 2000 to sql 2005

sivark1

SSCrazy

Points: 2654
More actions
April 14, 2010 at 3:50 am

#156868

Hi Experts,
Currently we have a Sql server 2000 production Box Running Under
8.00.194RTMPersonal Edition on( window 2003 server o/s)with 15 Databases & Running 25 Scheduled backups Daily FULL, Transactional backups etc...
Now we r planning to go for Sql 2005 Enterprise Edition with Win server 2003 enterprise edition.
1)What r the best considerations to be taken before up gradation or migration
2)Please clarify diff Between up gradation & Migration
3) To move all the databases from sql 2000 to 2005?
4) Is it required to move System databases?
5) To move all the scheduled jobs .?
6) To move logins,users?
7) To move Linked servers etc...?
Finally i need to implement same old setup to new sql server 2005 Box
Please reply
Thanks in advance

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 233792 More actions · Answer 1

Hi

if you are currently using personal edition are you sure you need the massive leap to SQL Server 2005 Enterprise edition???

sivark1 (4/14/2010)
1)What r the best considerations to be taken before up gradation or migration

there is no such term as upgradation, you mean upgrade.

It may be a good idea to install the sql2005 upgrade advisor and see what that produces.

sivark1 (4/14/2010)
2)Please clarify diff Between up gradation & Migration

upgrade is exactly what it says, you are installing over the top of an existing system. You will not be able to do this as there is no upgrade path from sql2000 pe to sql2005 Ent Edition. Install a clean system and migrate your user databases across with any logins,etc required

sivark1 (4/14/2010)
4) Is it required to move System databases?

you cant move them

sivark1 (4/14/2010)
5) To move all the scheduled jobs .?
6) To move logins,users?
7) To move Linked servers etc...?
Finally i need to implement same old setup to new sql server 2005 Box
Please reply
Thanks in advance

script out any objects you wish to migrate and apply to the new server

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

sivark1 SSCrazy Points: 2654 More actions · Answer 2

Thank for reply

Any further valuable suggestions please.

Thanks in advance

Shabba SSCertifiable Points: 5007 More actions · Answer 3

I quite like the term 'upgradation'... we all knew what the original op was trying to say!

A quick search within SSC will produce numerous topics on the subject of upgrading SQL 2000 to 2005 & 2008.

Don't forget Google's your friend!

Cheers,

Mark

sivark1 SSCrazy Points: 2654 More actions · Answer 4

This task Now we r planning to go new server(DELL R410)for Sql 2005 Enterprise Edition with Win server 2003 enterprise edition.

so migration is not in the same server it on different new win server

Please suggest solutions to do this task

babolnart SSC Journeyman Points: 92 More actions · Answer 5

do a back up of the database on the old server..

restore the database on the new server...

http://babolnart.wordpress.com/

Shabba SSCertifiable Points: 5007 More actions · Answer 6

sivark1 (4/15/2010)
This task Now we r planning to go new server(DELL R410)for Sql 2005 Enterprise Edition with Win server 2003 enterprise edition.
so migration is not in the same server it on different new win server
Please suggest solutions to do this task

This doesn't change anything! Read again what Perry has said and digest, also checkout the numerous articles on this subject within SSC.

Shabba SSCertifiable Points: 5007 More actions · Answer 7

http://qa.sqlservercentral.com/Forums/Topic561114-146-1.aspx

This link will get you started !

Perry Whittle SSC Guru Points: 233792 More actions · Answer 8

Shabba (4/14/2010)
I quite like the term 'upgradation'... we all knew what the original op was trying to say!
A quick search within SSC will produce numerous topics on the subject of upgrading SQL 2000 to 2005 & 2008.
Don't forget Google's your friend!
Cheers,
Mark

thank you Mark 🙂

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Shabba SSCertifiable Points: 5007 More actions · Answer 9

Shabba

SSCertifiable

Points: 5007

April 16, 2010 at 6:58 am

#1152791

thank you Mark 🙂

You're very welcome Pezza!

Sunny1 SSC Eights! Points: 871 More actions · Answer 10

Consideration: You might want to consider to have the new server with Win 2008 R2 and SQL 2008. Since you have a new hardware, you have a back out plan already. You can test out all the upgrade and migration ahead of time.