ROB — Tue, 04 Mar 2003 23:05:54 +0000

here was my solution:

i installed the SQLServer 7.0 Eval, and ran the MSSQLRecovery program (http://www.officerecovery.com/mssql/) on the .dat file which converted it to MSSql scripts. Ran the scripts, then used SQLPorter (http://www.realsoftstudio.com/) to port it from SQLServer to MySQL.

The whole thing was pretty painless, i'm impressed.

ROB — Tue, 04 Mar 2003 22:38:12 +0000

well i found this program http://www.officerecovery.com/mssql/ that worked like a charm!

thanks for looking Mark.

Mark Hensler — Tue, 04 Mar 2003 22:26:59 +0000

mySQL has an import for formatted text files, but I can't find anything on MS SQL .dat files. I didn't find anything on google, but I didn't work at it long.