Does RG DLM Automation support MS SQL Projects/SSDT projects?

Sean_B

I can't find an indication of what type of projects Red Gate Source Control + DLM Automation supports.

Due to my companies DB infrastructure we really need a push from TFVC into DEV, TEST, STAGE, and PROD. RG from what I can see only offers support for TFVC pulls into Version Control via SSMS.

Can developers work just in VS and TFS VC and push changes out to all environments instead? It's not feasible for us to read from a Database into version control (too many hands in the databases right now).

MS Sql Server projects work well in this way, but I like the DLM automation tools from what I can see. I would like to use an SSDT/SQL Visual Studio project with DLM automation.

Is there support for that?

Sergio R

Hi Sean,

We recommend using SQL Source Control and DLM Automation with scripts folders created either by SQL Source Control or SQL Compare.

For your usage scenario I would recommend using ReadyRoll

For more information please see:

https://www.red-gate.com/products/sql-development/readyroll/

https://www.red-gate.com/products/sql-development/readyroll/resources/redgates-database-lifecycle-management-approaches-a-comparison

Thank you,