Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export data from all tables in database to flat file

Status
Not open for further replies.

ahm1985

Programmer
Dec 6, 2012
138
EG
I need to make export to all data found in sql server 2005 to specified database.
what i need data only inside all tables(no need another objects as view stored procedure) in database XX export to flat file by c# are this possible.if possible how
thanks
 
Is this possible?
Yes, certainly.
Where are you stuck?
What have you tried so far?

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
 
Can you give me more detailes if possible.
 
No.
This is not a get-code-for-free site.
a) You have not specified what kind of "flat file" you want (delimiter: tab/comma/semcolon? Text qualifier? encoding ASCII, UTF-8 or Unicode?)
b) You don't actually need code for that. SQL Server provides an export/import utility, also you can output queries to files.
c) If you need code for that, then why? What do you want to achieve? Are you sure "flat file" is the correct format?
d) What have you tried so far? Code snippets? YOu can find a lot using Google alone.

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top