Skip to Content
avatar image
Former Member

Partial copy of the Database

Hello!

I need to make a partial copy of the Database, as I do from the sap? or how can I make from oracle? if possible?

What we require is to make a copy of the configuration data SPROM and a copy two months ago of data

greetings!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 18, 2008 at 10:46 PM

    > I need to make a partial copy of the Database, as I do from the sap? or how can I make from oracle? if possible?

    What exactly do you mean by that?

    Do you want to copy single tables?

    > What we require is to make a copy of the configuration data SPROM and a copy two months ago of data

    Is SPROM a table?

    And what is "a copy two months ago of data"???

    Sorry, please rephrase your question, so that we know what you want to do.

    regards,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi!

      I need to export a portion of the database to another environment.

      I recommend using the transaction SCC8 through the parameter SAP_CUST / SAP_CUSV, do you think is the right thing?

      greetings

  • avatar image
    Former Member
    Sep 19, 2008 at 02:33 AM

    It's not possible for your requirements.

    For customizing table, you can import the related Trs into system.

    For "two months aga of data", you can restore the backup.

    Regards,

    Jack

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 19, 2008 at 06:22 AM

    ThereĀ“s a special product call "TDMS - Test Data Migration Server" which is able to copy only a certain amount of data.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 19, 2008 at 04:23 PM

    Edith,

    TDMS is a tool to copy Master and transactional data or a subset of them, typically from production to a non production system (QAS, training, Production Fix, Preproduction,...) in order to populate those system with "production-like data".

    TDMS will not transfer customizing and development.

    This tool avoid doing system refresh from production. This has many advantages I will not list here.

    But I am not sure it answer your question, because the

    "configuration data SPROM" : Usually, configuration data is moved from one system to an other by transport.

    "copy two months ago of data": I guess you are talking about Master and/or transactionnal data. For this only a product like TDMS can help you. Backup/Restore or system refresh will restore the whole system at a specific point in time. I am not sure it is what you are looking for.

    Best regards.

    Frank Markarian

    Principal consultant

    SAP America.

    Add comment
    10|10000 characters needed characters exceeded