George P. Alexander Jr. (Software Engineer) posted 9/18/2008 | Comments (0)
I've been asked a couple of times whether it's risky to upgrade from SQL Server 2000/2005 to SQL Server 2008 or just go for a fresh install
Well, my SQL Server 2009 RTM install was not exactly a peaceful one. I had to uninstall my instance of SQL Server 2005 Express Edition to finally have SQL Server 2008 RTM working.
From a home user's point of view such as myself who mainly installs for exploring as a developer, I think it's not a big issue. Though I haven't seen any upgrades being done, I've seen many SQL Server 2000 databases move over to SQL Server 2005 environments without any issues either.
I'm sure that from a DBA's point of view within a corporate environment, an extensive understanding and analysis will be required together with the application development team as this would have to be handled in a case by case basis. Further, SQL Server 2008 is still in RTM and corporates would be cautious till SP1 is out.
I've been asked a couple of times whether it's risky to upgrade from SQL Server 2000/2005 to SQL Server 2008 or just go for a fresh install
Well, my SQL Server 2009 RTM install was not exactly a peaceful one. I had to uninstall my instance of SQL Server 2005 Express Edition to finally have SQL Server 2008 RTM working.
From a home user's point of view such as myself who mainly installs for exploring as a developer, I think it's not a big issue. Though I haven't seen any upgrades being done, I've seen many SQL Server 2000 databases move over to SQL Server 2005 environments without any issues either.
I'm sure that from a DBA's point of view within a corporate environment, an extensive understanding and analysis will be required together with the application development team as this would have to be handled in a case by case basis. Further, SQL Server 2008 is still in RTM and corporates would be cautious till SP1 is out.
If you want to check for computability issues for upgrading from your older version of SQL Server to SQL Server 2008, there is a useful tool out there that you can download for free from the Scalability Experts. It tells you if you might have compatibility issues while trying to upgrade from SQL Server 2000 / SQL Server 2005 to SQL Server 2008. SQL Server Upgrade Assistant 2008 helps you automate a test against your SQL Server 2000 or 2005 instance for compatability with SQL Server 2008. It also verifies how queries will function after a database has been upgraded.
So if you are thinking of an upgrade from an older version of SQL Server to SQL Server 2008, you might want to run it through this tool which executes a number of test plans to make it easier for you to decide.
Though there may not be a sure shot answer, this tool should help you make the decision drastically though.
Until next time,
Happy programming!
So if you are thinking of an upgrade from an older version of SQL Server to SQL Server 2008, you might want to run it through this tool which executes a number of test plans to make it easier for you to decide.
Though there may not be a sure shot answer, this tool should help you make the decision drastically though.
Until next time,
Happy programming!
No comments:
Post a Comment