Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 export data from SQl to text file

Author  Topic 

davidwong
Starting Member

3 Posts

Posted - 2015-04-29 : 05:04:15
hi everyone who is viewing this forum, i am doing the project which i am very new to it and did not study before but my project is invoke in it... For example i have the data of ACTTAB, APTTAB and etc, how to i export this data from SQL and insert into a text file??? this is the first time i need to do. as for the 2nd thing is that after export the data from SQL into text file, i need to import this data into mongoDB. so basically i need help in the first part which is "how to export this following data (ACTTAB, APTTAB and etc) into text file?

i need to know what is the code to type into the SQL and do explain to me in simple term so that i able to understand on how it work/run...

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-29 : 09:23:00
http://stackoverflow.com/questions/25139266/how-do-i-import-data-into-mongodb-from-sql-server
Go to Top of Page

davidwong
Starting Member

3 Posts

Posted - 2015-04-29 : 21:07:48
thank gbritton, but that is something that i view and not able to understand
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-04-30 : 01:44:18
@davidwond - You could use the bcp facility - it's very straightorward to connect to SQL Server and export tables http://www.sqlserver-dba.com/2014/12/bcp-export-and-import-data-on-sql-server.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

davidwong
Starting Member

3 Posts

Posted - 2015-04-30 : 01:59:30
does sql server and sql developer is the same??
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-05-01 : 01:28:06
SQL Server is the Microsoft data platform - there are a bunch of products within SQL Server.
By SQL Developer - do you mean Oracle SQL Developer product?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2015-05-01 : 03:47:19
MSSQL Developer Edition / Version perhaps?
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-05-01 : 08:18:36
SQL Server Developer Edition?
Go to Top of Page
   

- Advertisement -