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 |
|
alxtech
Yak Posting Veteran
66 Posts |
 Posted - 2007-04-27 : 09:19:50
|
| I am trying to copy a database from sql2000 to sql2005 but it is giving me the following error:To connect to this server you must use SQL Server Management studio or SQL server management objects (SMO)this can be done or servers are not compatible? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-04-27 : 09:22:53
|
| SQL 2000 Enterprise Manager is not compatible with SQL 2005. You would have to use either SQL Workbench, or bcp out all the data, and bcp it back in to the 2005 database. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-27 : 09:33:32
|
| You can run data import wizard in sql2k5 ssms to copy data from sql2k db. |
|
|
|
|
|
|
sql 2000 to 2005 data transfer