Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2006
    Posts
    7

    Unanswered: from MSSQL server to MySQL

    Hi everybody,

    I have to port a database from MSSQL to MySQL.
    I'm really a newbie with MSSQL and I need some hints on how to do this task.

    I received a .bak file which my boss told me that this a backup of the database
    I have to port.

    Then I installed MSQL 2000 developer edition on my workstation and then started
    playing with it.

    The problem is that I don't know how to connect to the database... and with what
    application do some queries. In mysql I use phpMyAdmin which is really useful.
    Is there something similar for SQL server? Or something like sqlplus under Oracle?

    Moreover how can I install the .BAK file they sent me on my MSSQL install in order
    to recreate the db on my workstation??

    Thank you.

    Fabio

  2. #2
    Join Date
    Jun 2003
    Posts
    269

    Thumbs up

    1.Start-->Programs-->Micrsoft Sql Server-->Enterprise manager(click)

    2.right click on databases--> All tasks--> Restore Database
    3. Enter database name,select 'From Device' -->Select Device--> Add
    and map to ur backup file (.bak)
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by fax8
    Hi everybody,

    I have to port a database from MSSQL to MySQL.
    I'm really a newbie with MSSQL and I need some hints on how to do this task.

    I received a .bak file which my boss told me that this a backup of the database
    I have to port.

    Then I installed MSQL 2000 developer edition on my workstation and then started
    playing with it.

    The problem is that I don't know how to connect to the database... and with what
    application do some queries. In mysql I use phpMyAdmin which is really useful.
    Is there something similar for SQL server? Or something like sqlplus under Oracle?

    Moreover how can I install the .BAK file they sent me on my MSSQL install in order
    to recreate the db on my workstation??

    Thank you.

    Fabio

    use query analyser for writing the queries its similar to sqlplus but alot more rich in features.
    to restore the database use enterprise manager. refer BOL for more info.

  4. #4
    Join Date
    Feb 2006
    Posts
    7
    ok.. thank you all.
    I understood the steps.. but I'm getting an ugly error...

    The backup of the system database on device BackupExecSqlAgent_master_00 cannot be restored because it was created by a different version of the server (134218262) than this server (134217922).


    Seems that my db version is older than the one I have.
    Seems that I have to install some upgrades to my server..

    How can I do this?

    Thanks
    Fabio

  5. #5
    Join Date
    Feb 2006
    Posts
    7
    Nobody has ideas??

    I'm still stick on this...

    Thanks...

  6. #6
    Join Date
    Jun 2003
    Posts
    269

    Question

    Quote Originally Posted by fax8
    ok.. thank you all.
    I understood the steps.. but I'm getting an ugly error...

    The backup of the system database on device BackupExecSqlAgent_master_00 cannot be restored because it was created by a different version of the server (134218262) than this server (134217922).


    Seems that my db version is older than the one I have.
    Seems that I have to install some upgrades to my server..

    How can I do this?

    Thanks
    Fabio
    tell me more abt the .bak file u got.From which datbase u got the back up,what version etc
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  7. #7
    Join Date
    Feb 2006
    Posts
    7
    the .bak file is a backup made by a hosting company which runs mssql 2000.
    The problem seems to be that they run a different release of mssql 2000 than mine.
    (probably a service pack release or something similar)

    Then when I try to load the database it hangs with that error..

    Sorry but I don't know what else tell you...
    If you need more information you can ask..

    Thank you a lot

  8. #8
    Join Date
    Jun 2003
    Posts
    269
    why dont u install latest service pack and try.U can download latest service pack from microsoft.
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  9. #9
    Join Date
    Feb 2006
    Posts
    7
    Thank you!!!

    I installed the latest service pack and I open the database!

    Thank you mallier!!
    And thank you harshal_in for your hints.

    Fabio

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •