I have downloaded project from this link
Restore SQL Server Backup Files into any database
it is working successfully on the local machine. It can select a backup file from the local machine and can restore it on the same machine.
But when we are selecting a backup from the local machine and trying to restore it in a remote machine, it is showing an file could not found and some 'smo' errors... why is it please help...
thanks in advance....
SOURCE CODE:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.IO;
namespace TestRestore
{
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.PictureBox pictureBox1;
private System.Windows.Forms.TextBox Password;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.TextBox UserName;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.RadioButton SQLServer;
private System.Windows.Forms.RadioButton Windows;
private System.Windows.Forms.TextBox Server;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.TextBox BackUpFile;
private System.Windows.Forms.Button BackUp;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.ComboBox DatabaseList;
private System.Windows.Forms.RadioButton NewDatabase;
private System.Windows.Forms.RadioButton ExistingDatabase;
private System.Windows.Forms.TextBox DataBasePath;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox DataBaseName;
private System.Windows.Forms.Button Path;
private System.Windows.Forms.Button RefreshDatabases;
private System.Windows.Forms.ProgressBar pbar;
private System.Windows.Forms.Panel SQLServerPanel;
private System.Windows.Forms.Panel FilePanel;
private System.Windows.Forms.Panel ProgressPanel;
private System.Windows.Forms.Panel WelcomePanel;
private System.Windows.Forms.Panel DestinationPanel;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.PictureBox pictureBox2;
private System.Windows.Forms.Button Finish;
private System.Windows.Forms.Button Next;
private System.Windows.Forms.Button Previous;
private System.Windows.Forms.Button Cancel;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.GroupBox groupBox2;
private System.Windows.Forms.Label label10;
private System.Windows.Forms.Panel FinishPanel;
private System.Windows.Forms.Label FinsihLabel;
private System.Windows.Forms.Label StatusLabel;
private System.Windows.Forms.Label label11;
private System.ComponentModel.Container components = null;
public Form1()
{
InitializeComponent();
}
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
this.pictureBox1 = new System.Windows.Forms.PictureBox();
this.Password = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.UserName = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.SQLServer = new System.Windows.Forms.RadioButton();
this.Windows = new System.Windows.Forms.RadioButton();
this.Server = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.BackUpFile = new System.Windows.Forms.TextBox();
this.BackUp = new System.Windows.Forms.Button();
this.label6 = new System.Windows.Forms.Label();
this.DatabaseList = new System.Windows.Forms.ComboBox();
this.NewDatabase = new System.Windows.Forms.RadioButton();
this.ExistingDatabase = new System.Windows.Forms.RadioButton();
this.DataBasePath = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.DataBaseName = new System.Windows.Forms.TextBox();
this.Path = new System.Windows.Forms.Button();
this.RefreshDatabases = new System.Windows.Forms.Button();
this.pbar = new System.Windows.Forms.ProgressBar();
this.StatusLabel = new System.Windows.Forms.Label();
this.SQLServerPanel = new System.Windows.Forms.Panel();
this.FilePanel = new System.Windows.Forms.Panel();
this.ProgressPanel = new System.Windows.Forms.Panel();
this.label11 = new System.Windows.Forms.Label();
this.WelcomePanel = new System.Windows.Forms.Panel();
this.label10 = new System.Windows.Forms.Label();
this.DestinationPanel = new System.Windows.Forms.Panel();
this.panel1 = new System.Windows.Forms.Panel();
this.pictureBox2 = new System.Windows.Forms.PictureBox();
this.label9 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.Finish = new System.Windows.Forms.Button();
this.Next = new System.Windows.Forms.Button();
this.Previous = new System.Windows.Forms.Button();
this.Cancel = new System.Windows.Forms.Button();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.FinishPanel = new System.Windows.Forms.Panel();
this.FinsihLabel = new System.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
this.SQLServerPanel.SuspendLayout();
this.FilePanel.SuspendLayout();
this.ProgressPanel.SuspendLayout();
this.WelcomePanel.SuspendLayout();
this.DestinationPanel.SuspendLayout();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.pictureBox2)).BeginInit();
this.FinishPanel.SuspendLayout();
this.SuspendLayout();
this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
this.pictureBox1.Location = new System.Drawing.Point(6, 29);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(32, 32);
this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.AutoSize;
this.pictureBox1.TabIndex = 20;
this.pictureBox1.TabStop = false;
this.Password.Enabled = false;
this.Password.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(178)));
this.Password.Location = new System.Drawing.Point(152, 192);
this.Password.Name = "Password";
this.Password.PasswordChar = '•';
this.Password.Size = new System.Drawing.Size(144, 21);
this.Password.TabIndex = 19;
this.label5.Enabled = false;
this.label5.Location = new System.Drawing.Point(56, 192);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(100, 23);
this.label5.TabIndex = 18;
this.label5.Text = "&Password:";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.UserName.Enabled = false;
this.UserName.Location = new System.Drawing.Point(152, 160);
this.UserName.Name = "UserName";
this.UserName.Size = new System.Drawing.Size(144, 20);
this.UserName.TabIndex = 17;
this.label4.Enabled = false;
this.label4.Location = new System.Drawing.Point(56, 160);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(100, 23);
this.label4.TabIndex = 16;
this.label4.Text = "&Login name:";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.SQLServer.Location = new System.Drawing.Point(24, 128);
this.SQLServer.Name = "SQLServer";
this.SQLServer.Size = new System.Drawing.Size(176, 24);
this.SQLServer.TabIndex = 15;
this.SQLServer.Text = "S&QL Server authentication";
this.Windows.Checked = true;
this.Windows.Location = new System.Drawing.Point(24, 96);
this.Windows.Name = "Windows";
this.Windows.Size = new System.Drawing.Size(160, 24);
this.Windows.TabIndex = 14;
this.Windows.TabStop = true;
this.Windows.Text = "&Windows authentication";
this.Server.Location = new System.Drawing.Point(112, 35);
this.Server.Name = "Server";
this.Server.Size = new System.Drawing.Size(184, 20);
this.Server.TabIndex = 13;
this.Server.Text = ".";
this.label3.Location = new System.Drawing.Point(40, 32);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(100, 23);
this.label3.TabIndex = 12;
this.label3.Text = "&SQL Server:";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.BackUpFile.Location = new System.Drawing.Point(24, 72);
this.BackUpFile.Name = "BackUpFile";
this.BackUpFile.Size = new System.Drawing.Size(256, 20);
this.BackUpFile.TabIndex = 22;
this.BackUp.Location = new System.Drawing.Point(288, 72);
this.BackUp.Name = "BackUp";
this.BackUp.Size = new System.Drawing.Size(24, 20);
this.BackUp.TabIndex = 23;
this.BackUp.Text = "...";
this.label6.Location = new System.Drawing.Point(8, 24);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(136, 23);
this.label6.TabIndex = 21;
this.label6.Text = "&Backup File Address:";
this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.DatabaseList.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.DatabaseList.Enabled = false;
this.DatabaseList.Location = new System.Drawing.Point(160, 34);
this.DatabaseList.Name = "DatabaseList";
this.DatabaseList.Size = new System.Drawing.Size(146, 21);
this.DatabaseList.TabIndex = 32;
this.NewDatabase.Checked = true;
this.NewDatabase.Location = new System.Drawing.Point(16, 64);
this.NewDatabase.Name = "NewDatabase";
this.NewDatabase.Size = new System.Drawing.Size(104, 24);
this.NewDatabase.TabIndex = 31;
this.NewDatabase.TabStop = true;
this.NewDatabase.Text = "&New Database";
this.ExistingDatabase.Location = new System.Drawing.Point(16, 32);
this.ExistingDatabase.Name = "ExistingDatabase";
this.ExistingDatabase.Size = new System.Drawing.Size(128, 24);
this.ExistingDatabase.TabIndex = 30;
this.ExistingDatabase.Text = "&Existing Database";
this.DataBasePath.Location = new System.Drawing.Point(160, 122);
this.DataBasePath.Name = "DataBasePath";
this.DataBasePath.Size = new System.Drawing.Size(144, 20);
this.DataBasePath.TabIndex = 27;
this.label2.Location = new System.Drawing.Point(56, 120);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(100, 23);
this.label2.TabIndex = 26;
this.label2.Text = "Database &path";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.label1.Location = new System.Drawing.Point(56, 88);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(100, 23);
this.label1.TabIndex = 24;
this.label1.Text = "&Database name:";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.DataBaseName.Location = new System.Drawing.Point(160, 90);
this.DataBaseName.Name = "DataBaseName";
this.DataBaseName.Size = new System.Drawing.Size(144, 20);
this.DataBaseName.TabIndex = 25;
this.Path.Location = new System.Drawing.Point(309, 123);
this.Path.Name = "Path";
this.Path.Size = new System.Drawing.Size(24, 20);
this.Path.TabIndex = 29;
this.Path.Text = "...";
this.RefreshDatabases.Enabled = false;
this.RefreshDatabases.Location = new System.Drawing.Point(309, 35);
this.RefreshDatabases.Name = "RefreshDatabases";
this.RefreshDatabases.Size = new System.Drawing.Size(24, 20);
this.RefreshDatabases.TabIndex = 28;
this.RefreshDatabases.Text = "...";
this.pbar.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.pbar.Location = new System.Drawing.Point(56, 104);
this.pbar.Name = "pbar";
this.pbar.Size = new System.Drawing.Size(352, 16);
this.pbar.TabIndex = 3;
this.StatusLabel.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.StatusLabel.Location = new System.Drawing.Point(16, 40);
this.StatusLabel.Name = "StatusLabel";
this.StatusLabel.Size = new System.Drawing.Size(424, 32);
this.StatusLabel.TabIndex = 2;
this.SQLServerPanel.Controls.Add(this.UserName);
this.SQLServerPanel.Controls.Add(this.Password);
this.SQLServerPanel.Controls.Add(this.Server);
this.SQLServerPanel.Controls.Add(this.label3);
this.SQLServerPanel.Controls.Add(this.Windows);
this.SQLServerPanel.Controls.Add(this.SQLServer);
this.SQLServerPanel.Controls.Add(this.label4);
this.SQLServerPanel.Controls.Add(this.label5);
this.SQLServerPanel.Controls.Add(this.pictureBox1);
this.SQLServerPanel.Location = new System.Drawing.Point(0, 80);
this.SQLServerPanel.Name = "SQLServerPanel";
this.SQLServerPanel.Size = new System.Drawing.Size(464, 264);
this.SQLServerPanel.TabIndex = 35;
this.FilePanel.Controls.Add(this.label6);
this.FilePanel.Controls.Add(this.BackUp);
this.FilePanel.Controls.Add(this.BackUpFile);
this.FilePanel.Location = new System.Drawing.Point(0, 80);
this.FilePanel.Name = "FilePanel";
this.FilePanel.Size = new System.Drawing.Size(464, 264);
this.FilePanel.TabIndex = 36;
this.ProgressPanel.Controls.Add(this.label11);
this.ProgressPanel.Controls.Add(this.pbar);
this.ProgressPanel.Controls.Add(this.StatusLabel);
this.ProgressPanel.Location = new System.Drawing.Point(0, 80);
this.ProgressPanel.Name = "ProgressPanel";
this.ProgressPanel.Size = new System.Drawing.Size(464, 264);
this.ProgressPanel.TabIndex = 37;
this.label11.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.label11.Location = new System.Drawing.Point(16, 16);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(160, 16);
this.label11.TabIndex = 4;
this.label11.Text = "Please wait...";
this.WelcomePanel.Controls.Add(this.label10);
this.WelcomePanel.Location = new System.Drawing.Point(0, 80);
this.WelcomePanel.Name = "WelcomePanel";
this.WelcomePanel.Size = new System.Drawing.Size(464, 264);
this.WelcomePanel.TabIndex = 38;
this.label10.Location = new System.Drawing.Point(8, 8);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(448, 88);
this.label10.TabIndex = 0;
this.label10.Text = "Welcome to MFT JET Restore wizard. This wizard helps you to restore SQL Server da" +
"tabases to any location.";
this.DestinationPanel.Controls.Add(this.RefreshDatabases);
this.DestinationPanel.Controls.Add(this.Path);
this.DestinationPanel.Controls.Add(this.DataBaseName);
this.DestinationPanel.Controls.Add(this.label1);
this.DestinationPanel.Controls.Add(this.label2);
this.DestinationPanel.Controls.Add(this.DataBasePath);
this.DestinationPanel.Controls.Add(this.ExistingDatabase);
this.DestinationPanel.Controls.Add(this.NewDatabase);
this.DestinationPanel.Controls.Add(this.DatabaseList);
this.DestinationPanel.Location = new System.Drawing.Point(0, 80);
this.DestinationPanel.Name = "DestinationPanel";
this.DestinationPanel.Size = new System.Drawing.Size(464, 264);
this.DestinationPanel.TabIndex = 39;
this.panel1.BackColor = System.Drawing.Color.White;
this.panel1.Controls.Add(this.pictureBox2);
this.panel1.Controls.Add(this.label9);
this.panel1.Controls.Add(this.label8);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(464, 80);
this.panel1.TabIndex = 40;
this.pictureBox2.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox2.Image")));
this.pictureBox2.Location = new System.Drawing.Point(384, 16);
this.pictureBox2.Name = "pictureBox2";
this.pictureBox2.Size = new System.Drawing.Size(48, 48);
this.pictureBox2.SizeMode = System.Windows.Forms.PictureBoxSizeMode.AutoSize;
this.pictureBox2.TabIndex = 2;
this.pictureBox2.TabStop = false;
this.label9.Location = new System.Drawing.Point(8, 40);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(368, 32);
this.label9.TabIndex = 1;
this.label8.Font = new System.Drawing.Font("Microsoft Sans Serif", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(178)));
this.label8.Location = new System.Drawing.Point(8, 8);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(176, 24);
this.label8.TabIndex = 0;
this.label8.Text = "MFT JET Restore";
this.Finish.Location = new System.Drawing.Point(376, 352);
this.Finish.Name = "Finish";
this.Finish.Size = new System.Drawing.Size(80, 24);
this.Finish.TabIndex = 42;
this.Finish.Text = "&Finish";
this.Finish.Click += new System.EventHandler(this.Finish_Click);
this.Next.Location = new System.Drawing.Point(288, 352);
this.Next.Name = "Next";
this.Next.Size = new System.Drawing.Size(80, 24);
this.Next.TabIndex = 42;
this.Next.Text = "&Next >";
this.Next.Click += new System.EventHandler(this.Next_Click);
this.Previous.Location = new System.Drawing.Point(200, 352);
this.Previous.Name = "Previous";
this.Previous.Size = new System.Drawing.Size(80, 24);
this.Previous.TabIndex = 42;
this.Previous.Text = "< &Back";
this.Previous.Click += new System.EventHandler(this.Previous_Click);
this.Cancel.Location = new System.Drawing.Point(112, 352);
this.Cancel.Name = "Cancel";
this.Cancel.Size = new System.Drawing.Size(80, 24);
this.Cancel.TabIndex = 42;
this.Cancel.Text = "&Cancel";
this.Cancel.Click += new System.EventHandler(this.Cancel_Click);
this.groupBox1.Location = new System.Drawing.Point(0, 339);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(464, 7);
this.groupBox1.TabIndex = 43;
this.groupBox1.TabStop = false;
this.groupBox2.Location = new System.Drawing.Point(0, 75);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(464, 7);
this.groupBox2.TabIndex = 45;
this.groupBox2.TabStop = false;
this.FinishPanel.Controls.Add(this.FinsihLabel);
this.FinishPanel.Location = new System.Drawing.Point(0, 80);
this.FinishPanel.Name = "FinishPanel";
this.FinishPanel.Size = new System.Drawing.Size(464, 264);
this.FinishPanel.TabIndex = 46;
this.FinsihLabel.Location = new System.Drawing.Point(8, 16);
this.FinsihLabel.Name = "FinsihLabel";
this.FinsihLabel.Size = new System.Drawing.Size(448, 88);
this.FinsihLabel.TabIndex = 0;
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(464, 383);
this.Controls.Add(this.panel1);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.Finish);
this.Controls.Add(this.Next);
this.Controls.Add(this.Previous);
this.Controls.Add(this.Cancel);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.DestinationPanel);
this.Controls.Add(this.ProgressPanel);
this.Controls.Add(this.FilePanel);
this.Controls.Add(this.SQLServerPanel);
this.Controls.Add(this.FinishPanel);
this.Controls.Add(this.WelcomePanel);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "Form1";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "JET Restore";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();
this.SQLServerPanel.ResumeLayout(false);
this.SQLServerPanel.PerformLayout();
this.FilePanel.ResumeLayout(false);
this.FilePanel.PerformLayout();
this.ProgressPanel.ResumeLayout(false);
this.WelcomePanel.ResumeLayout(false);
this.DestinationPanel.ResumeLayout(false);
this.DestinationPanel.PerformLayout();
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.pictureBox2)).EndInit();
this.FinishPanel.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void Form1_Load(object sender, System.EventArgs e)
{
this.Windows.CheckedChanged += new EventHandler(OnChangeAuthenticationType);
this.SQLServer.CheckedChanged += new EventHandler(OnChangeAuthenticationType);
this.ExistingDatabase.CheckedChanged += new EventHandler(OnChangeDestination);
this.NewDatabase.CheckedChanged += new EventHandler(OnChangeDestination);
this.BackUp.Click += new EventHandler(this.BackUp_Click);
this.Path.Click += new EventHandler(this.Path_Click);
this.Navigate(true);
}
private void OnChangeAuthenticationType(object sender , EventArgs e)
{
bool b = !(this.Windows.Checked);
this.UserName.Enabled = b;
this.Password.Enabled = b;
this.label4.Enabled = b;
this.label5.Enabled = b;
if(((RadioButton)sender).Name == "SQLServer" && ((RadioButton)sender).Checked)
{
this.UserName.Focus();
this.UserName.SelectAll();
}
}
private void OnChangeDestination(object sender , EventArgs e)
{
bool b = !(this.ExistingDatabase.Checked);
this.DataBaseName.Enabled = b;
this.DataBasePath.Enabled = b;
this.label1.Enabled = b;
this.label2.Enabled = b;
this.Path.Enabled = b;
this.DatabaseList.Enabled= !b;
this.RefreshDatabases.Enabled= !b;
if(((RadioButton)sender).Name == "NewDatabase" && ((RadioButton)sender).Checked)
{
this.DataBaseName.Focus();
this.DataBaseName.SelectAll();
}
else
{
this.DatabaseList.Focus();
this.FillDatabaseList(this.ConnectionString());
}
}
private void Path_Click(object sender, System.EventArgs e)
{
FolderBrowserDialog f = new FolderBrowserDialog();
f.ShowNewFolderButton = true;
f.Description = "Select path to create new database:";
if(System.IO.Directory.Exists(this.DataBasePath.Text))
f.SelectedPath = this.DataBasePath.Text;
if (f.ShowDialog()==DialogResult.OK)
this.DataBasePath.Text = f.SelectedPath;
f.Dispose();
}
private string ConnectionString()
{
string s;
s = string.Format("Server={0};",this.Server.Text);
if(this.Windows.Checked)
s += "Trusted_Connection=True;";
else
s += string.Format("UId={0};PWD={1};",this.UserName.Text,this.Password.Text);
s+="Connect Timeout=1;Max Pool Size=1;Connection Lifetime=10;";
return s;
}
private void FillDatabaseList(string ConnectionString)
{
this.DatabaseList.Items.Clear();
SqlConnection connection = new SqlConnection(ConnectionString);
SqlCommand cmd = connection.CreateCommand();
SqlDataReader reader;
cmd.CommandText = "Select Name From sysDatabases";
try
{
connection.Open();
reader = cmd.ExecuteReader();
string Database="";
while(reader.Read())
{
Database = reader.GetString(0);
if(Database != "master" && Database != "model" && Database != "msdb" && Database != "tempdb" )
this.DatabaseList.Items.Add(Database);
}
reader.Close();
(reader as IDisposable).Dispose();
}
catch(SqlException ex)
{
MessageBox.Show(ex.ToString(),"SQL Server Error",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString(),"Error",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
}
finally
{
if(connection.State == ConnectionState.Open)
connection.Close();
cmd.Dispose();
connection.Dispose();
if(this.DatabaseList.Items.Count>0)
this.DatabaseList.SelectedIndex = 0;
}
}
private void RefreshDatabases_Click(object sender, System.EventArgs e)
{
this.FillDatabaseList(this.ConnectionString());
}
private bool GetFileRestored(string ConnectionString,string DatabaseName,ref string DataFile , ref string LogFile)
{
SqlConnection connection = new SqlConnection(ConnectionString);
SqlCommand cmd = connection.CreateCommand();
SqlDataReader reader;
cmd.CommandText = this.PrepareCommand("Restore.sql",DatabaseName);
try
{
connection.Open();
reader = cmd.ExecuteReader();
while(reader.Read())
{
if(reader.GetString(2)=="D")
DataFile = reader.GetString(0);
else
LogFile = reader.GetString(0);
}
reader.Close();
(reader as IDisposable).Dispose();
}
catch(SqlException ex)
{
MessageBox.Show(ex.ToString(),"SQL Server Error",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
return false;
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString(),"Error",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
return false;
}
finally
{
if(connection.State == ConnectionState.Open)
connection.Close();
cmd.Dispose();
connection.Dispose();
}
return true;
}
private string PrepareCommand(string Name , string DatabaseName)
{
string Commands = this.LoadSQLFromAssembly(Name);
if (Commands == null)
return null;
Commands = Commands.Replace("%Database%" , DatabaseName);
Commands = Commands.Replace("%DatabasePath%" , this.DataBasePath.Text + "\\");
Commands = Commands.Replace("%BackUpPath%" , this.BackUpFile.Text);
return Commands;
}
private bool ExecuteSQLCommand(string ConnectionString , string Commands)
{
SqlConnection connection = new SqlConnection(ConnectionString);
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = Commands;
try
{
connection.Open();
cmd.ExecuteNonQuery();
}
catch(SqlException ex)
{
MessageBox.Show(ex.ToString(),"SQL Server Error",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
return false;
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString(),"Error",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
return false;
}
finally
{
if(connection.State == ConnectionState.Open)
connection.Close();
cmd.Dispose();
connection.Dispose();
}
return true;
}
private string LoadSQLFromAssembly (string Name)
{
System.IO.Stream stream = this.GetType().Assembly.GetManifestResourceStream(this.GetType(),"SQL." + Name);
if(stream == null)
{
MessageBox.Show("Internal Error occured! Close Application & try again.","Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
return null;
}
System.IO.StreamReader reader= new System.IO.StreamReader(stream);
if (reader == null)
{
MessageBox.Show("Internal Error occured! Close Application & try again.","Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
return null;
}
string s = reader.ReadToEnd();
reader.Close();
return s;
}
private void BackUp_Click(object sender, System.EventArgs e)
{
OpenFileDialog f = new OpenFileDialog();
f.Filter = "SQL Server BackUp Files|*.bak|All Files|*.*";
f.Title = "Open Backup File";
if(System.IO.File.Exists(this.BackUpFile.Text))
f.FileName = this.BackUpFile.Text;
if(f.ShowDialog()==DialogResult.OK)
{
this.BackUpFile.Text = f.FileName;
}
f.Dispose();
}
#region Validateion
private bool Validate_File()
{
if(!System.IO.File.Exists(this.BackUpFile.Text))
{
MessageBox.Show("Select BackUp File.","User",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
this.UserName.Focus();
return false;
}
return true;
}
private bool Validate_SQLServer()
{
SqlConnection connection = new SqlConnection(this.ConnectionString());
try
{
connection.Open();
connection.Close();
return true;
}
catch(Exception ex)
{
MessageBox.Show(ex.Message , "Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
return false;
}
finally
{
connection.Dispose();
}
}
private bool Validate_Destination()
{
if (this.ExistingDatabase.Checked)
{
if(this.DatabaseList.SelectedIndex < 0)
{
MessageBox.Show("Select Database.","User",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
this.DatabaseList.Focus();
return false;
}
}
else
{
if(this.DataBaseName.Text=="")
{
MessageBox.Show("Enter Database Name.","User",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
this.DataBaseName.Focus();
return false;
}
if(this.DatabaseList.Items.Contains(this.DataBaseName.Text))
{
MessageBox.Show("Database already exists!","User",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
this.DataBaseName.Focus();
return false;
}
if(!System.IO.Directory.Exists(this.DataBasePath.Text))
{
MessageBox.Show("Enter a valid path.","User",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
this.DataBasePath.Focus();
return false;
}
}
return true;
}
#endregion
private void DoRestore()
{
this.StatusLabel.Text = "Gathering information about operation...";
this.SetProgressBar(0);
string Commands , DataFile="" , LogFile ="" , DatabaseName ="";
if(this.NewDatabase.Checked)
{
Commands = this.PrepareCommand("CreateNewDatabase.sql" , this.DataBaseName.Text);
if(Commands == null)
{
this.FinsihLabel.Text = "Wizard can not do operation!";
this.Navigate(true);
return;
}
this.StatusLabel.Text = string.Format( "Creating new database with name {0} ..." , this.DataBaseName.Text) ;
this.SetProgressBar(10);
if(this.ExecuteSQLCommand(this.ConnectionString() , Commands))
{
this.StatusLabel.Text = "Database Created Successfully!" ;
}
else
{
return;
}
this.SetProgressBar(40);
DatabaseName = this.DataBaseName.Text;
}
else
{
this.StatusLabel.Text = "" ;
DatabaseName = this.DatabaseList.SelectedItem.ToString();
}
this.StatusLabel.Text += string.Format( "\nLoading {0} ..." ,@"\\BLR_11285_OCR1\ E:\Testdb.bak") ;
this.SetProgressBar(50);
if (this.GetFileRestored(this.ConnectionString(),DatabaseName,ref DataFile , ref LogFile))
{
this.StatusLabel.Text = "Generating SQL scripts ..." ;
Commands = this.PrepareCommand("RestoreFinall.sql" , DatabaseName);
if(Commands == null)
{
this.FinsihLabel.Text = "Wizard can not do operation!";
this.Navigate(true);
return;
}
this.StatusLabel.Text = "Finalizing SQL scripts ..." ;
this.SetProgressBar(60);
Commands = Commands.Replace("%OldData%" , DataFile).Replace("%OldLog%",LogFile);
this.SetProgressBar(70);
this.StatusLabel.Text = "Finalizing operation ..." ;
this.ExecuteSQLCommand(this.ConnectionString() , Commands);
this.StatusLabel.Text = "Operation successfully done." ;
this.SetProgressBar(100);
}
this.FinsihLabel.Text = string.Format ("Restore wizard successfully finished. Result : \n\nFile {0} successfully restore to {1}.",this.BackUpFile.Text , DatabaseName);
this.Navigate(true);
}
private void SetProgressBar(int value)
{
this.pbar.Value = value;
Application.DoEvents();
}
private int Pointer = 0;
private const int MaxPages = 6;
private void Navigate(bool forward)
{
Pointer = forward ? Pointer + 1 : ((Pointer == MaxPages) ? Pointer - 2 : Pointer - 1);
this.Previous.Enabled = (Pointer == 1) ? false : true;
this.Next.Enabled = (Pointer == MaxPages) ? false : true;
this.Finish.Enabled = !this.Next.Enabled;
this.Cancel.Enabled = this.Next.Enabled;
this.WelcomePanel.Visible = (Pointer == 1 ) ? true : false;
this.SQLServerPanel.Visible = (Pointer == 2 ) ? true : false;
this.FilePanel.Visible = (Pointer == 3 ) ? true : false;
this.DestinationPanel.Visible = (Pointer == 4 ) ? true : false;
this.ProgressPanel.Visible = (Pointer == 5 ) ? true : false;
this.FinishPanel.Visible = (Pointer == 6 ) ? true : false;
if(Pointer == 5)
{
this.Cancel.Enabled = false;
this.Finish.Enabled = false;
this.Next.Enabled = false;
this.Previous.Enabled = false;
this.DoRestore();
}
if(Pointer == 3)
{
this.FillDatabaseList(this.ConnectionString());
}
}
private void Next_Click(object sender, System.EventArgs e)
{
switch(this.Pointer)
{
case 2 :
if(!this.Validate_SQLServer())
return;
break;
case 3:
if(!this.Validate_File())
return;
break;
case 4:
if(!this.Validate_Destination())
return;
break;
}
this.Navigate(true);
}
private void Previous_Click(object sender, System.EventArgs e)
{
this.Navigate(false);
}
private void Finish_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void Cancel_Click(object sender, System.EventArgs e)
{
if(MessageBox.Show("Are you sure want to cancel wizard?","Restore Database",MessageBoxButtons.YesNo,MessageBoxIcon.Question)==DialogResult.No)
return;
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string name = Environment.MachineName;
string n = "\\" + name + this.DataBasePath.Text;
MessageBox.Show(n);
}
}
}
Submit an article or tip