December 4, 2008 at 8:47 pm
Hi Guys,
I'm building a test environment to upgrade SQL2000 to SQL2005, i read heaps of doco (most ending with 'good luck') and i've ran the SQL Server Upgrade Advisor and sorted out what needed to be done. But now i'm stuck because i can't find any doco on how to actually do the upgrade, do i run the setup on the SQL2005 CD or do i download a package ???
Any help would be greatly appreciated
Cheers 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
December 4, 2008 at 9:30 pm
Mr J (12/4/2008)
Hi Guys,I'm building a test environment to upgrade SQL2000 to SQL2005, i read heaps of doco (most ending with 'good luck') and i've ran the SQL Server Upgrade Advisor and sorted out what needed to be done. But now i'm stuck because i can't find any doco on how to actually do the upgrade, do i run the setup on the SQL2005 CD or do i download a package ???
Any help would be greatly appreciated
Cheers 🙂
run the CD setup through sql2005 CD
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
December 4, 2008 at 9:40 pm
Thats great, will that keep all the orginal instances too ??
Cheers
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
December 4, 2008 at 9:40 pm
[font="Verdana"]What kind of upgrade are you trying to do? In-place or Side-by-Side? If you are doing a Side-by-Side upgrade, the easiest way would be using the copy database wizard and copy the databases to their new home. Use, the SQL-DMO method if you need the SQL2000 databases online while the upgrade is happening. Microsoft has a technical reference manual for sql 2005 upgrade. If you can get it, that would be great.[/font]
December 4, 2008 at 9:51 pm
Mr J (12/4/2008)
Thats great, will that keep all the orginal instances too ??Cheers
Yes it will keep the previous instances but this depends on the setup settings, you can also provide a new instance name then.
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
December 4, 2008 at 9:57 pm
Basically the plan is to upgrade the production server to sql2005 from sql2000. It has tonnes of websites, dts, dtsx and other applications that connect to it so rather than creating a sql2005 instance we want to upgrade the sql2000(using local instance) to sql2005 so we dont have to got through all the connecting application and re-set them up.
Cheers 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
December 4, 2008 at 10:29 pm
Mr J (12/4/2008)
Thats great, will that keep all the orginal instances too ??Cheers
[font="Verdana"]
If you run the SQL2K5 setup on a box that has SQL2000 instance(s) on it, and choose to upgrade them that would be an inplace upgrade.
If you have verified everything with the upgrade advisor and if you are sure that none of your jobs, DTS packages and StoredProcedures have any deprecated features then; the upgrade will go smoothly and you might not have any problems. If you have a lot of webpages, DTS and other applications connecting to the database I would suggest, to test your applications and webpages properly before you make the decision to upgrade.
I think you can rename an instance of SQL Server 2005. Not, too sure.
HTH 🙂
Regards,
[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply