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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2008-01-17 : 09:28:10
|
| Hi,I have a server that has sql server 2000 standard edition, and I just got a new server but this time I'm going to use sql2005 Express (free version).My databases are not 2gigs in size, so I should be fine.What is the best method for me to convert the databases? Is it to just detach the database and re-attach in sql2.5? |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2008-01-17 : 14:08:04
|
| no tips? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-17 : 14:12:20
|
| Use backup\Restore then. |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-01-18 : 05:21:04
|
| Try Dettach and Attach.RKNAIR |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-01-18 : 05:21:51
|
| Also dont forget to change the compatability level to 90.RKNAIR |
|
|
|
|
|
|
Need to migrate a sql2k server to sql2005