July 25, 2006 at 1:55 pm
Hello,
I need to take a copy of my sql 2005 db (which has a compatibility level of 2000) and restore it to a sql 2000 server. I have tried the export wizard, scripting the db and copying objects, and copying a db using SSIS. None of these options worked. The background here is that we purchased a vendor product which was certified to run on sql 2005 (which they later told us had to be set to sql 2000 compliant db) but the consultant who implemented and customized the application, only has sql 2000. I was able to take his 2000 db and easily restore to sql 2005, but it does not seem like I can go the other way. Now, anytime the vendor needs to make changes, he is out of synch with our db. Does anyone have any suggestions?
Thanks,
Frank
July 25, 2006 at 4:29 pm
Frank
I had to do it the old fashioned way utilizing import/export data method. Right click on database, select tasks, then select export. The rest is in the wizard. Good luck
Marvin
Marvin Dillard
Senior Consultant
Claraview Inc
July 27, 2006 at 7:20 am
Sql Server 2005 does not provide Backward Compitibility to 2000 version.
It's completely rewritten product.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
July 27, 2006 at 7:24 am
Thank you Sameer. Is there any work-arounds that you could suggest so that I could get the data (and all db objects) of the SQL 2005 and into SQL 2000?
Thanks
Frank
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply