exporting SQL 2000 to SQL7 1

[gareth7]

What would be the easiest way to export a sql 2000 database to run on a SQL 7 server?

I run sql 2000 myself, but my client only has an sql 7 machine that they want to run a database off.

The other problem is that I won't have access to their server over a network connection, so need to find some way of putting it onto a CD.

Does anyone have any suggestions?

 

[nigelrivett]

Script the database structure then bcp out all the data into files.
Run the creattion script then bcp in all the data.

Better if the indexes and FKs are separate so can be applied after the data import.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.