How to Import Profile Schema
When you import schema, you import the following into the Profiles Schema Manager from an XML file:
Data sources
Data source partitions (without user names and passwords)
Profile definitions
Site terms
When you import profile schema, it overwrites any existing profile schema.
To import profile schema
Expand Commerce Server Manager, expand Global Resources, expand Profiles (<computer name_datbase name>), right-click Profile Catalog, and then click Import Profile Schema.
In the Select a File dialog box, select the profile schema you want to import, and then click Open.
In the Import Profile Schema dialog box, expand the data source.
Click a partition, and then click Edit to edit the connection string for the selected profile schema.
In the Data Link Properties dialog box, in the Connection tab, enter a user name and password. You must enter a user name and password for each data source partition you want to import.
Click Test to make sure that the connection string works.
Repeat steps 4 through 6 until you have added user names and passwords for all the partitions you want to import.
Click Import to import the profile schema and data sources. Click Yes to import the data source partitions and overwrite the existing schema.
The profile schema is imported, overwriting the existing schema. For information about how to set up SQL Server partitions, see How to Create a Data Source for SQL Server. To add a new LDAPv3-compliant source, see How to Create a Data Source for Active Directory and Active Directory for Application Mode.