SQLServerCentral.com Articles tagged deployment

Database Deployment: The Bits - Agent Jobs and Other Server Objects

Wed, 29 May 2013 06:00:00 UT

Databases often need more than just the database objects to run. There may be certain server objects and components, and SQL Agent objects, that are required as well. For an automated deployment, these need to be identified and their build script placed in source control. They then need to be deployed via the pre, or post deployment script. Phil spells out how and why.

Automating SQL Server Database Deployments: A Worked Example

Tue, 09 Apr 2013 06:00:00 UT

Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it through three steps by writing T-SQL scripts, adjusting configuration files and the change log, before generating a full build script containing all schema objects.

Check SQL Server performance at a glance
We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

Database Deployment Challenges

Mon, 18 Mar 2013 06:00:00 UT

There are a number of challenges that make the deployment task more difficult. Alex reviews the common techniques for deploying new databases and upgrading existing ones, and their flaws, and argues the advantages of an automated, incremental, script-based approach to deployments.

Database Deployment: The Bits - Versioning

Mon, 11 Mar 2013 06:00:00 UT

Although databases have no inherent way of recording their version numbers, SQL Server provides the means of doing so, and much more besides. This is a great advantage to anyone faced with the task of deploying databases without errors.

An Incremental Database Development and Deployment Framework

Tue, 05 Mar 2013 07:00:00 UT

Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.

Database Deployment: The Bits - Database Version Drift

Thu, 27 Dec 2012 07:00:00 UT

When you are about to deploy a new version of a database by updating the current version, one of the essential pre-deployment checks is to make sure that the version in production is exactly what it should be. If changes have somehow slipped in, you'll need to understand them and deal with them before you can deploy.

Deployment Failures

Fri, 14 Dec 2012 07:00:00 UT

Today Steve Jones talks about deployment and how well it can work. He also asks about the problems from you and how easily it can fail.

Database Deployment Cribsheet

Fri, 14 Dec 2012 07:00:00 UT

As part of Simple-Talk's long-running Cribsheet series, they asked William Brewer to write a guide to deployment that described in general terms what is involved in the deployment of a database application, and the sort of issues you're likely to come up against.

Database Deployment: The Bits - Copying Data Out

Fri, 07 Dec 2012 07:00:00 UT

Occasionally, when deploying a database, you need to copy data out to file from all the tables in a database. Phil Factor shows how to do it, and illustrates its use by copying an entire database from one server to another.

Database Deployment: The Bits - Getting Data In

Thu, 29 Nov 2012 07:00:00 UT

Quite often, the database developer or tester is faced with having to load data into a newly created database. What could be simpler? Quite a lot of things, it seems.

Cleaning Up SQL Server Deployment Scripts

Mon, 03 Sep 2012 06:00:00 UT

Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema can, for valid reasons, contain other conflicting truths that can't easily be captured in source control. Dave Ballantyne explains the problems and suggests a solution.

A Cast of Thousands

Mon, 01 Aug 2011 06:00:00 UT

In a guest editorial, Rodney Landrum offers a light-hearted guide to role of each member of the cast in a typical SQL code deployment.

Automate the Publishing of Data Changes into DML Scripts

Mon, 02 Nov 2009 07:00:00 UT

For those of you still using SQL Server 2000, learn how to use SQL-DMO to create DML scripts to deploy new records or data changes to other servers. From Oscar Garcia.

Deploying Databases From Visual Studio Team System Database Edition

Wed, 24 Jun 2009 06:00:00 UT

With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.