Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

restore sql server 2005 db to sql 2000 db

Status
Not open for further replies.

DotNetGnat

Programmer
Mar 10, 2005
5,548
IN
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top