CODEWITHSUNDEEP
asp.netsql-serverimportexport
Hadi Nemati
Hadi Nemati

Reputation: 547

Import And Export data

I want to export bulk of records from a table in Sqlserver database to a file and after that i want to import that file to another table in another database . my project is Asp.net my Database is Sqlserver 2008

how do i can do this and what kind of file is faster to use?(XML,TXT,...)

thanks so much

Upvotes: 0

Views: 767

Answers (2)

Purvesh
Purvesh

Reputation: 646

in sql server management

Right click on DB then select task->generate script

follow wizard....

Upvotes: 1

naresh
naresh

Reputation: 2113

You can use bcp utility that comes along with sqlserver. More details at http://msdn.microsoft.com/en-us/library/aa337544.aspx

Upvotes: 1

Related Questions