Can anyone tell Stepwise procedure for enhance content migration ?

[Marco_Tosin]

I think that, in order to get a response from some experienced users in the community, this request needs to be much more detailed.
The way it is worded it is too general.

[HelesicPetr]

Hi @RS_10128209 

A general question can be answered just with general answer.

1. Plan what data are migrated

2. Create MAP of your  data in a old system and in a new system

3 Define what information should be migrated based on the map 

4. Define a way how the information are migrated 

5  Find or crate tool for migration

6 Test the migration on just small amount data

7 Test full migration

9 identify the problem data

10 solve problem data

11 plan the production migration.

I may forget some steps but generally this is good start

PetrH

[RS_10128209]

Hi @HelesicPetr Thanks for the reply.

I have performed all steps and loaded wtdocument into target but while loading Content of wtdocument using its throwing me a error query

SELECT staging.sequencenumber AS SEQUENCENUMBER ,staging.type AS CLASS FROM CONTENTMETADATA staging, CONTENTMETADATAWBMStatus st WHERE staging.migrated =0 AND staging.sequencenumber = st.sequencenumber AND st.POSTVERIFICATIONSTATUS IS NULL AND st.loadstatus = 'STARTED';

Everything is right but as its trying to fetch sequencenumber and type from CONTENTMETADATA and CONTENTMETADATAWBMStatus, Type is not available in CONTENTMETADATAWBMStatus then how it will pass the query?

[HelesicPetr · Accepted solution]

Hi @RS_10128209 

Maybe you use wrong type.

it is hard to say if you do not provide full log error.

PetrH

[RS_10128209]

I have used type in contentmetadata as 'wt.content.ApplicationData'