How to take a backup of only one single table in .mdf db.

Pavithra L

In my project ,I can create the database is .mdf format. It is located inside the server explorer. Here I can take backup for individual table data's for all the tables. How can I do this in C# windows application. Anybody can help this. It's urgent will you please reply quickly.

15 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradeep11y ago
private void button1_Click(object sender, EventArgs e)
{
string selectQuery = "SELECT * INTO backUpTablename IN 'Backup.mdb' FROM originalTableName; ";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(selectQuery, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
0
Raja T11y ago
Hello Try like

private void button1_Click(object sender, EventArgs e)
{

string selectQuery = "Select * INTO newtablename FROM oldtablename";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(selectQuery, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");
}

0
Raja T11y ago
Hi, Please checkout bellow urls

http://stackoverflow.com/questions/19378779/backup-sql-server-2008-database-to-a-sql-filelike-sql-using-c-sharp

http://www.codeproject.com/Tips/461494/Backing-up-an-SQL-Database-in-Csharp
0
Raja T11y ago
Hello Pavithra, Try like

private void button1_Click(object sender, EventArgs e)
{

string selectQuery = "INSERT INTO newtable_name SELECT * FROM old_table_name";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(selectQuery, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");
}

0
Raja T11y ago
Hi, Please checkout bellow url

http://www.codeproject.com/Tips/421628/How-to-copy-a-SQL-Server-table
0
Pavithra L11y ago
Hello Pradeep ,
Cen you find anything related to my question . It's urgent please help me. I need the answer quickly .
0
Pavithra L11y ago
Hai ,

I am using your code . but It's not working. Here I can receive this error message like this
Error 23 Argument 2: cannot convert from 'string' to 'System.Data.SqlClient.SqlConnection' D:\Knitting_Dyeing Software\Knitting_Dyeing Software\BalanceSample.cs 117 119 Nectarcraft Kniting and Dyeing Software
How can I solve this error in my code.

Can you please tell me the solution .

Thanks.
0
Pradeep11y ago

SaveFileDialog1.FileName = ComboBoxDatabaseName.Text;
SaveFileDialog1.ShowDialog();

string s = null;

s = SaveFileDialog1.FileName;
SqlCommand cmd = new SqlCommand("Backup database "+ComboBoxDatabaseName.Text+" to disk='" + s+ "'", "Server="+ComboBoxserverName.Text+";AttachDbFilename=|DataDirectory|mydbfile.mdf; Database="+ComboBoxDatabaseName.Text+"; Trusted_Connection=Yes");
cmd.ExecuteNonQuery();

MessageBox .Show( "Database BackUp has been created successful");

if you want to take back on form load you can apply this code in form load or if you want to take back up when ever you want, create one form as attached with this and apply this code in on Button click..
0
Pradeep11y ago
in button click
0
Pavithra L11y ago
Where I have to apply this query in my project whether in form load or in button click . I am confused this. Can you please elaborate it quickly. I need a faster reply from you.

Thanks for your kind co-operation.
0
Pradeep11y ago

try this...

SqlCommand cmd = new SqlCommand("Backup database [DBname] to disk='" + Path + "'", "Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname; Trusted_Connection=Yes");
cmd.ExecuteNonQuery();

MessageBox .Show( "Database BackUp has been created successful");
0
Pavithra L11y ago
Here I don't want to work within sqlserver. I can create one form here simply I just select that database file name and take backup for that database. can you understand my question.How can I do this . Please give me an exact answer.
0
Pradeep11y ago
ok,
Open that .mdf database in sql server and run that script which you have generated.
0
Pavithra L11y ago
How can I create the script it's a windows based application not a web application. I don't know this .Mdf is a temporary database file. Is there any problem to store the data's in .mdf database file. This .mdf database file memory capacity is low or high? If it is high means maximum how many data's can stored in it.
Please clear these doubts.

Thanks for your reply.
0
Pradeep11y ago
Hi,

Bit of lateral thinking here which may solve your problem.
Why done you create a temporary db, restore to it and then dts over the data/table you require.

You have option to generate script for single table including data. so generate a script and run it where ever (database) you want....!
0