b0ss
b0ss

Reputation: 119

convert .mdf file to .sql script (mac)

I have .mdf file (MS SQL backup) and i want to convert it to .sql. So I dont want to use MS anymore but Mysql. Is there a way to convert the .mdf file to sql? Perfect would be if it also recreates the relations etc.

thanks.

Upvotes: 0

Views: 644

Answers (1)

Hogan
Hogan

Reputation: 70523

mdf is the binary file of a database. The tool that allows you to access the data in a mdf file is SQL Server. There are no other tools to work with these files -- there are many tools which allow you to export the data and structure of a SQL Server database and they are all included in the SQL Server product. In the UI you can select "script database". There are also ways to export tables.

Upvotes: 2

Related Questions