restore sql server 2005 db to sql 2000 db

[DotNetGnat]

Hi Guys,

I tried to restore sql server 2005 db to sql server 2000 db. But then realized that it is not possible. What other alternatives do i have to achieve this task.

Any suggestions. Thanks in advance.

-DNG

 

[SQLDenis]

DTS and or SSIS

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[DotNetGnat]

Denis,

Thanks for the reply...Can you point in the direction of any online resources that can give me more information on how to achieve this using DTS.

After searching on google for a while i found an article which asked to generate database scripts to create database schema and the to move the data to the sql 2000. But I ended getting lot of errors and the method wasnt successful enough.

Thanks

-DNG