March 13, 2009 at 9:15 am
Hello
I have a SQL2000 Data Warehouse that is running on hardware that is close to failure. What I plan on doing is to redesign the DW to SQL2005, but do not have the time to wait until I have that done. So what I am thinking of doing is to migrate the SQL2000 DW to another SQL2000 server. My question is what is the best method for doing this?
I know that I will need to do the follwoing:
1. Backup and restore the DW databases to the new server.
2. Migrate all the users and groups for those databases.
3. Migrate the OLAP/Analysis Services to the new server.
4. Migrate the DTS packages
5. Configure new maintenance jobs for the database and migrate any jobs that runs any object against the DW.
Aside from those items listed above, is there anything that I am missing or should be concerned with? thanks
March 24, 2009 at 7:22 am
I am probably telling you stuff you alreasy know.
3. Migrate the OLAP/Analysis Services to the new server. The AS will need to be reporinted from the old database to the new.
4. Migrate the DTS packages. In addition any connections in these packages will need to be moved from the old database to the new. Storing this configuration in SQL server is a good idea.
Check the new server is as near to the old one in regards of OS and SQL version and the drives are the same ie if DTS is expecting drive G there needs to be a drive G on the new box.
Run in parallele and test and test and test some more.
Ells.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply