Hello,
We recently formed a consortium and are preparing to migrate data for two new two consortium members into our existing system. We need to address duplicates prior to the migration. We're on V11. How do I run AP_IDENTIFY_DUPLICATES in Test? Given the fact that we're a newly formed consortium, I'm proceeding with caution and would appreciate any suggestions other consortia might have for this process. I want to run the procedures in Test and be sure everything is in order prior to moving it to Live. I appreciate any guidance you may have for identifying duplicates and the merge process.
Thanks!
Shereen
Hi Shereen -
The duplicate identification procedure is simply a SQL procedure that most people have set up as a weekly job on their server. You can run it manually at any point either on your live or test server through SSMS (SQL Server Management Studio).
You didn't indicate whether you are the person who had access to SQL or not, but you'll need it. To run this procedure on your test server you'll simply want to open up a query window in SSMS attached to your test server and impresario database and run something like:
Exec AP_IDENTIFY_DUPLICATES @changed_since_days = XX, @identify_method1 = X, @identify_method2 = X, @identify_method3 = X - etc
Check out the online documentation for all the parameters:
http://www.tessituranetwork.com/Help_System/Content/Duplicate%20Management/Identify%20Duplicates%20Procedure.htm
HTH,
Heather
Thank you, Heather. Yes, I have access to SSMS.