How to handle SQL database deployment with Teamcity

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

Thanks Alex.

Can we handle SQL deployment without using Redgate Source control?

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