sql-server continuous-integration sql-server-data-tools redgate datadude

RedGate SQL tools v Microsoft Visual Studio Team System Database Edition (Data Dude)

I've been looking at RedGate's SQL tools and Microsofts Visual Studio Team System Database Edition (formerly Data Dude) for use within a testing and continuous integration environment.

What we need to be able to do is have:

Schema and Data under source control
Automated continuous integration using TeamCity (command line)
Push changes (and data) to environments (staging, production, test) but not from Visual Studio

What solution would best fit our needs and what are peoples opinions, views and experiences of both products. Which did/would you choose and why? Are there any alternatives that I have missed?

Solution

Have a look at this SO question Source Control tools for Visual Studio 2010 and SQL Server 2008 scripts and database updates?

SQL Server random selection
How to get a Table Object by table's name by sqlalchemy and query in it？
How to create a deterministic uniqueidentifier (GUID) from an integer value
ExecuteReader requires an open and available Connection. The connection's current state is Connecting
Why must some stored procedures in MSSQL be called with `master..` prepended while other can be called without it?
Insert sorted rows in another table using SQL
How to split a comma-separated value to columns
How to create a table from a pivot table?
Convert a binary representation of a number stored as VARCHAR to INT
What is the proper use of a clustered index?
How to wait for MSSQL in Docker Compose?
Resolving Poor Execution Plan in SQL Server with CLR Scalar Function
Connect python-polars to SQL server (no support currently)
T-SQL - stored procedure - "IF EXISTS" vs. "WHERE EXISTS"
SSISDB package errs out, says variable does not exist
error, string or binary data would be truncated when trying to insert
Missing libtdsodbc.so in freetds-dev - MSSQL on Ubuntu
Conditional update either column1 or column2 or column3
Why do I keep getting Incorrect usage of const UDF in SSMS?
Getting statistics on a temp table in SQL Server
Generating self-closing XML tags for lists in SQL Server
Where value in column containing comma delimited values
SQL Server error on update command - "A severe error occurred on the current command"
Invalid cast error on querying the database
Dynamic SSRS LInk
Table function in SQL Server with multiple parameters as an argument
Is it possible to add index to a temp table? And what's the difference between create #t and declare @t
How do I select the first row per group in an SQL Query?
How do I find a disabled index on SQL server 2008
SQL Server Object Explorer not showing a database