in reply to Re: Parse MSSQL .bak file
in thread Parse MSSQL .bak file

Well - if the server is running it should be fairly straightforward to copy the data to flat files. I understand that MS in its infinite wisdom has deprecated the bcp utility, but I've used the following with Sybase:

#!/usr/bin/perl -w use strict; use Sybase::Simple; my $dbh = new Sybase::Simple 'sa', 'pwd', 'server'; my $tables = $dbh->ArrayOfScalar(" select name from $db..sysobjects where type = 'U'"); foreach my $tab (@$tables) { system("bcp $db..$tab out $tab.bcp -c -Usa -Ppwd -Sserver"); }
A similar script should be feasible with MS-SQL, either using MS's native tools, or using functionality from the FreeTDS project.

Michael