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 |
|
pvr_prasad
Starting Member
5 Posts |
 Posted - 2002-06-10 : 05:10:26
|
| Hi! All,I have SDB files of SQL Server 4.0 on Win 3.1 Operating System. I just wanted to Migrate it to SQL Server 6.5 or 7.0 or 2000. I tried with SQL Server 7.0 Developer version. It is not accepting the file. Do I have to go for Enterprise version software or any tool available. If anybody have come accross this type of issue. Please give me reply to pvr_prasad@yahoo.com or pvr_prasad@hotmail.com.Thanks and Regardsprasad |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-06-10 : 10:32:17
|
| There is no direct upgrade path from SQL 4.0 to SQL 2000. I believe you will have to take it through the paces and upgrade from one version to the next. Depending on the size of the database, it might be faster to script the db and then try transfering the data to SQL 2000 via DTS or BCP.Jeff BanschbachConsultant, MCDBA |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-06-10 : 12:10:07
|
| Once you have it upgraded to 6.5 you can go directly to 2000. Depending on the size of your database(s), he's right, scripting might be your best option.JamesH. |
|
|
|
|
|
|
Migrating Data from SQL 4.0 to 6.5 or 7.0 or 2000