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)
   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).
   2. DAMDatabaseName
      
      
5. Run the executable "Digizuite.Insights.DbUpgrade.exe" and inspect the output (optionally using the created 'log.txt').

...