Export data from all tables in database to flat file
Export data from all tables in database to flat file
(OP)
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
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
Talk To Other Members
RE: Export data from all tables in database to flat file
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.
RE: Export data from all tables in database to flat file
RE: Export data from all tables in database to flat file
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.