将iis日志导入到SqlServer 

"C:\Program Files (x86)\Log Parser 2.2\LogParser.exe"  "SELECT  *  FROM  'C:\Users\Core\Desktop\u_ex200905.log'  to MyMVC_WebLog" -i:IISW3C -o:SQL -oConnString:"Driver={SQL Server};server=.\SQL2017;database=MyTestDb;Integrated Security=SSPI" -createtable:ON

　　

"C:\Program Files (x86)\Log Parser 2.2\LogParser.exe"  "SELECT  *  FROM  'C:\Users\Core\Desktop\u_ex200905.log'  to MyMVC_WebLog" -i:IISW3C -o:SQL -oConnString:"Driver={SQL Server};server=.\SQL2017;database=MyTestDb;Integrated Security=SSPI" -createtable:ON

posted @ 2020-09-05 22:26  challengesoflife  阅读(233)  评论(0)  编辑  收藏  举报