data extraction from SAP r/3 to sql 2000, bpc server

[#1]

Hi All,

I have posted a similar thread previously,, and understood how to transfer data from SAP R/3 to SQL 2005, but I need to transfer data from SAP R/3 to SQL 2000 server, not SQL 2005 server.

Any help will be greatly appreciated.

Regards,

Kranthi.

[Former Member]

ALL:

Pravin provides an excellent overview of your current options. I do, however, want to clarify ONE IMPORTANT point regarding BPC 5.X and SQL2000. While BPC 5.X is available to be installed on SQL2000, it is NOT a recommended practice at CUSTOMERS implementations. We have clearly seen that SQL2005 on a 64 bit Server for AS and the DB is an optimal BPC configuration for BPC 5.X. When building extration and SQL load processes, be advised that starting in SQL2000 using DTS will typically require re-writing of the DTS packages to the SSIS SQL2005 format to optimally perform.

If you have any questions regarding optimal settings, please contact SAP Support or Global Services.

Thanks.