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 t
o
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.

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]

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 i
s
> 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 support
s
> aggregation of data from multiple data sources but as i understand, this i
s
> not recommended though.  Furthermore, any ideas as well as to synchronizin
g
> 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.

[ Post a follow-up to this message ]