Skip to main content
Solved

Custom Data not migrated when using the migration tool


Roy V
Problem Solver
Forum|alt.badge.img+2
  • Problem Solver
  • 56 replies

Good morning

We used the migration tool to upgrade from 20.10 to the saas version.
In the comparison of records in the MDW we miss out on the custom data which we use to insert -1 and -2 records.

Old situation:
 

After migration:
 

 

This is very inconvenient as this requires adding all custom data once more.

Best answer by Christian Hauggaard

@Roy V a fix has been released for this now in 20.10.52

View original
Did this topic help you find an answer to your question?

10 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • May 22, 2024

Hi @Roy V 

It would seem like the custom data isn’t migrated.

If you manually add it again, does it get removed, or does it stay?


Roy V
Problem Solver
Forum|alt.badge.img+2
  • Author
  • Problem Solver
  • 56 replies
  • May 22, 2024

Hi Thomas,
I am adding them all manually again as that is the fastest solution for now (then it stays in the project).
Reason for this ticket is to let you know so maybe  the migration tool can be updated to take along the custom data for future migrations at other customers. 
Greetings, Roy
 


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • May 22, 2024

Hi @Roy V 

That is fair, I was just checking to see if there was more to it than that. Whether it is a deliberate limitation or a bug I don’t know, I will have to check internally.


Roy V
Problem Solver
Forum|alt.badge.img+2
  • Author
  • Problem Solver
  • 56 replies
  • May 22, 2024

Thanks. Have a nice day.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • May 23, 2024

Hi @Roy V 

When you did the migration did you use the copy data option?

Step 11 in the guide


Roy V
Problem Solver
Forum|alt.badge.img+2
  • Author
  • Problem Solver
  • 56 replies
  • May 23, 2024

Hi Thomas, no we did not, we created a copy of the azure database instead.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • May 24, 2024

Hi @Roy V 

It can be an issue with the schemas. Do you have a default schema on the data warehouse in LTS? When we convert a data warehouse from LTS to SaaS, we set up a default schema if one is not there, or if there is one with the same name, we rename it. If this is the case, they need to change the schema in the new database.


Roy V
Problem Solver
Forum|alt.badge.img+2
  • Author
  • Problem Solver
  • 56 replies
  • July 4, 2024

No we have are own schemas in that layer. For me the ticket can be closed as we entered the data manually again. Hope this is no issue for other customers. 


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 649 replies
  • July 5, 2024

Hi,

is this on the roadmap for fixing as this is used quite frequently?


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@Roy V a fix has been released for this now in 20.10.52


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings