Whar are the step need to follow for SQL Server 2005 to 2008 migration mainly SSIS packages?
Posted on 2008-10-17
In my client place they plan to migrate SQL Server 2005 enterprise version (64 bit) to SQL Server 2008 Enterprise edition (64 bit). (Clean installation not upgrades).
Mostly we are using SQL Server SSIS for ETL tool. We created many SSIS package Job and Schedule it to run every day. I know all the job details are stored in msdb database.And we are taking user and msdb, master and model database backup every day.
1. Can you please clarify me what are the steps I need to take for this migration?
2. Can I restore 2005 user database in SQL 2008. Let me know the practical problems while restoring in 2008.
3. How to restore system database like msdb, master and model. Or do I need to take all job script and run in 2008. If it is so again I have to deploy the packages in SQL 2008.
Please share your migration experience and practical issues.
Thanks in advance.