Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Database migration problem? Expand / Collapse
Posted Tuesday, December 2, 2008 12:58 AM


Group: General Forum Members
Last Login: Tuesday, May 5, 2015 2:01 AM
Points: 134, Visits: 574
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...

Post #611854
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse