Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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

by Anonymous Monk
on Jan 16, 2009 at 14:13 UTC ( #736835=perlquestion: print w/ replies, xml ) Need Help??
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

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

Comment on Is there a perl module for parsing Microsoft SQL .MDF files?
Re: Is there a perl module for parsing Microsoft SQL .MDF files?
by matze77 (Friar) on Jan 16, 2009 at 15:56 UTC
Re: Is there a perl module for parsing Microsoft SQL .MDF files?
by ww (Bishop) on Jan 16, 2009 at 16:05 UTC
    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
Re: Is there a perl module for parsing Microsoft SQL .MDF files?
by b10m (Vicar) on Jan 22, 2009 at 09:17 UTC

    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 ;-)

    --
    b10m

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://736835]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (9)
As of 2014-07-11 08:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (222 votes), past polls