Hi, I have a client who has a current website based on an MS SQL database. I am building a new website that will be in MySQL.
I have never used MSSQL before and the only information that i have been sent by the old web designer is a .bak file (which is the latest back-up of the MS SQL info) and the user name and password for the current on-line databases.
I dont know how to open this .bak file, ideally i would like to get it into MS excel or MS access. I have downloaded
SQL Server Management Studio Express and SQL Server Configuration Manager but i dont know what to do next (and am really confused!)
Can anyone advise me of the steps that i need to take to get the data out of the .bak file?
I would be VERY greateful of any assistance.
Go to the complete details ...