Is there a perl module for parsing Microsoft SQL .MDF files?

[Anonymous Monk]

Greetings Perlmonks ! Is there a perl module or subroutine out there and available for parsing Microsoft SQL .MDF files?

[ww]

If you take the suggestion above (to search CPAN), using "MSSQL" as your sole search term, you'll find DBIx::SQLEngine::Driver::MSSQL with the precis, "Support Microsoft SQL Server via DBD::ODBC" (among many others).

Since you're seeking a way to deal with MSSQL, perhaps we're looking at Windows, in which case there's a possibility you're using ActiveState. In that case,

ppm search MSSQL
Downloading datetime packlist...redirect
Downloading datetime packlist...redirect
Downloading datetime packlist...done
1: Class-DBI-MSSQL
   Class::DBI for MSSQL
   Version: 0.122
   Released: 2006-11-11

2: DBIx-MSSQLReporter
   An module to connect Perl to MS SQL Server and MS Data Engine
   Version: 1.04
   Released: 2005-10-27

3: DBIx-TableReferences-MSSQL
   Perl extension for getting information about declared referential c
+onstraints in MS SQL Server 2000 databases.
   Version: 0.04
   Released: 2008-07-14

4: Time-Piece-MSSQL
   MSSQL-specific methods for Time::Piece
   Version: 0.020
   Released: 2006-11-13

[matze77]

Dunno. You searched http://search.cpan.org already ?

[b10m]

I've been looking at this recently as well (not out of joy) and found no other sane method than to use a Windows (virtual) machine with SQL Server Express (assuming you have no MSSQL box). After that, the already mentioned DBD::ODBC can be used to query the server.

I do have to say it's not a great solution, but at least you can export the data into something more cross-platform ;-)