On of my project we switched from TDS to Unicorn. After we configured Unicorn and set up dependencies between configurations I wanted to verify that every item was migrated from TDS (
*.item) to Unicorn (
*.yml) in the database successfully.
I wanted to check by the following points:
- Is there any difference between field values?
- Detect missing items
- Detect missing field values
First I needed to setup one Sitecore instance for TDS (tds910) and one for Unicorn (unicorn910). I deployed (TDS) and syncronized (Unicorn) the items and then ran the following few scripts.
In most cases I needed to compare 2 tables –
VersionedFields. In your case maybe you need to also run the scripts above for
Detect difference between field values
I ignored the following fields to give me meaningful results:
- Updated by
- Created by
You can add more filters or remove these from the script below.
Detect missing items
This is quite obvious: I would like to have the list of items which are in TDS but not in Unicorn accidentally.
Detect missing field values
This one also quite obvious: I would like to have the list of field which are in TDS but not in Unicorn accidentally.
If you would switch from Unicorn to TDS, you can use the same scripts, you just need to change the table and alias names in scripts above. I hope it helps a bit! If you have any question or remark let me know!