Importing MSSQL .trc files into MSSQL DB

• Konrad Pociask

  SSC Enthusiast

  Points: 120

  More actions

  April 22, 2005 at 3:15 am

  #164054

  Is there a way of converting and then importing MSSQL trace (.trc) files from several servers into a central MYSQL DB Server? Could it be automated?

  Idea 1: From a previous thread I've read that I could use the File->Save As->table feature in Profiler to convert the .trc into a table.  I assume that I could then use a MSSQL-to-MYSQL migrating/converting tool to import the tables into the MySQL DB.

  Idea 2: use the fn_trace_gettable function in Query Analyser to convert all trace files on one server to table format.

  i.e.

  SELECT * FROM ::fn_trace_gettable('C:\Program Files\Microsoft SQL

    Server\MSSQL\Data\audittrace_20040822191554.trc', default)

  GO

  (http://www.databasejournal.com/features/mssql/article.php/3399241)

  and then migrate/convert the table into MySQL DB format.

  Is there a better way?  This process must be performed daily.

  TIA

   

   

• Konrad Pociask

  SSC Enthusiast

  Points: 120

  More actions

  April 22, 2005 at 3:19 am

  #554298

  I misspelt the thread heading it should be "Importing mssql .trc filse into MySQL DB" not MSSQL DB

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  April 22, 2005 at 3:43 am

  #554302

  >Is there a better way?

  Replace the MySQL server with a SQL Server?

  No, I do not think there is a better way. I would go with alt. #2.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/