Create the database - nrogoff/EnterpriseAppSettings GitHub Wiki

Create the Database

SQL Azure (and probably SQL 2012 onward)

  1. Connect to your Azure database server in SQL Management Studio or Visual Studio using your Server admin account or an account that has enough privaledges to create and manage a new database.
  2. Run the script \deployment\SQL Azure\CreateDatabase.sql at the context of the master database
    1. Make sure you have turned on SQLCMD mode.
  3. Connect to the new database
  4. Run the script \deployment\SQL Azure\CreateDatabaseSchema.sql

You should now have a structured database with a minimal data seeding.

  1. Now create a new Login for the WebApi to use. This account should have read and write privileges to this database only.