Honestly, I think at this point, your best bet would be to do a SQL backup of the clean Track-It! database or install Track-It! 2019 on a virtual machine and snapshot the fresh install, then try the migration. There are a lot of changes between Track-It! 11 and Track-It! 2019 and it sounds like you customized your Track-It! 11 purchasing module quite a bit so it is going to be difficult to predict what your data is going to look like after the migration without a lot of time and effort and analysis. It would be easier to snapshot a virtual machine and run a few migrations and see how the data turns out. I would recommend turning off as many items in the migration tool as possible and just focus on importing the purchase order data. Then you can see how it comes over and see where the data ends up, then move on by reverting your snapshot.
Understandable. Thanks for the tip!
1 of 1 people found this helpful
No worries. Wish I could help more but comparing data schemas is going to excruciating. Personally I think it’s easier to run the migration on a VM and then check if everything is where you need it when its complete.