Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag deployment Rss

Search for any content tagged deployment

   Items 1 to 20 of 20   
 

Is Rolling Back The Same as Failing?

When you must rollback a deployment of changes, is that a failure of the process? The development effort? Or something else?  Read more...
By Andy Warren 2014/03/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 137 reads

Five Tips to Get Your Organisation Releasing Software Frequently

The frequency of releasing software varies widely in the industry. If the test and release process is made as reliable and predictable as possible, then everyone gains. But how do you get started?   Read more...
By Additional Articles 2014/02/03 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,033 reads

SQLServerCentral Webinar #26: Best Practices in Database Deployment (Part 2)

Grant Fritchey (SQL Server MVP) and David Simner (Red Gate developer) give you a step-by-step guide of how you can automate your database deployment Process using Red Gate Deployment Manager.  Read more...
By Additional Articles 2013/09/04 | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 150 reads

SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST

Join Grant Fritchey (SQL Server MVP) as he tackles the most common problems and pitfalls of database deployment. He will explain how you (and your team) can make your deployment process, faster, more efficient and most importantly less stressful!  Read more...
By Press Release 2013/08/26 (first published: 2013/08/19) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,028 reads

SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST

Join Grant Fritchey (SQL Server MVP) as he tackles the most common problems and pitfalls of database deployment. He will explain how you (and your team) can make your deployment process, faster, more efficient and most importantly less stressful!  Read more...
By Press Release 2013/08/26 (first published: 2013/08/19) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,028 reads

SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST

Join Grant Fritchey (SQL Server MVP) as he tackles the most common problems and pitfalls of database deployment. He will explain how you (and your team) can make your deployment process, faster, more efficient and most importantly less stressful!  Read more...
By Press Release 2013/08/26 (first published: 2013/08/19) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,028 reads

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

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.  Read more...
By Additional Articles 2013/05/29 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 1,988 reads

Automating SQL Server Database Deployments: A Worked Example

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.  Read more...
By Additional Articles 2013/04/09 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 3,116 reads

Database Deployment Challenges

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.  Read more...
By Additional Articles 2013/03/18 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,583 reads

Database Deployment: The Bits - Versioning

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.  Read more...
By Additional Articles 2013/03/11 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,121 reads

An Incremental Database Development and Deployment Framework

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.  Read more...
By Additional Articles 2013/03/05 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 2,412 reads

Database Deployment: The Bits - Database Version Drift

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.  Read more...
By Additional Articles 2012/12/27 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,400 reads

Deployment Failures

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.  Read more...
By Steve Jones 2012/12/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Database Deployment Cribsheet

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.  Read more...
By Additional Articles 2012/12/14 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 1,920 reads

Database Deployment: The Bits - Copying Data Out

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.  Read more...
By Additional Articles 2012/12/07 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,420 reads

Database Deployment: The Bits - Getting Data In

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.  Read more...
By Additional Articles 2012/11/29 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,285 reads

Cleaning Up SQL Server Deployment Scripts

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.  Read more...
By Additional Articles 2012/09/03 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 1,626 reads

A Cast of Thousands

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.   Read more...
By Rodney Landrum 2011/08/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 123 reads

Automate the Publishing of Data Changes into DML Scripts

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.  Read more...
By Oscar D Garcia 2009/11/02 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 3,061 reads

Deploying Databases From Visual Studio Team System Database Edition

With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.  Read more...
By Grant Fritchey 2009/06/24 | Source: SQLServerCentral.com | Category: visual studio
Rating: |  Discuss |   Briefcase | 5,174 reads
   Items 1 to 20 of 20