dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteConnection Class / SQLCipherExport Method
Path to save the result encrypted database to.
The password to use for the encrypted database. Passing an empty string creates an unencrypted database.
Example

On this page
    SQLCipherExport Method
    On this page
    Creates an SQLCipher-encrypted copy of the current unencrypted database. You must have the SQLite3.dll library with SQLCipher extension in order to use this method.
    Syntax
    'Declaration
 
Public Sub SQLCipherExport( _
   ByVal destDatabaseFile As String, _
   ByVal destDatabasePassword As String _
) 
    public void SQLCipherExport( 
   string destDatabaseFile,
   string destDatabasePassword
)

    Parameters

    destDatabaseFile
    Path to save the result encrypted database to.
    destDatabasePassword
    The password to use for the encrypted database. Passing an empty string creates an unencrypted database.
    Remarks

    Note that after executing this method, the connection is still connected to the original unencrypted database. You need to manually reconnect to the result encrypted database if you want to work with it.

    To create an unencrypted copy of a SQLCipher-encrypted database, call this method for it with an empty password.

    Example
    This example opens an unencrypted database and creates a SQLCipher-encrypted copy with the password "11111" in the same folder. 
    using (var conn = new SQLiteConnection()) {

    conn.ConnectionString = @"Data Source=D:\databaseOld.db;Encryption = SQLCipher;";
    conn.Open();
    conn.SQLCipherExport(@"D:\databaseNew.db", "11111");
}
    Using conn = New SQLiteConnection()

        conn.ConnectionString = "Data Source=D:\databaseOld.db;Encryption = SQLCipher;"
        conn.Open()
        conn.SQLCipherExport("D:\databaseNew.db", "11111")
End Using
    See Also

    Reference

    SQLiteConnection Class
    SQLiteConnection Members
    Using SQLCipher

     

     

    © 2008 - 2026 Devart. All Rights Reserved.

    Send Feedback