How to handle SQL database deployment with Teamcity

Hi,

We are planning to use TC for our SQL database deployments. Please share steps/links.

3 comments
Comment actions Permalink

You can use command line task to execute sqlcmd. Inside the script you can enumerate scripts need to be executed and run all of them. I think this link will be useful - http://www.troyhunt.com/2011/02/automated-database-releases-with.html

In our team we builded custom Ruby script to enumerate queries.

Alex

0
Comment actions Permalink

Thanks Alex.

Can we handle SQL deployment without using Redgate Source control?

0
Comment actions Permalink

Shabina,

TeamCity does not manage these tasks our of the box, but allows you to execute any external tools and scripts as a part of a build.

Common development forums like StackOverflow can be better place to search for a such deployment solution.
Here is a couple of good related topics
http://stackoverflow.com/questions/6371/how-do-you-manage-databases-in-development-test-and-production
http://stackoverflow.com/questions/504909/database-deployment-strategies-sql-server

0

Please sign in to leave a comment.