Sreekanth Mohan

Sreekanth Mohan

  • NA
  • 902
  • 209.3k

MS Release management data release to multiple databases

Nov 23 2014 1:08 AM

I am using DACPAC deployer to deploy my DB schema using MS Release management and TFS build.I have some configuration tables and the data in these tables should be synchronized with each destination DBs. A data script file is added in my SSDT project. "Database Deployer- Execute script" component has been created in RM client to run the data script file. I need to run this script in different environment and the DB names are different. There are only 2 arguments for this component, the arguments are: -S ServerName -i "ScriptName" -b As DB names are different, i cannot go for "Use DBName;" along with the script. Questions:

  1. How i could manage this script to run on different Databases?
  2. Is there any other way to release data along with schema?