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 |
|
mcnkevin
Starting Member
1 Post |
 Posted - 2008-05-21 : 14:19:08
|
| Hello, what is the easiest way to move a DB (tables and data) from SQL server 2000 to 2005. Ive been trying to export the DB tables from 2000 using Excel, yet i get "cannot expand named range" errors on several of the tables.Is excel the way to go? another way? Can i use backup/restore?Note: also moving from one machine to another.Thanks for any help. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-21 : 14:55:29
|
| Backup/Restore will be best option. You can search and find lots of post regarding this issue. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 15:14:15
|
| Excel is the worst way to go. It's going to be the slowest and hardest.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|
|
Moving DB from sql server 2000 to 2005