From the CA DataMinder distribution media, copy the contents of the \support\UA_DDUP folder to any location on the machine that will host the Universal Adapter de‑duplication database.
To create the de-duplication database, tables and stored procedure, run the following command from the \support\UA_DDUP folder from a Windows command prompt:
ua_dbms <user> <password>
Where <user> and <password> parameters are the SQL Server de-duplication database user credentials. This will create the necessary tables.
Using the SQL Enterprise Manager, assign the DB_Owner privilege to the UA domain user for the UA_DDUP database. This privilege provides the UA domain user with sufficient access rights to the de‑duplication database.
