This must be a network folder that others in your team can access. Use TortoiseSVN to create a Subversion repository. You'll use the dedicated developer model, where each developer in your team will work on their own local copy of the database. For more information, see Database development models. Use SQL Source Control to link the WidgetDevelopment database to a shared Subversion (SVN) repository. We'll create these once we configure the test step.

Click Execute to create the WidgetDevelopment database.ĭon't worry about the warnings on missing objects.

Browse to the WidgetDevelopment.sql file and click Open.From the File menu, select Open > File.Open SQL Server Management Studio (SSMS). create a TeamCity project and link the development database to itĬreate the WidgetDevelopment database using the SQL script you extracted from the WidgetDevelopmentDatabaseCIDemo.zip file:.create the development database and use SQL Source Control to link it to version control.Install an Octopus Tentacle and assign the db-server role.See Install Octopus Deploy and create a new environment.

Install Octopus Deploy and create a new environment called Production.From the Redgate DLM Automation add-ons page, download the DLM Automation TeamCity plugin and copy to the TeamCity data directory plugin folder.This automatically installs a default build agent. Install JetBrains TeamCity version 7 or later. We've tested this example against version 9.1.1.Download the WidgetDevelopmentDatabaseCIDemo.zip file and extract the contents.If you want to run tSQLt tests against the database, you'll also need access to a SQL Server 2012 instance with common language runtime (CLR) integration enabled. For more information, see Enabling CLR integration (MSDN article). Install SQL Server Management Studio (SSMS) version 2005 or later.

If you can't do this, it's fine to install everything on one machine. We've described how to install tools on three different servers - development, build and deployment - which is a common configuration in the real world.

Download teamcity ci