I has sql database in sql2000 I want move it to sql 2005What

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by BuckWoody » I has sql database in sql2000 I want move it...

I has sql database in sql2000 I want move it to sql 2005What

Rate Topic

Display Mode

Topic Options

Author

Message

apierre1

Posted Sunday, December 23, 2007 4:15 PM

Forum 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

ALZDBA

Posted Monday, December 24, 2007 12:17 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:17 AM
Points: 6,862, Visits: 8,049

- 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

     Jul 13

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

- 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" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #436099

« Prev Topic | Next Topic »

Permissions