converting data in .mdf and .ldf files to excel or tab delimited file formats
Posted on 2006-11-04
Hi, I am very new to MS SQL Server. I am given a set of .mdf and .ldf files and I eventually need to import the data in these files into a MYSQL database running on Linux. For now I like to somehow extract the data and export them into a tab delimited or comma delimited file formats. I downloaded and installed MS SQL server 2005 express edition but I am not sure what needs to be done from this point. This will probably be the only time that I have to deal with MS SQL server so I am not too eager to spend a lot of time on MS SQL server. Could someone show me how to import the .mdf file into my MS SQL server and export the data to tab delimited file? Is there a better way to achieve this?