Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Advise on moving to SQL 2008

Author  Topic 

esnkumar
Starting Member

2 Posts

Posted - 2009-11-06 : 04:52:59
Our data warehousing systems are currently running in SQL Server 2005 technologies.
could you please share your ideas/experiences/expertise on the following queries regarding upgrading to SQL 2008.

* what are the benefits on moving to SQL 2008?
* How easy the migration is from SQL 2005?
* We have packages written in SSIS for ETL purpose, do they have to be recompiled?
* We have SSAS cubes written in SSAS 2005, will they work without any changes?

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-06 : 11:08:00
* performance, new features, resource governor, compression, ...
* it's simple from the database migration aspect (backup/restore or detach/attach)
* I don't know
* I don't know

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-06 : 18:21:47
* We have packages written in SSIS for ETL purpose, do they have to be recompiled?
can use the upgrade wizard, or recompile them
http://msdn.microsoft.com/en-us/library/cc280547.aspx

* We have SSAS cubes written in SSAS 2005, will they work without any changes?
may need to rebuild them in 2008

see these


http://msdn.microsoft.com/en-us/library/ms144256.aspx
http://msdn.microsoft.com/en-us/library/ms143742.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&DisplayLang=en

Go to Top of Page
   

- Advertisement -