Import data from Microsoft SQL (.MDF) file into MySQL
If you don't have MSSQL installed the simplest option would be to install SQL Server Express, attach your mdf, then export from there. You have quite a few options, from the simplest csv export/import, using a tool such as OpenDbCopy, or writing custom code to connect to both database and load from one to the other.
Alfred
I am a Full Stack developer and a DevOps Engineer, who always to learn from, and contribute to, the technology community. I was a beginner in programming once. What all I had was pieces of scattered and crude knowledge (don't know if i can call it knowledge) then. Later, I joined for Master of Computer Applications in a college and there, I got a great teacher. It was her, who taught me when and where to use 'while' and 'for' loops even.What all knowledge I have now, and what all achievements I've made till now, is only because of her. Compared to her, I am ashes. Hats off my dear teacher Sonia Abraham, you are the best of your kind. Sonia Abraham is a professor of the Department of Computer Applications, M.A College of Engineering, Mahatma Gandhi University
Updated on August 14, 2020Comments
-
Alfred over 3 years
I am running
PHP/5.3.0withApache/2.2.17 (Win32)in my Windows Vista PC. I have MySQL server version: 5.5.8. I have a Database.MDF file containing some tables. I want to import this data into my MySQL database. I have Microsoft SQL Server installed. I use PHP MyAdmin. Anybody got a solution or a software package?