|
Home > Archive > Commerce Server Solution Sites > December 2004 > Help in importing and exporting data in profiles for the Starter S
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help in importing and exporting data in profiles for the Starter S
|
|
|
| Hello,
I am working on something where the information of the users of the site is
already existing in another database in another sql box. Now I would like to
migrate these info (about 300,000 users) to the database which the starter
site is using and assign each of them to a profile.
Any ideas on how to best migrate the data? i know commerce server supports
aggregation of data from multiple data sources but as i understand, this is
not recommended though. Furthermore, any ideas as well as to synchronizing
the updated data (if the user updates it) to the original data source?
Thanks so much! I really need help on this as the company i work for has
just started to implement commerce 2002.
| |
| Robert Bogue [MVP] 2004-12-14, 8:26 am |
| I'd probably prepare the table and then map Commerce Server to it so that
Commerce server uses that SQL table for profiles. You'll need to make sure
you have a GUID based join key but other than that the process is relatively
easy. It's just a matter of mapping fields to profile entries.
Rob
"jess" <jess@discussions.microsoft.com> wrote in message
news:83B342D0-0707-4600-8BB6-CE9CA62ECF33@microsoft.com...
> Hello,
>
> I am working on something where the information of the users of the site
> is
> already existing in another database in another sql box. Now I would like
> to
> migrate these info (about 300,000 users) to the database which the starter
> site is using and assign each of them to a profile.
>
> Any ideas on how to best migrate the data? i know commerce server
> supports
> aggregation of data from multiple data sources but as i understand, this
> is
> not recommended though. Furthermore, any ideas as well as to
> synchronizing
> the updated data (if the user updates it) to the original data source?
>
> Thanks so much! I really need help on this as the company i work for has
> just started to implement commerce 2002.
| |
| Ravi Shankar 2004-12-17, 7:49 am |
| Since it is a migration to Commerce Server, you'd be better off writing a
program that would use the ProfileContext object of Commerce Server and
create a user profile for every one of the 300,000 users in your existing DB.
In this program you could additionally create their address profiles also.
Before this you;d need to finalize on the profile structure (maybe even
tweak the existing user/address profiles) to suit your deployment
requirements.
Regards.
"jess" wrote:
> Hello,
>
> I am working on something where the information of the users of the site is
> already existing in another database in another sql box. Now I would like to
> migrate these info (about 300,000 users) to the database which the starter
> site is using and assign each of them to a profile.
>
> Any ideas on how to best migrate the data? i know commerce server supports
> aggregation of data from multiple data sources but as i understand, this is
> not recommended though. Furthermore, any ideas as well as to synchronizing
> the updated data (if the user updates it) to the original data source?
>
> Thanks so much! I really need help on this as the company i work for has
> just started to implement commerce 2002.
|
|
|
|
|