March 22, 2011 at 8:01 pm
Dear All,
We are planning the migrate the data warehouse Db to SQL server 2008 shared server environment from SQL server 2005.
We are planning to migrate one DB along with SSAS,and SSIS packages
Can you please help in compiling the list of items we need to move and where we need to make the changes to code.
Thanks,
April 11, 2011 at 11:28 am
We have done that in the past and to be honest, there are a lot of things you have to do.
I do not remember the exact list of steps, but I will provide you with the ones I remember:
First, you have to keep in mind whether you are on a cluster environment or not, and if you have replication jobs on your server.
1) Build your new SQL Server, SSAS and SSIS with their configurations
2) Document all your report datasources if you are renaming the SQL and SSAS Servers.
3) Document all your packages and jobs to point to the new data sources.
4) Backup all your databases and restore them to the new server.
5) Script out all logins and create them on the new server.
6) Fix all orphan logins using sp_change_users_logins
7) Backup your OLAP databases and restore them.
8) Import all SSIS packages to the new environment.
9) Setup SQL Database mail, agent operators and agent proxies.
10) Import all jobs to the new environment.
11) Change all your data sources on your packages..if you are storing this in SSIS Configurations it should be very easy to do then.
12) Enable a trace to track any connections going to the old server(2005). This will help you determine what connections you need to change.
13) Test everything, packages, jobs, reports, cube processing, replication, etc.
Overall, you "MUST" document everything before you make any move.
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply