client copy issue.

[Former Member]

Hi All,

We have plan to make the duplicate of our production system to development system but the thing is only one client exist in our production system with more than 1 TB.

My doubt is whether we make DB Copy or just to perform the client copy from production to development system.

System details:

ECC 6.0, AIX 5 and Oracle 10g

Kindly suggest on this issue.

Regards,

PANU

[Former Member · Accepted solution]

Hi Panu,

When taking the size of the client into account, a db copy is much more efficient than a client copy.. On the other hand, you don't want to overwrite your development environment with a copy of production... Unless you would have currently the same status of your ABAP repository and dictionary in DEV and PRD, but that is not very likely.

For this situation the tool SAP TMDS would be very convenient. This tool provides the possibility to make a consistent sub-set of a production client to a test client.

Kind regards,

Mark

[Former Member]

Hi Panu,

Not sure what is the actual concern in your question. Are you concern about 1TB of client data. If so, the best way to go is do a database copy. Considering the size, client copy would not be a good idea. If you do a client copy remotely or export process, you need to have minimal activity on the Production System, which will not be the case as your DB/Client size more than 1TB and it is going to take a long time to finish. You will end up with data inconsistency in your development box.

As suggested you can also explore on using TDMS.

Regards,

Sanujit

[Former Member]

Hi Panu,

There are three options for your case:

1. DB copy is good and fast if you take the backup of version database of dev box (for repository object) before import.

2. Clinet copy by export/mport is also possible but time consuming (will take ~70 hours). As it is 1 TB, export size would be 100 GB (1/10th). Use SCC8 for export from source client, import into target client using STMS and then post processing by SCC7.

3. SAP TDMS (Test Data Migration Server) is new tool to do selective copy and refresh.

Thanks,

Subrata