I was using SQL CI, the problem is you have to use a 'test' or 'intermediate database. As to my knowledge this is not completed. If so, please provide me with instructions/information on this.

Hi Jeff, you can do this with the new PowerShell cmdlets available in the DLM Automation Suite.

To do the update you would run the PowerShell:
$database = New-DlmDatabaseConnection -ServerInstance "<server>" -Database "<database>"
$tfsScriptsPath = "<path to scripts folder>"
Sync-DlmDatabaseSchema -Source $tfsScriptsPath -Database $database

If you would rather use a commandline call you can invoke powershell.exe with the above script like this:
powershell -Command {<script form above>}

For reference on the Sync cmdlet please check https://documentation.red-gate.com/display/SR1/Sync-DlmDatabaseSchema

Jeff - does that mean you're orchestrating the automation without the help of a CI/build tool?