Exporting Data from tables to text file all at once

Hello !!!

Can u please suggest me , the way to Export the data from all the tables of the Data Base at a time in text files individually with file names similar to the table names .

So if i had 200 tables in my data base . i require 200 text files each having the data of each table in the data base.

File name of text file should be equal to that of the file name of table.

Quote:

Originally Posted by bvdrsganesh1981

Hello !!!

Can u please suggest me , the way to Export the data from all the tables of the Data Base at a time in text files individually with file names similar to the table names .

So if i had 200 tables in my data base . i require 200 text files each having the data of each table in the data base.

File name of text file should be equal to that of the file name of table.

Hi ,
You can take script the object in sql server along with the data with separeate object name.