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 |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2008-01-24 : 16:53:43
|
| Hi,We are planning to transfer a database which is currently in 7 to a new server which is 2005. What is the best way to do this? Thanks,Rushdi |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-01-24 : 16:58:15
|
| good place to start:http://www.microsoft.com/sql/solutions/upgrade/default.mspx |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-24 : 17:25:40
|
| use backup/restore to move the database. you then need to change the compatibility level of the restored database on the sql2k5 box to 90. You may also need to migrate the logins from your SQL7 to SQL2k5. You can find a scrpt from microsoft called sp_help_revlogin that makes this step really easy.-ec |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-01-24 : 17:53:10
|
| You should also download and run the latest version of the SQL Server 2005 Upgrade Advisor to identify possible issues.CODO ERGO SUM |
|
|
|
|
|
|
Transferring a database from 7 to 2005