February 10, 2009 at 10:41 am
We've been asked to take lead on some of the migration tasks from 2000 to 2005 as follows:
Identify / migrate all used tables to 2005.
Identify / migrate used views to 2005.
Identify / migrate used functions to 2005.
Identify / migrate used sprocs to 2005.
Identify / migrate user RS2005 reports to 2005 (along w/data sources, sprocs or queries).
Identify / migrate active DTS jobs to 2005.
My grand question: What are the best practices or steps that should be followed, and in what direction or sequence for a smooth, effective transition?
Any input from the experts will be welcome and definitely given some thought.
Regards,
John
February 10, 2009 at 10:46 am
Hi
Your plan looks good but you need to Check out the below links for smooth migration:
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1257496_mem1,00.html
Thanks
Vijaya Kadiyala
February 10, 2009 at 1:46 pm
Maybe I wasn't specific enough and I apologize, but our DBA has already done those tasks. I guess the tasks that I've been asked of are Data Analysis/Reporting related tasks, such as, identifying the RS2000 Reports that need to be migrated to SSRS2005. Any sprocs used by our RS2005 reports; functions; tables or views; DTS packages that need to be migrated to SSIS 2005. I could look at each report and log the datasource, sproc, etc that it uses and make sure all this gets migrated to 2005. I was just wondering if there was a more efficient way.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply