What is the best way to convert a SQL Server 2000 database
to SQL Server 7?

You basically have to create a new 7.0 db and then import each of the
tables. I would start by using the scripting capabilities of EM and
scripting a new DB and be sure to check the checkbox labeled "Script only
7.0 features". Then you can use BCP or DTS to move the data over assuming
you don't have any 2000 specific stuff. Otherwise you need to deal with
those issue by issue.

--

Andrew J. Kelly
SQL Server MVP


"David Kreimer" <dkreimer (AT) kreimercomputing (DOT) com> wrote