General

This is a database project. Be sure to check the project properties>Deploy>Settings for passwords prior to committing.

Ideally, you should develop using "My isolated development environment" for the build.
UseIsolatedDevEnvironment.jpg

Release

Presently we will release two files:
  1. SQL deployment script
  2. MS Sql Server mdb

Properties:
ReleaseDevSettings.jpg

SQL deployment script modifications

Modify the output so that it is possible to use generically:
CREATE DATABASE [EnviroDB] ON  PRIMARY 
( NAME = N'EnviroDB', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\EnviroDB.mdf' , SIZE = 57344KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'EnviroDB_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\EnviroDB_log.ldf' , SIZE = 470144KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

TO
CREATE DATABASE [EnviroDB] 

Last edited May 22, 2009 at 7:21 PM by valentinedwv, version 6

Comments

No comments yet.