Search code examples
sql-servercontinuous-integrationsql-server-data-toolsredgatedatadude

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?