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-02-27 : 12:01:57
|
| Prema writes "What are the steps required to convert/migrate databases from WindowsNT\Sqlserver 7 to Windows 2003 Standard Edition to Sql server 2005?Can we convert in one step or do we need to go through SQl server 2000? I mean Sql Server 7 --> Sql server 2000 --> Sqlserver 2005?" |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2006-03-01 : 11:34:10
|
| You can just do a restore on the 2005 server. The 7.0 DB backups restore with no problems. The DB will be running at a 7.0 Compatiblity Level though.Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
 |
|
|
|
|
|
Database migration between versions.