November 6, 2009 at 2:29 am
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.
November 6, 2009 at 3:07 am
* How easy the migration is from SQL 2005?
The migration is not very complex. But it depends on your code and your packages and dependencies. Like the TRUNCATE_ONLY option of BACKUP command is not available any more
* We have packages written in SSIS for ETL purpose, do they have to be recompiled?
All your packages needs to be migrated using the migration wizard. There are many things that are deprecated in 2008. Some that I faced are listed below:
1. In SSIS script task can not use static functions through an object. Have to compulsory use the class.
2. The DTS properties (like Dts.variables) can not be used before the Main funcation. You can not initialize class members using any variable before Main.
* what are the benefits on moving to SQL 2008?
There are many benefits in terms of T-SQL, features, Storage. But it all depends on whether you wish to use those or not.
Check this link for T-SQL enhancements: http://www.sqlservercentral.com/articles/SQL+Server+2008/65539/
I am currently in process of migrating all our datamarts and SSIS packages to 2008. Above are some of the issues I faced during the process.
-Vikas Bindra
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply