How to move SQL 2000 db back to SQL 7

[pdalberth]

We have some SQL Server 2000 databases (5 databases totalling about 7 GBs)
that we want to return to version 7. The detach/attach method of moving
databases will not work as SQL 7 will not attach the SQL 2000 files.
Similarly, I can't restore in the SQL 7 environment a backup made in the SQL
2000 environment.

Is our only option to DTS the data from our 2000 databases back to version 7?

Thanks in advance for any help.

- Paul D.

 

[fluteplr]

Either DTS or bulk dump/load
DTS is probably the easiest

 

[jkb17]

I found the file and the scriptPkg.vbp is located under dtsdemo.exe. Right click it and the select the Extract to "folder" option.

hope this helps.