Load Microsoft CRM Analytics Foundation Database Users with Redeployment Wizard
I am preparing a demo using Microsoft Dynamics CRM Analytics Foundation. The Analytics download package comes with a database backup files with users definitions in it. In order to use the CRM application after restoring the database from the back file, I am using the Redeployment Wizard, which allows mapping between the users in the database and the users in my domain controller. But, in order to do so, the users in the target domain should already be created.
There are 57 users in the CRM Analytics database that should be created, so I am using CSVDE in order to import them to my domain.
I executed the following query on the CRM Analytics database to get the users in the appropriate schema for using CSVDE (With my Organization unit and domain name):
'user' as objectClass,
SUBSTRING(DomainName, 11, 15) as sAMAccountName, '"CN='+FullName+',OU=English CRM,DC=VPCDOM,DC=com"' as DN
where DomainName <> ''
When I got the results from the query, I saved them as a .csv and used CSVDE, and only then, used Redeployment Wizard.