merging 2 database in 2 country
Posted: Fri Aug 17, 2007 12:46 am
Hi all,
Currently i doing a MLM system. Before that, this system is used in 2 country. Even though use same coding but different Database. Right now i need to merging it into a system and a database.
Currently the database is like that....
Same member id was used in 2 different country or Database.
Country A - mb_id 10001
Country B - mb_id 10001
As well as many other tables id was like that.
Before merging, i need a best way to merge it. Hope any experience expert to provide solution.
I have 2 option to do it.
Option 1
1. use country name to create table - like uk_member , my_member ..
2. different country keyin data will record to table depend on country.
3. when doing calculation, will get data from each country table.
Problem : need create many table, not very flexible
Option 2
1. add country field at each table.
2. country code will record to separate member from different country.
3, when doing calculation, only will get data from the related table.
Problem : many record in a table. need to change field type to matching different country member id.
need to edit data for merging.
Any best solution to merge it ??
Thank a lot for reply.
Currently i doing a MLM system. Before that, this system is used in 2 country. Even though use same coding but different Database. Right now i need to merging it into a system and a database.
Currently the database is like that....
Same member id was used in 2 different country or Database.
Country A - mb_id 10001
Country B - mb_id 10001
As well as many other tables id was like that.
Before merging, i need a best way to merge it. Hope any experience expert to provide solution.
I have 2 option to do it.
Option 1
1. use country name to create table - like uk_member , my_member ..
2. different country keyin data will record to table depend on country.
3. when doing calculation, will get data from each country table.
Problem : need create many table, not very flexible
Option 2
1. add country field at each table.
2. country code will record to separate member from different country.
3, when doing calculation, only will get data from the related table.
Problem : many record in a table. need to change field type to matching different country member id.
need to edit data for merging.
Any best solution to merge it ??
Thank a lot for reply.