replication in SAP R/3 on SQL server

[Former Member]

hi,

We want to read of R/3 data for some legacy system. I know that there are many ways for this matter but is there any limitation for one-side replication of data in SAP R/3 to a middle ware database?

We use MS SQL server as R/3 RDBMS.

Thanks a lot in advance,

[Former Member]

I would not set up traditional replication on the SAP DB.

Instead, it would be better to setup either a DTS package (on SQL2000) or an Integration Services package (SQL2005) to collect the data via direct read query.

We have several 3rd party tools that we pull data directly from the DB for, but make sure user has read-only access to the data so that the developer who writes the code cannot make any changes by mistake.

[Former Member]

If both using MSSQL 2005, you can try log shipping