Anybody have any suggestions on how to export a SQL table which are full of logs to export it into a text file so that we can import it into splunk???
If this is for a one-time export of data, the newer versions of Microsoft SQL have SQL Server Integration Services (SSIS). SSIS provides a very simplified Export wizard that should accomplish your goal.
Here's a walkthrough that depicts how to export tables to flat files:
http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wiz...
With Microsoft SQL, you can use many mechanisms:
Note that the above are effective and easy for a one-time dump and export of data, but not for monitoring and real-time indexing of live database insertions.
It's MSSQL, there couple caveats like not adding any duplicates...the question is how to export the logs from MSSQL table into text file so we can import into splunk...
This previous question may help get you started:
http://answers.splunk.com/questions/2040/what-is-the-most-effective-ways-to-poll-databases-such-as-m...
thanks, I will look into it...
What kind of SQL database are you talking about?