Technorati Tags:
SQL 2005,
SQL 2000I recently had to do this, and had to scratch my head a bit.
Anyway here is the path I took
- I created an empty db in sql 2000
- Generated a create db script for the sql 2005 db using management studio (Right click on DB > Tasks > Generate Script), including all objects in the selected db. There is also an option in this wizard: Script for Server version, which I set to SQL 2000
- Ran the script on the sql 2000 db to create the empty database
- Used SQL Data Compare from Red gate to copy the data across (guess I could have used SQL Compare from red-gate instead of step 2 and 3 also). Other products are available (some free) that could also have done this step.
HTH
Cheers
Ian