Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
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 lurking in the Monastery: (7)
As of 2015-07-05 23:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (68 votes), past polls