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 - 2003-02-14 : 07:30:34
|
| Paul writes "Is there any way I can restore a SQL Server 2000 database (i have a backup to hand) to a SQL Server 7 machine?Unfortunately the SQL2000 server is firewalled & secured down and i haven't figured out how to connect to/from another server using Enterprise Manager. So i think doing something with the backup file is looking like my only option - if thats possible?The only other way i can think of is to use a very complicated (well time consuming anyway) DTS package, one .xls output for each table (quite a few tables), copy over the .xls's, and another DTS on the SQL 7 server to put them in again. And then create a script to recreate all the sprocs.There must be a better way?" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-02-14 : 08:37:51
|
| Paul,you cannot restore a SQL Server 2K backup to a SQL Server 7 database, but you can use DTS to transfer your data.HTH |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-14 : 12:01:17
|
| I'm not sure why you would output the data into an Excel file, but my recommendation would be to output them to a text file using DTS of bcp. You would have to generate all of your schema, but that's fairly easy to do with the Generate SQL Script wizard. So just copy your schema and text files over, then import the data in. |
|
|
|
|
|
|
Restore to previous version (2k -> 7)