#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Posts
    375
    Rep Power
    14

    Big problem with ms sql


    i got a .bak file from someone. supposedly this is the backup of the ms sql server. unfortunately i do not have ms sql installed on my computer and i can't seem to open the file in notepad. how can i convert this file to either access so that i can view the contents of the db or how can i convert it to mysql server (which i have).
    thanks for your help. i am struggling with this.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    You need SQLServer or MSDE to restore the .bak file and export to csv or other suitable format
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Posts
    375
    Rep Power
    14
    I tried to install it but I am having too many problems installing the MDSE. It keeps telling me something about the security of sa.
    I am running windows xp. there is no easier way to do this?
  6. #4
  7. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    What does it tell you? C'mon ...
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Posts
    375
    Rep Power
    14
    It tells me:

    "A strong SA password is required for security reasons. Please use SAPWD switch to apply the same. Refer to readme for more details."

    Then the readme said to go to the command prompt and switch the password but my command promt tells me it doesn't recongnize the command.
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Posts
    375
    Rep Power
    14
    ok. that was a stupid mistake. i installed mssql server. how do i exactly import this bak file and then reexport it to csv. will i then be able to import it into mysql when it is a csv file?
  12. #7
  13. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    You have to "Attach database"
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Posts
    375
    Rep Power
    14
    maybe the installation didn't work out properly but i don't seem to have any program to open that will allow me to attach a database. i only have something taht tells me to stop or start the database. am i not looking for it in the right place?
  16. #9
  17. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Posts
    375
    Rep Power
    14
    ok. i found out there is no console for the free version of MSDE. does anyone know another way I can use MSDE to restore the .bak file of the database and then export it to mySQL?
  18. #10
  19. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538

IMN logo majestic logo threadwatch logo seochat tools logo