Skip to Content
author's profile photo Former Member
Former Member

SAP ContentServer export/import delta documents

Hi,

Would you be able to advise on this problem:

We had done an export/import of SAP Content Server DB from two servers to one using the loadercli utility, however, we had connection problems on the new server so we could not let users work on it immediately. So the users still continued in their old environments.

Now we want to extract the delta(newly created docs) from the old environment to the new server. I have

  1. created temp tables Components0008 and Documents0008.
  2. Run insert:

insert into sapr3.components0008 select NAME, LVALUE, SHORT_VALUE, LONG_VALUE, COMPDATEM, COMPTIMEM, CONTENTTYPE, COMPRESSED from sapr3.components0002 where DATEM like '%2016-10%'

insert into sapr3.documents0008 select NAME, LPROPERTY, SHORT_PROPERTY, LONG_PROPERTY, LVALUE, SHORT_VALUE, LONG_VALUE, DATEM, TIMEM, COMPRESSED from sapr3.documents0002 where DATEM like '%2016-10%'

  1. The copy of the delta only works for Documents0008, but for Component0008 it complains about too long columns.

Is there any other method we can use on this one, I would highly appreciate your advice.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 06, 2016 at 06:43 AM

    Hi Zolile,

    How the temp table components0008 was created?

    Did you try the similar command "create table components0008 as select * from components0002 where 1=2"?

    Best regards,
    James

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.