CODEWITHSUNDEEP
visual-studio-2013sql-server-2008-r2sql-server-data-tools
JM Hicks
JM Hicks

Reputation: 1302

How to save a SQL Server Maintenance Plan within a Visual Studio Database Project

Having created a SQL Server maintenance plan in a SQL Server 2008 R2 instance, how can I import the definitions into a Visual Studio 2013 SSDT database project?

I don't mind using pre- and post-deployment scripts if that helps but I want it to be in a database project and to be able to build the project in VS and then to be able to deploy either a new instance of the plan, or to be able to synchronize an existing plan instance with the definitions in the database project. Also, drop and re-create is entirely acceptable.

Does anyone else already know how to do that ?

Upvotes: 2

Views: 722

Answers (1)

scar80
scar80

Reputation: 1702

First of all maintenance plans are not supported by SSDT.

You can export it manually as an xml template file and then try to write some sql/batch post deploy scripts to deploy it. You can find general instruction here (read comments also): https://robertbigec.wordpress.com/2013/10/03/automating-deployment-of-sql-server-maintenance-plans/

One note: The exported xml template contains some specific values such as server name or path to backup/log file locations. You might want to write custom script to get these values from target machine and replace it in the xml file.

Upvotes: 1

Related Questions