MasterKey.Import Method (String, String, String, Boolean)

Loads the database master key from the file that is located at the specified system path by using the specified passwords to decrypt and encrypt the master key, and with the option to force regeneration.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub Import ( _
    path As String, _
    decryptionPassword As String, _
    encryptionPassword As String, _
    forceRegeneration As Boolean _
)
'Usage
Dim instance As MasterKey 
Dim path As String 
Dim decryptionPassword As String 
Dim encryptionPassword As String 
Dim forceRegeneration As Boolean

instance.Import(path, decryptionPassword, _
    encryptionPassword, forceRegeneration)
public void Import(
    string path,
    string decryptionPassword,
    string encryptionPassword,
    bool forceRegeneration
)
public:
void Import(
    String^ path, 
    String^ decryptionPassword, 
    String^ encryptionPassword, 
    bool forceRegeneration
)
member Import : 
        path:string * 
        decryptionPassword:string * 
        encryptionPassword:string * 
        forceRegeneration:bool -> unit
public function Import(
    path : String, 
    decryptionPassword : String, 
    encryptionPassword : String, 
    forceRegeneration : boolean
)

Parameters

  • path
    Type: System.String
    A String value that specifies the system path location of the file to save the master key to.
  • decryptionPassword
    Type: System.String
    A String value that specifies the password with which to decrypt the master key.
  • encryptionPassword
    Type: System.String
    A String value that specifies the password with which to encrypt the master key.
  • forceRegeneration
    Type: System.Boolean
    A Boolean value that specifies whether to drop the items that cannot be successfully regenerated by using the old database master key password.If True, regeneration of the master key is forced, and all items that cannot be regenerated are dropped. Otherwise, False.

Examples

Calling Methods

See Also

Reference

MasterKey Class

Import Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Encryption Hierarchy

CREATE MASTER KEY (Transact-SQL)