Knowledge Base Article: Export HelpMaster data to a CSV text file

Export HelpMaster data to a CSV text file

INFO: SQL Import

Export HelpMaster data to a CSV text file comma separated value sqlcmd utility

HelpMaster > Database

Database

4/08/2009 2:26:10 PM

3/11/2017 8:35:42 AM

Average Rating (from {{model.ratings}} ratings)
0 Attachments
0 See Also Links

How to export data from the HelpMaster database

 

Applies to SQL Server 2008 and higher

 

Data can be exported from SQL Server via the use of the sqlcmd utility that installs with SQL Server.

 

sqlcmd -S "Database server name\instancename" -d "HelpMaster Database name goes here" -q "Select * From dbo.rptCompleteDetails_Job_ClientSite1 Where JobNumber > 0" -o "c:\JobExport.csv" -s ,

 

Click on Start, run "cmd" with Administrator permission and then paste the command into the "DOS" Window.

 

For further information about sqlcmd tool, refer to http://msdn.microsoft.com/en-us/library/ms162773.aspx