Programming Questions? Ask a Programmer for Answers ASAP
Welcome to JustAnswer and thank you for utilising our services.
Have you tried these steps:
1. Open the MDF file in SQL server
2. run and export a query from each table.
Ok just a moment
Which action brings up the error?
Alright I am also experiencing a connection problem of my own. Just a moment while I try
Ok so my server was not running. Please if your is running by going to:
Control Panel >> Administrative Tools >> Services
Scroll and right-click on SQL Server and start it if it is not running
Is "SQL Server (SQLEXPRESS)" in the list of services?
I am in the same stage and tried to open a .mdf file. It openned but the tables were not there. You can go to File and open your .mdf file
I am still investigating a proper way or application that can open it
I am currently trying this: https://msdn.microsoft.com/en-us/library/ms239722.aspx
I got the same and now trying the above link which uses Visual Studio
On SQL Server Management Studio you can
Right-click on databases >> Attach >> Browse and select your .mdf file
In my case I have permissions denied still trying to work through it
Ok I'll let you know once I get past it. If we succesfully import the db we can even use the bcp command to export
Alright go it now
You need to close the SQL Server Management Studio and run it as administrator i.e right-click on it and run as administrator
You will the be able to attach the mdf file without issues. After attaching it, on each table you can then:
Right-click in the table >> Script Table as >> SELECT To >> New Query Editor Window
The above will open a new window which retrieves everything from the table. No need to edit the query just run it and it will display all records from the table
The Righ-click on the results page just below the query >> Save Results as
The defaults will be a .csv format.
You just have to do it for each table I could not find a way to do all tables at once.
Please see attached and advice if you experience any difficulty
Hmm... strange. Let me investigate possible reasons.
The Agent and Browser are not important in our case
Please check this out: https://www.youtube.com/watch?v=tx2WhE3lQKE
Yes once your issue is resolved you can provide the rating. Not urgent.
Ok no prob. Lets make it tomorrow. When you get back to it close all programs that might be using the file including the SQL Server Management Studio and start it as admin
Alright, if it is shareable you may share the .mdf file to export the tables for you and send back
This is however not a private channel between us I'd have to send a premium service offer for a secure exchange of your file
Its also possible to work remotely on your pc but since you have tried all the tricks above I am not sure why it refuses to work on it
I am indeed. Thanks, ***** *****'ll send the offer shortly
I am not of the actions it will allow you to perform, but this is the request and you can accept the answer if it allows you to.
Thank you so much