Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I has sql database in sql2000 I want move it to sql 2005What Expand / Collapse
Author
Message
Posted Sunday, December 23, 2007 4:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 24, 2007 7:15 PM
Points: 1, Visits: 1
What is the way move a database from sql2000 to sql 2005!
Post #436058
Posted Monday, December 24, 2007 12:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 28, 2014 12:47 AM
Points: 7,005, Visits: 8,451
- IMO this post is placed in the wrong forum (discuss content posted by BockWoody ??)

- Start with MS SQL2005 upgrade advisor (analysis your sql2000 db)
- fix the problems it detects in your sql2000-db

- Keep in mind to test your applications when modifying the sql2000 db problems. They should be perform at sql2000 side !

- determind the path for migration :

* permare user id's to be migrated (especialy sqlusers)

* backup / restore
* detach / attatch

- DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY;
(and if it finds issues, fix thenm !)
- run full maintenance (rebuild index / sp_updatestats / dbcc updateuseage)

- determine when you are going to switch db_level to 90.
* and then switch it a the negotiated point in time.

- test your applications thoroughly !

Prepare DTS migration ... SSIS development may be your biggest issue !


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #436099
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse