Import from 2005 into 2000

Hi, we have a 2005 database which we want to export information from
back into a legacy 2000 database.
What is the best way to do this?
Thanks
CatherineOn Jan 29, 8:44=A0am, cather...@.myoddjobs.info wrote:
> Hi, we have a 2005 database which we want to export information from
> back into a legacy 2000 database.
> What is the best way to do this?
> Thanks
> Catherine
If the compatibility level is set to 2000 then I don't see any problem
here. you can use DTS and all...
Thanks
Ajay|||It depends. To transfer data only once it is easy to use the Export and
Import Wizard. To transfer data periodically you could create SSIS packages.
Or you can use SQL Server replication.
Hope this helps,
Ben Nevarez
"catherine@.myoddjobs.info" wrote:
> Hi, we have a 2005 database which we want to export information from
> back into a legacy 2000 database.
> What is the best way to do this?
> Thanks
> Catherine
>