Backing up data from a Sql Server Table

[xbiplav]

Is there anyway that we can extract or backup data from a sql server table to anything, and later importing them? Is there any popular tool or technique to do so?

[Reza Raad]

you can generate sql script for you table structure and also data which exist in your table. if you have sql server 2008 follow this instructions: Open Sql Server Management Studio Right Click on your database go to : Tasks then: generate scripts... wizard will shown then try this wizard you can find it very simple

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

[xbiplav]

I have to do that programatically and i am using Vb.Net or may be C# will do.

[Reza Raad]

You can create your own SSIS package and then run it with your .NET application

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

[Lambin]

Hello , You can use SMO ( SQL Server Management Objects ) to do that but it might be complicated for a beginner ( in SMO )