Hi Dear all,
I doing database migration of my 2000 server to 2005, some what i have done sucessfully. But i stuck when i migrating my database from 2000 server to 2005. I want to migrate all database including dts packages, jobs, and all thats related to my database.
For doing migration i have gone through this steps,
1- Run upgrade advisor
2- Migrated DTS packages (completed)
3- Edit DTS packages in SSIS (completed)
4- Recreated Jobs (completed)
5- Database migration. (problem while doing the migration of database, not connecting to the source server, i also tried to copy database wizard, when it complete its showing one error of analysis services and log file its showing the adress of the databases, when i checked the destination folder there is no databases are present.)
If i wrong in this steps then please help me out. If u know steps how to do please help me. And please dont give me links because here some links are restricted, that will not open. So please send me the steps in this blocks only.
Thanks in advance.
Sorry for my bad english.
Learning is a path with no destination...