April 6, 2011 at 5:22 pm
What is the better option to upgrade sql 2005 to sql 2008?
In place or clean installation?
Also if we have SSIS in 2005, will those still run on Sql 2008?
Thanks
April 6, 2011 at 5:54 pm
Better is sort of figurative. In my opinion the solutions go in this order from best down:
* New install on new server, migrate data test, then do a final data migration and switch over. (Especially if your current server is more than a couple years old.)
* Side-by-side upgrade on existing server, migrate data test, then do a final data migration and switch over.
* In-place upgrade. (only if you have tested everything on a very similar development system.)
If anything goes wrong in an in-place upgrade, it is a lot of work to roll-back. Having said that I have done a number of in-place upgrades and not had anything go wrong, but make sure you have good tested backups before you start.
As far as SSIS packages, they should be automatically upgraded and run. For any of these options you should run the upgrade advisor first to help identify anything that needs to be fixed either before or after the upgrade. (It won't identify everything, for instance we had some SSIS packages that we had to updated because they wouldn't run because of changes in how Windows Authentication worked with SQL Agent in 2008 R2 vs. 2005.)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply