accessing SQL Server 2000 data
I have a sql server 2000 .dat file, about 4MB, that i need to convert to MySQL. I don't have MS SQL nor am i going to by it.
I tried to find an evaluation version on microsoft.com so i could open the database and dump it, but they don't have one. I have an old SQLServer 7.0 eval but that won't open the database.
It is probably unlikely that I can get this data in any other format. Any ideas on how to extract this data?
Mark Hensler posted this at 22:26 — 4th March 2003.
He has: 4,048 posts
Joined: Aug 2000
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.
Mark Hensler
If there is no answer on Google, then there is no question.
ROB posted this at 22:38 — 4th March 2003.
They have: 447 posts
Joined: Oct 1999
well i found this program http://www.officerecovery.com/mssql/ that worked like a charm!
thanks for looking Mark.
ROB posted this at 23:05 — 4th March 2003.
They have: 447 posts
Joined: Oct 1999
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.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.