Ways for Partial Qulaity Refresh?

[Former Member]

Hello Consultants,

We have SAP ECC dual stack environment in our landscape (DEV,QAS,PRD) with SQL Server 2005 database. We are planning for Quality refresh from production data but we want to refresh quality from specified period with production data.

Please suggest us the best SAP practices to achieve this scenario?

Thnaks in advance.

Regards

Suresh

[former_member206552 · Accepted solution]

Hi Suresh,

I create a doc a while ago with screen shots to do a TDMS Timeslice, there are still topics not covered by this like installing TDMS and loaing the notes etc.

http://scn.sap.com/docs/DOC-41808

Best Regards

Marius

[Rob3]

Hi Suresh,

In addition to the license fee, please consider that you will probably need an separate server to load the TDMS software to run on for performance reasons. TDMS is used successfully by many SAP customers and is a good alternative to full system copies.

The things to keep in mind; TDMS will probably take longer to populate the target client than a full system restore. There will be some load on the production instance during the read process (since they're reads, it should be light). If the TDMS process fails in before completion, it is likely that you will need to reset the process from the beginning.

TDMS is most beneficial in scenarios where you only need a subset of data to perform transaction testing (not performance testing) and you want to use a fraction of the computing resources of production.

Once the process is working appropriately, it is a straightforward procedure to keep your non-production system refreshed with production data and can become almost completely automated.

Thanks,
Rob

[Former Member]

Hi All,

Thank you all for prompt and informative help.

I have some questions

1.Where we can find TDMS software ?

2. Do we have to buy license for TDMS?

3. Do we need to install TDMS on both systems i.e. PRD and QAS?

4. Is there any alternative for TDMS?

Regards

Suresh

[former_member206552]

Hi Suresh

1) you download the DMIS packages and install the relevant ones for your system from SMP

http://scn.sap.com/community/test-data-migration-server/blog/2013/03/07/sap-tdms-40-sp04-is-availabl...

2) yes there are but i do not know the costs sorry but you can have a look at the following for guidance

http://sapbasisanswers.blogspot.de/2012/10/what-is-costpricing-of-sap-tdms.html

http://scn.sap.com/thread/1163876

3) yes you need to install these packages on all systems involved (SENDER, RECIEVER, CONTROLER)

4) yes there are you can have a look at the following link

https://scn.sap.com/people/ak.mahapatra2/blog/2012/03/12/comparisons-between-sap-tdms-vs-3rd-party-d...

Best Regards

Marius

[bxiv]

I would assume that there are some companies/vendors that will advertise alternatives for TDMS; the question to ask yourself is do you trust a non-SAP product to handle your data from one system to another?  SAP is going to know their database setups better than other vendors, just my 2 cents.

[Reagan]

Hello

Have a look here:

https://websmp208.sap-ag.de/tdms

https://websmp201.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000742922&_SCENARIO=011000358700000002...

You basically need to pay for the license and they charge you based on the size of the database.

The above PDF link will give you the answers to your questions.

Once you have paid for the license the refer to the Guides and Documentation section under the above link and make use of the guides provided there.

Regards

RB

[Reagan]

Hello

You can only achieve this with the help of TDMS and it is expensive.

Have a look at these links

http://help.sap.com/saptdm

http://help.sap.com/saptdm40

Regards

RB

[bxiv]

Have you looked into TDMS? 

http://scn.sap.com/community/test-data-migration-server