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

Question

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.

Pradeep · Answer

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(); }

Raja T · Answer

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); }

Raja T · Answer

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

Raja T · Answer

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); }

Raja T · Answer

Hi Please checkout bellow url http://www.codeproject.com/Tips/421628/How-to-copy-a-SQL-Server-table

Pavithra L · Answer

Hello Pradeep  Cen you find anything related to my question . It's urgent please help me. I need the answer quickly .

Pavithra L · Answer

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.

Pradeep · Answer

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..

Pradeep · Answer

in button click

Pavithra L · Answer

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.

Pradeep · Answer

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  );

Pavithra L · Answer

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.

Pradeep · Answer

ok Open that .mdf database in sql server and run that script which you have generated.

Pavithra L · Answer

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.

Pradeep · Answer

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....!