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

Content with tag deployment Rss

   Items 1 to 20 of 22    Older >>
 

Database Deployment Problems Survey

Red Gate is looking to build tools and features to help reduce the risk of database deployment. In order to achieve this, we need to get a better understanding of the most common deployment problems you are encountering when moving changes from development to production. Please help by filling in our two-page survey.  Read more...
By Additional Articles 2014/10/14 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 6,228 reads

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 | 138 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,059 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 | 191 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,065 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,065 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,065 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 | 2,003 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,139 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,602 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,151 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,450 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,417 reads

Query all objects created or modified after specified date

This script will query across all databases, returning a result of objects recently created or modified.  Read more...
By Eric Russell 2012/12/21 | Source: SQLServerCentral.com | Category: objects
Rating: |  Discuss |   Briefcase | 1,520 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 | 108 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,941 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,433 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,305 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,640 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 | 124 reads
   Items 1 to 20 of 22    Older >>
 
Tags
editorial (3)    
automation (2)    
source control (2)    
webinar (2)    
build (1)    
code management (1)    
database weekly (1)    
deployment manager (1)    
deployment process (1)    
development (1)    
modified (1)    
objects (1)    
search (1)    
software development (1)    
sql-dmo (1)    
survey (1)    
troubleshooting (1)    
versioning (1)    
visual studio (1)    
wbscript (1)