|
Title: Anyone know how to convert SQL files to MDB? Post by: Barry Scott on Wednesday, July 4, 2007, 08:13:48 I have a sql back up which i would like to open and use locally or restore to a server.
I've only had a quick browse, but have a feeling someone on here may have an answer. Does anyone know of any programs that can do this please? Thanks Title: Anyone know how to convert SQL files to MDB? Post by: land_of_bo on Wednesday, July 4, 2007, 12:48:22 Is the DB less than 4GB?
If so, you should be able to download the free MSDE http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en and restore your database into that Title: Anyone know how to convert SQL files to MDB? Post by: Barry Scott on Wednesday, July 4, 2007, 13:06:39 Quote from: "land_of_bo" Is the DB less than 4GB? If so, you should be able to download the free MSDE http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en and restore your database into that Yeah, it's only 360mb. I'll give that a whirl, thanks Mr Bo. 8) Title: Anyone know how to convert SQL files to MDB? Post by: STFC_Manc on Wednesday, July 4, 2007, 17:17:53 Have you got a mysql server on your PC? I use Xammp http://www.apachefriends.org/en/xampp.html I installed this and then i could set a sql server on the pc. If you need a hand, give me a pm. It took me a while, but its really east to set up.
Title: Anyone know how to convert SQL files to MDB? Post by: Barry Scott on Wednesday, July 4, 2007, 18:17:30 Thanks. I'll have a butcher's at that. I can't seem to get MSDE working how i thought it would.
I'll download Xammp and have a go later tonight or tomorrow and then drop you a pm should i get stuck. Have you used it? Can i, for want of a better word, simply 'unpack' the database? Title: Anyone know how to convert SQL files to MDB? Post by: Lash_sumthin on Wednesday, July 4, 2007, 18:19:43 yeah we used xammp at uni to get an sql server on the go, nice little app
Title: Anyone know how to convert SQL files to MDB? Post by: STFC_Manc on Wednesday, July 4, 2007, 18:33:24 Quote from: "Barry Scott" Thanks. I'll have a butcher's at that. I can't seem to get MSDE working how i thought it would. I'll download Xammp and have a go later tonight or tomorrow and then drop you a pm should i get stuck. Have you used it? Can i, for want of a better word, simply 'unpack' the database? well you need to set it up first, then export your database from where it is now, in mysql form then import it, quite easy. |