Content Comparison

...

1. Create a new Insights database (e.g. "dzreporting") next to the DAM database.
   Note: Make sure the Insights database has the same collation as the DAM database.
   
   
2. Create a new SQL server login (e.g. "insights").
   You can use any authentication you want (Windows/SQL), but it should have the following properties:
   1. Default database = "dzreporting" (database created in 1). Be sure to uncheck the "Enforce Password Policy, and select the DZreporting database under Default Database (changing it from master to DZreporting).
   2. Under User Mapping set  "db_owner, public" for the insights database, and "db_datareader" for the DAM database.
      
      
3. Unblock and unpack the database zip file into a local folder.
   
   
4. Edit the file "Digizuite.Insights.DbUpgrade.exe.config" with a text-editor and change to match your setup:
   1. ConnectionString (use credentials created in step 2). Remember to set the Initial Catalog = dzreporting.
   2. DAMDatabaseName (to be typed in under "value= ")
   3. (Best pratice) Remember to backup the database i.e. yourdatabasename_dam before prior to step 5.
5. Run the executable "Digizuite.Insights.DbUpgrade.exe" and inspect the output (optionally using the created 'log.txt').

...