A client wants me to extract customer data from his old system The application he was using appears to have used MSDE as the database and its backups have the extension .dat
SSMS express edition or Access do not appear to have a way to import data from these files. Can someone point me in the right direction.
OK Sorry for asking this question as I have just managed to find the solution to.
1: create a new database in sql server 2005
2: select the option to restore
3: Find the .dat file using the dialog, you'll get the message "The backup set holds a backup of a database other than the existing database" (this was the problem for me)
4: In options select "overwrite existing database
The msde .dat file is then imported into sql server