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 21    Older >>
 

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 | 131 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 | 1,963 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 | 118 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 | 3,987 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 | 3,987 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 | 3,987 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,960 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,069 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,549 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,090 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,366 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,369 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,445 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 | 104 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,898 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,393 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,254 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,607 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 | 122 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,059 reads
   Items 1 to 20 of 21    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)    
troubleshooting (1)    
versioning (1)    
visual studio (1)    
wbscript (1)