Creating a SQL Server patch package


This topic describes the procedure to create a SQL Server patch package.

Before you begin

Download the patches that you want to apply. The patch file must be a ZIP file (.zip) or an executable (.exe).

Note

BMC Database Automation (BDA) requires SQL Server 2008 service packs and hotfixes to be single-file installer applications. Microsoft occasionally distributes hotfixes in a password-protected self-extracting archive, requiring you to first unpack the hotfix before applying it. If you downloaded a hotfix from a link provided in an email from Microsoft, you must run the self-extracting executable and then enter the password specified in the email message. Doing so extracts a hotfix installer application and a readme file. Upload the installer application to BDA.

To create an SQL Server patch package

  1. From the Management Console main page, in the Context Frame, select Patching > Patch Repository.
  2. On the Patch Repository tab, click Create New Package.
  3. On the Package Configuration page, fill the following fields, and click Next.

  4. On the Package Settings page, fill the following fields, and click Next.

  5. On the Package Attributes page, fill the following fields, and click Next.

  6. On the Package Targets page, enter the values by moving the wanted items to the Selected box for each field, and click Next.

    Note

    To add to the list of available choices for the Target Operating Systems and Target Applications fields, see Adding-target-OS-and-applications-to-a-patch-package.

  7. On the Package Scripts page, fill the following fields, and click Next.

  8. On the Package Additional Files page, specify any additional files as follows, and click Next.
    Additional files can be added to a patch package. They can be added one at a time or as a prepackaged .zip file.

  9. On the Summary page, review the information.
    To make changes, do the following:
    1. Click Go to to return to the provisioning step that you want to edit.
    2. Make your changes.
    3. Click Save and Review to return to the Summary page.
  10. Click Create Package.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*