|
|
|
| Hi i am trying to migrate some user information from an old system to new WCS 5.6 system .The old system is not a WCS environment so that we have different user schema structure . I have written couple of SQL programs to generate CSV and convert them usin
g diff tools and using massload i am loading in WCS system . But still when i am trying to search the migrated users are not appearing .
I am uploading data in the following tables using massload
Memmber
Users
userreg
Addrbook
Address
Looks like i am missing some tables where i need to add data . And if this is not the best approach to migrate data then what is the best approach to migrate data in this situation .
| |
| vovidzan 2006-02-09, 6:03 pm |
| There are also userprof and userdemo tables that I had to populate when I was migrating user data. Also I had to run MigrateEncryptedInfo.bat after I populated tables.
| |
| Robert Brown 2006-02-10, 3:02 am |
| You should look into loading the user as a 'Registered Customer' for the
organization in MBRROLE and specify the user in the MBRREL table as
having a relationship with the Default Organization and the Root
Organization.
R
> Hi i am trying to migrate some user information from an old system to new WCS 5.6 system .The old system is not a WCS environment so that we have different user schema structure . I have written couple of SQL programs to generate CSV and convert them us
ing diff tools and using massload i am loading in WCS system . But still when i am trying to search the migrated users are not appearing .
> I am uploading data in the following tables using massload
> Memmber
> Users
> userreg
> Addrbook
> Address
> Looks like i am missing some tables where i need to add data . And if this is not the best approach to migrate data then what is the best approach to migrate data in this situation .
|
|
|
|