Automated Database Deployment RRS feed

  • Question

  • Hi,

    I am working on automated database deployment. I have scripted all my database scripts and created a project and solution.

    If I want to implement the new environment from the script I can use msbuild/sqlpackage to apply the all my scripts into that environment.

    I just want to apply only changes into test/prod environment ie., changes like ALTER TABLE, ALTER PROCEDURE,ALTER VIEW to the test/prod environment.

    I am pretty well aware of Redgate SQL Source control explorer and don't want to use it. I looking for MS utilities which can do the same.



    -kccrga http://dbatrend.blogspot.com.au/

    • Edited by kccrga Wednesday, September 10, 2014 6:44 AM
    Wednesday, September 10, 2014 6:24 AM


All replies

  • Please check this link: https://www.simple-talk.com/sql/database-administration/automating-sql-server-database-deployments-a-worked-example/ .

    Hope it helps you!

    Wednesday, September 24, 2014 11:23 AM
  • I am worked on this topic for a while and found MS Build can perform everything that other external tools can do.

    MS Build is freeware and when we integrate it with Team city it does wonders!

    -kccrga http://dbatrend.blogspot.com.au/

    Sunday, October 12, 2014 11:54 PM