Devart Forums

Code: Select all

using (var conn = new PgSqlConnection(connectionstring))
{
	conn.Open();

        var pgSqlDump = new PgSqlDump
        {
           Connection = conn
        };
        pgSqlDump.ObjectTypes |= PgSqlDumpObjects.Views;
        pgSqlDump.Backup(stream);

        conn.Close();
}

Code: Select all

using (var conn = new PgSqlConnection(connectionString))
{
	 conn.Open();

	var pgSqlDump = new PgSqlDump
	{
	   Connection = conn
	};
	pgSqlDump.Restore(fileName);

	conn.Close();
}

Code: Select all

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at Devart.Data.PostgreSql.PgSqlDataReader.f(Int32 A_0)
   at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
   at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
   at Devart.Common.DbCommandBase.ExecuteNonQuery()
   at Devart.Common.DbScript.ExecuteSqlStatement(SqlStatement sqlStatement, Boolean forceExecute)
   at Devart.Common.DbScript.a(SqlStatement A_0, Boolean A_1)
   at Devart.Common.DbScript.a(Boolean A_0, IDataReader& A_1)
   at Devart.Common.DbScript.Execute()
   at Devart.Data.PostgreSql.PgSqlDump.InternalRestore(TextReader reader)
   at Devart.Common.DbDump.b(String A_0)
   at Devart.Common.DbDump.Restore(String fileName)
   at PostgreSQLExpImp.MakeImport(String fileName, String database, String connectionString) in ...