dotConnect for SQLite Documentation
Devart.Common Namespace / DbDump Class
Members Example

DbDump Class
Serves to store a database or its parts as a script and also to restore database from the received script.
Syntax
'Declaration
 
Public MustInherit Class DbDump 
   Inherits System.ComponentModel.Component
   Implements System.ComponentModel.IComponentSystem.IDisposable 
 
Remarks
Abstract DbDump class implements some of DbDump functionality that is DBMS-independent.
Example
This sample demonstrates performing backup and restore operations.
public void DumpIt(SQLiteConnection conn)
{
        conn.Open();
        SQLiteDump sqSqlDump = new SQLiteDump();
        sqSqlDump.Connection = conn;
        sqSqlDump.IncludeDrop = true;
        sqSqlDump.Backup("d:\\dump.dmp");
        conn.Close();
}

public void UnDumpIt(SQLiteConnection conn)
{
        conn.Open();
        SQLiteDump sqSqlDump = new SQLiteDump();
        sqSqlDump.Connection = conn;
        sqSqlDump.Restore("d:\\dump.dmp");
        conn.Close();
}
Public Sub DumpIt(conn As SQLiteConnection)
        conn.Open()
        Dim sqSqlDump As New SQLiteDump()
        sqSqlDump.Connection = conn
        sqSqlDump.IncludeDrop = True
        sqSqlDump.Backup("d:\dump.dmp")
        conn.Close()
End Sub

Public Sub UnDumpIt(conn As SQLiteConnection)
        conn.Open()
        Dim sqSqlDump As New SQLiteDump()
        sqSqlDump.Connection = conn
        sqSqlDump.Restore("d:\dump.dmp")
        conn.Close()
End Sub
Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         Devart.Common.DbDump
            Devart.Data.SQLite.SQLiteDump

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also