Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2011-05-23 : 12:46:05
|
| Hello,I have many database with million record in sql 2000, what is best choice for migration to 2008:1- attach database directly to 2008 2- create database in 2008 with script and import data from 2000 Early I attach an sql 2000 database to 2008 but database performance decrease mostly query speed.Regads,sasan. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-05-23 : 18:04:00
|
| I would never recommend detach/attach. If there is a problem with attaching a database you are stuck and out of options.. always backup & Restore.. After you restore, at the minimum(1) run SQL 2008 Upgrade Advisor, identify broken code/features(2) Backup from SQL 2000(3) Restore on the new SQL 2008 server (4) change compatibility mode to 100(5) fix any broken code(6) Rebuild all indexes(7) Update statsAlso search for SQL 2008 Upgrade Technical Reference guide with lots of details on upgrade/failback scenariosDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-24 : 01:37:28
|
| (8) Run CheckDB with the Data_purity option.--Gail ShawSQL Server MVP |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-05-24 : 18:17:42
|
| 1. If you don't have space then backup all database to netbackup and then detach from 2000 and attach to 2008. 2. If you have space the backup/restore is good. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sasan_vm
Yak Posting Veteran
51 Posts |
Posted - 2011-05-26 : 04:55:54
|
| Thanks allRegards,sasan. |
|
|
|
|
|
|
Migration from 2000 to 2008 ?