private void hsBackup_Click(object sender, EventArgs e)
{
n = 0;
lvBackupMessage.Items.Clear();
EditToData();
string cns = ConnectionStrings.Instance().MakeConnectionString(_dbReg);
var bu = new BackupClass(cns);
var lf = new List <FirebirdSql.Data.Services.FbBackupFile>();
for (int i = 0; i < lvBackup.Items.Count; i++)
{
ListViewItem lvi = lvBackup.Items[i];
FirebirdSql.Data.Services.FbBackupFile bf = (FirebirdSql.Data.Services.FbBackupFile)lvi.Tag;
lf.Add(bf);
}
bu.SetFiles(lf.ToArray());
bu.Backup.ServiceOutput += Backup_ServiceOutput;
if (cbBackupIgnoreChecksum.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.IgnoreChecksums);
}
if (cbBackupDisableTriggers.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.NoDatabaseTriggers);
}
if (cbBackupMetatdataOnly.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.MetaDataOnly);
}
if (!cbBackupGarbageCollect.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.NoGarbageCollect);
}
if (!cbBackupTransportable.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.NonTransportable);
}
if (cbBackupOldDescriptions.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.OldDescriptions);
}
if (cbBackupConvert.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.Convert);
}
if (cbBackupLimbo.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.IgnoreLimbo);
}
if (cbBackupExpand.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbBackupFlags.Expand);
}
bu.Execute();
}
private void hsAddRestoreFile_Click(object sender, EventArgs e)
{
FirebirdSql.Data.Services.FbBackupFile bf = new FirebirdSql.Data.Services.FbBackupFile(txtRestoreLocation.Text);
bf.BackupLength = StaticFunctionsClass.ToIntDef(txtRestoreFileSize.Text.Trim(), 0);
string[] obarr = { bf.BackupFile, bf.BackupLength.ToString() };
ListViewItem lvi = new ListViewItem(obarr);
lvi.Tag = bf;
lvRestore.Items.Add(lvi);
}
private void hsRestore_Click(object sender, EventArgs e)
{
n = 0;
var ca = new ConnectionAttributes();
ca.Server = DBReg.Server;
//SE ca.Client = DRC.Client;
ca.DatabasePath = txtRestoreDetinationDatabasePath.Text;
ca.Password = DBReg.Password;
ca.User = DBReg.User;
ca.ConnectionType = DBReg.ConnectionType;
ca.CharSet = DBReg.CharSet;
ca.PacketSize = DBReg.PacketSize;
ca.Port = DBReg.Port;
string connstr = ConnectionStrings.Instance().MakeConnectionString(ca);
lvRestoreMessage.Items.Clear();
var bu = new RestoreClass(connstr);
bu.Restore.ServiceOutput += Restore_ServiceOutput;
var lf = new List <FirebirdSql.Data.Services.FbBackupFile>();
for (int i = 0; i < lvRestore.Items.Count; i++)
{
ListViewItem lvi = lvRestore.Items[i];
FirebirdSql.Data.Services.FbBackupFile bf = (FirebirdSql.Data.Services.FbBackupFile)lvi.Tag;
lf.Add(bf);
}
bu.SetFiles(lf.ToArray());
if (rbReplaceDatabase.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbRestoreFlags.Replace);
}
else
{
bu.AddOptions(FirebirdSql.Data.Services.FbRestoreFlags.Create);
}
if (cbRestoreNoIndices.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbRestoreFlags.DeactivateIndexes);
}
if (cbRestoreNoShadows.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbRestoreFlags.NoShadow);
}
if (cbRestoreInvidualCommit.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbRestoreFlags.IndividualCommit);
}
if (cbRestoreMetatdataOnly.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbRestoreFlags.MetaDataOnly);
}
if (cbRestoreNoVaildy.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbRestoreFlags.NoValidity);
}
if (cbRestoreUseAllSpace.Checked)
{
bu.AddOptions(FirebirdSql.Data.Services.FbRestoreFlags.UseAllSpace);
}
ConnectionPoolClass.Instance().CloseAllConnections();
if (ConnectionPoolClass.Instance().AktCON != null)
{
ConnectionPoolClass.Instance().AktCON.Close();
}
bu.Execute();
DbExplorerForm.Instance().MakeDatabaseTree(true);
}
