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 |
|
devmathur
Starting Member
3 Posts |
 Posted - 2007-02-03 : 05:54:45
|
Hi allI need to migrate some databases from sql server 6.5 to sql server 2000.I have backup of database in .DMP format & .DAT format but I cant restore this backup in 2000 enviourment as it doesnt support this format of backup.Thanks in advance  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-03 : 06:58:20
|
| No. You have to restore in SQL Server 7 and do a new backup.Peter LarssonHelsingborg, Sweden |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-04 : 04:39:00
|
| Or, you can just script the DDL and export the data, and then create a new databasewith the help ofthe DDL and later import the data.Peter LarssonHelsingborg, Sweden |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-04 : 06:26:16
|
| You should read this from SQL Server 2000 Books Online:How To Upgrade from SQL Server 6.5http://msdn2.microsoft.com/en-us/library/aa197932(SQL.80).aspxCODO ERGO SUM |
|
|
|
|
|
|
Migrate Database from SQL 6.5 to SQL 2000