We have a business partner that is still on SQL Server 2000, and we would like to replicate a couple databases to one of our SQL Server 2005 instances.
The business partner databases that we need to replicate from are only updated daily, so we could certainly use something like log shipping, if that is a possibility. Our databases that we replicate to will be read-only.
What options do we have in this heterogeneous environment?