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.

Fabio1.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)|||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.|||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|||Nobody has ideas??

I'm still stick on this...

Thanks...|||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|||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|||why dont u install latest service pack and try.U can download latest service pack from microsoft.|||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