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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-20 : 09:09:55
|
| Sandeep writes "HI, Can u tell me how to migrate my existing database in Sql server 7 to sql server 2005 without upgrading my sql server instance.MEans i have to migrate my sql serevr 7 on one machine to sql server 2005 on other machine" |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2006-03-21 : 13:47:58
|
| You can use a number of methods to do this. 1. Backup your database on 7.0 instance and restore on SQL 20052. Detach the database on 7.0 instance and attach on SQL 20053. Stop SQL Server 7.0 and copy the .MDF, .NDF, and .LDF to SQL 2005 and attach4. Copy database wizard in SQL 2005You might need to use the copy logins wizard to get the logins out of master, or you will need to script them out. Good luck and report back which methods you try.JonHolding it down on the engineering tip, y'all!http://www.sqljunkies.com/weblog/outerjoin |
 |
|
|
|
|
|
SQL 2005