Updating primary key data type in Adobe Campaign | Community
Skip to main content
tusharvats
tusharvats
February 24, 2022
Solved

Updating primary key data type in Adobe Campaign

  • February 24, 2022
  • 3 replies
  • 1538 views

Hi All,

We are trying to update the data type of primary key from int to text for one of the custom schemas in AC. However, does this mean do we need to truncate the table to process this through or can we retain the data ?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SorenDP

Hi! We recently had to change the ID in all tables on our instance. Our approach was to create a new string type column and add the values there. After that we could change all the joins to that new data field, and lastly truncate only the "old" column

3 replies

S
SorenDPAccepted solution
Level 4
February 24, 2022

Hi! We recently had to change the ID in all tables on our instance. Our approach was to create a new string type column and add the values there. After that we could change all the joins to that new data field, and lastly truncate only the "old" column

Sukrity_Wadhwa
Community Manager
Sukrity_WadhwaCommunity Manager
Community Manager
March 3, 2022

Hi @tusharvats,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!

Sukrity Wadhwa
L
leraposo
September 12, 2022

Hi Tusharvats,

 

I hope you are doing well. I am experiencing a similar situation to yours.

However, I already changed the data type from the field "Adobe ID" which made me lose all the information regarding this field.

After realizing what we had done, we were able to generate a file with historical data using Pentaho. The idea was to create an "Update Workflow" and load this file into it.

However, we are getting several errors like the ones on the below picture. Would be able to help us? 🙂 

 

 

Terms & ConditionsAccessibility statement

Loading footer...