Add unique many<->many support in Mongo->SQL Migration
Can you please add an option to fully normalize a mongodb collection into several SQL tables without PK value repetition?
meaning for example movies collection:
title, country
James Bond 19 [USA,UK,Spain]
Avatar2 [USA]
into:
movies:
id, title
0 James Bond 19
1 Avatar 2
countries:
id country
0 USA
1 UK
2 Spain
moviecounries
movieid country_id
0 0
0 1
0 , 2
1 , 0
- currently migration will create two "USA" values with different country id which is redundant.
1
vote
Yoni Sade
shared this idea