Results 1 to 2 of 2

Procedure To export and import IT policies, open a command prompt window on the Microsoft ... Server Admins forum

  1. #1
    hayden's Avatar
    hayden no está en línea Stack Mod
    Join Date
    Jul 2004
    PIN/ID
    ask
    Posts
    12,440

    How to export and import IT policies

    Advertisement



    Procedure

    To export and import IT policies, open a command prompt window on the Microsoft SQL Server and type the following commands:

    For BlackBerry Enterprise Server software version 3.6 and earlier:

    Export IT Policies
    bcp besmgmt..itpolicy out c:\itpolicy.txt -c -T -s SQLServername\SQLInstance
    bcp besmgmt..itpolicy2 out c:\itpolicy2.txt -c -T -s SQLServername\SQLInstance
    bcp besmgmt..itpolicytemplate out c:\itpolicytemplate.txt -c -T -s SQLServername\SQLInstance
    bcp besmgmt..itpolicytemplate2 out c:\itpolicytemplate2.txt -c -T -s SQLServername\SQLInstance
    Where besmgmt is the name of the database, c:\itpolicy.txt, c:\itpolicy2.txt. c:\itpolicytemplate.txt, and c:\itpolicytemplate2.txt are the names and locations of the exported files, and C:SQLServername\SQLInstance is the name of the Microsoft SQL Server instance hosting the database.
    Import IT Policies
    bcp besmgmt..itpolicy in c:\itpolicy.txt -c -T -s SQLServername\SQLInstance
    bcp besmgmt..itpolicy2 in c:\itpolicy2.txt -c -T -s SQLServername\SQLInstance
    bcp besmgmt..itpolicytemplate in c:\itpolicytemplate.txt -c -T -s SQLServername\SQLInstance
    bcp besmgmt..itpolicytemplate2 in c:\itpolicytemplate2.txt -c -T -s SQLServername\SQLInstance
    Where besmgmt is the name of the database, c:\itpolicy.txt, c:\itpolicy2.txt. c:\itpolicytemplate.txt, and c:\itpolicytemplate2.txt are the names and locations of the files containing the IT policy information that will be imported into the database, and C:SQLServername\SQLInstance is the name of the Microsoft SQL Server instance hosting the database.
    For BlackBerry Enterprise Server software versions 4.0:
    Export IT policies
    bcp besmgmt..itpolicy2 out c:\itpolicy2.txt -c -T -s SQLServername\SQLInstance
    bcp besmgmt..itpolicytemplate2 out c:\itpolicytemplate2.txt -c -T -s SQLServername\SQLInstance
    Where besmgmt is the name of the database, c:\itpolicy2.txt. and c:\itpolicytemplate2.txt are the names and locations of the exported files, and C:SQLServername\SQLInstance is the name of the Microsoft SQL Server instance hosting the database.
    Import IT policies
    bcp besmgmt..itpolicy2 in c:\itpolicy2.txt -c -T -s SQLServername\SQLInstance
    bcp besmgmt..itpolicytemplate2 in c:\itpolicytemplate2.txt -c -T -s SQLServername\SQLInstance
    Where besmgmt is the name of the database, c:\itpolicy2.txt and c:\itpolicytemplate2.txt are the names and locations of the files containing the IT policy information that will be imported into the database, and C:SQLServername\SQLInstance is the name of the Microsoft SQL Server instance hosting the database.
    For BlackBerry Enterprise Server software versions 4.1 and later:
    The BlackBerry Enterprise Server software version 4.1 does not allow the BCP Import and Export commands to pull data because the Microsoft SQL Server storing this data as text.

  2. #2
    CRansomSr's Avatar
    CRansomSr no está en línea Stack level 1
    Join Date
    Sep 2006
    Posts
    5

    Policy Export

    That's what I would like to do with 4.1.6 - just so I can pass it around to our security folks.

    I see these commands are for 3.6 - any for 4?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •