Database file problem

Sitt · 15 Sep 2007 at 08:44

I'm trying to install an old database file into a CRM called Maximizer 9 but the old database file is a SLX_dat.mdf file and the CRM only seems to be able to import files such as csv, tab delimited, dbase and XML.
How do I open the SLX_dat.mdf file to enable me to save it to one of the above formats?

oneilldo · 15 Sep 2007 at 10:04

mdf files are usually SQL Server files. You should be able to use SQL Server express to attach the DB file (it will then create a missing transaction log file extension is ldf). After this you can use the export functionality to save it as a csv

Burnsy2023 · 15 Sep 2007 at 10:35

oneilldo said:
mdf files are usually SQL Server files. You should be able to use SQL Server express to attach the DB file (it will then create a missing transaction log file extension is ldf). After this you can use the export functionality to save it as a csv

Bingo. MDF stands for master database file, which is an MS SQL Server data base format.

Burnsy

Sitt · 15 Sep 2007 at 10:45

I have never used SQL before so I'm a little lost here...
If I download SQL Server Express and open the mdf file in that i pressume that i can save it from there???

Burnsy2023 · 15 Sep 2007 at 11:20

Sitt said:
I have never used SQL before so I'm a little lost here...
If I download SQL Server Express and open the mdf file in that i pressume that i can save it from there???

Pretty much, you need to 'attach' the database rather than open it though.

Burnsy