Importing and Exporting Policies
In some situations a DBA might want to export one or many policies with their conditions from one or many SQL Server systems and import them to another SQL Server instance or system. Fortunately, you can perform this task easily with an export and import wizard that generates or reads the policy definitions as XML files.
Follow these steps to export a policy with SQL Server Management Studio:
1. In Object Explorer, expand the Management folder, expand the Policy Management node, and then expand the Policies folder.
2. Within the Policies folder, right-click a desired policy to export and then select Export Policy.
3. In the Export Policy dialog, specify a name and path for the policy and click Save.
Importing ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
