Step 2 - Database

Database Publishing

The database is provided in two flavors: dacpac and sql. I highly recommand you to use the dacpac as that's the easiest way to do the deployment.
Here are the steps, if you don't already know, to follow in SQL Server Management Studio to deploy a dacpac :
  1. Open SSMS (SQL Server Management Studio)
  2. Right click on the "Database" folder
  3. Select the "Deploy a Data-tier application..."
  4. Provide the path to the dacpac file
  5. Define the name of the database (DATABASE_NAME)
  6. Finish

More info about dacpac deployment: http://msdn.microsoft.com/en-us/library/ee210569.aspx

Database Security

Both SERVICE_USER and WEB_USER should have the roles "db_datareader" and "db_datawriter" on the quartz database.



Next page: Step 3 - Website
Previous page: Step 1 - Preparation

Last edited Nov 17, 2014 at 9:37 PM by Faz, version 3