How to transfer DB created with SQL Server 2005 to 2000

[bborissov]

I know, I know, I look stupid, but...
I gracefully created one DB on my computer with SQL Management studio. Put all what I need in it and after I sit back to enjoy my work I realize that instead on SQL Server 2000 I created it on SQL Server 2005 instance. I changed compatibility level of this DB to 80 (SQL Server 2000) detached it and tryed w/o avail to attach it on SQL Server 2000. Tryed to Backup this DB with SQL MS and then restore it with EM, again w/o avail.
Is there any other way to move that DB to SQL Server 2000 w/o scripting and run the script in QA?
BTW no new features of SQL Server 2005 are used in this DB.

TIA

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[SQLDenis]

Nope, you are out of luck

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[bborissov]

Thank you

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[SQLDenis]

SSIS or DTS is your best bet

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[bborissov]

Thank you Denis. I asked because I imagine what would happen if I must go to some client computer, prepare data on my notebook and after I travel 500 km I realise that I've done this on SQL Server 2005 and the user has only MSDE instaled, no network etc. (all worst thinks you can imagine)
This would never happen of course but I must be prepared for everything like boyscout)
Thank you again.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[mrdenny]

Script out the objects, then use DTS or SSIS to transfter the data from SQL 2005 to SQL 2000.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[bborissov]

Thank you.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP