import trace file in database

• Samx

  Ten Centuries

  Points: 1021

  More actions

  December 8, 2005 at 2:32 am

  #66852

  Hi,

  Do you know a script (DMO or ohter) to import SQL 7.0 traces generated by SQL Profiler in another SQLSERVER or ORACLE database ?

  Regards

• cmille19

  SSCertifiable

  Points: 5970

  More actions

  December 9, 2005 at 3:21 pm

  #608834

  You could use Microsoft's tracereader dll as described in this KB article:

  http://support.microsoft.com/kb/q273933/

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  December 9, 2005 at 3:32 pm

  #608836

  You could use (perhaps with a little modification) the following script from the Script Library here:

  Automated Profiler trace import

  K. Brian Kelley
  @kbriankelley