Microsoft® SQL Server 2012 Unleashed

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 ...