Ask a Question
All Questions All Unanswered FAQ
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
database
Hi,
We are migrating Ms-Sql to MySql So i am trying to Restore form .bak file in mysql its not happening .Can any one please help me out
Thanks & Regards
Mahi
Posted 5-May-15 1:43am
Member 11270910
Add a Solution
Comments
hypermellow 5-May-15 7:48am
Are you trying to restore a MSSQL .bak file directly into MySql?
Member 11564708 5-May-15 13:30pm
Yes,i need to get Sql database into my new MySql database.
ZurdoDev 5-May-15 8:02am
I don't know MySql but I seriously doubt it supports Microsoft Sql files.
1 solution
Please Sign up or sign in to vote.
Solution 1
You can't restore a MSSQL .bak file to MySql.
You have to migrate the data :
//mysqlworkbench.org/2012/07/migrating-from-ms-sql-server-to-mysql-using-workbench-migration-wizard/[^]
//www.mysql.com/why-mysql/white-papers/guide-to-migrating-from-sql-server-to-mysql/[^]
Permalink
Share this answer
Posted 5-May-15 2:10am
Mehdi Gholam
Comments
Member 11564708 8-May-15 3:24am
Thank you soo much for your accurate response.I have done my restoring but some tables not restoring which are having indexes . do you any idea .
Mehdi Gholam 8-May-15 4:43am
Indexes should not have any effect on the data migration, your problem is somewhere else, check the log from migration process for errors
Add a Solution
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Top Experts | |||||||||||||||||||||
Last 24hrs | This month | ||||||||||||||||||||
|
|
Related Questions
DATABASE RESTORE FROM .bak File
.bak files cannot found in actual directory location?
Restore multi database from one .BAK
How to restore .bak file of SQL Server 2005 database
Mysql Database Restore
how to restore multiple database file(.bak) in sqlserver 2008
Trying to restore a local .BAK file to a remote SQL Server (on GoDaddy)
sql error to add .bak file
How to restore SQL 2005 .bak file using C# where the database is in use.
Not able to restore a .bak file taken from another pc
Advertise
Privacy
Cookies
Terms of Use
Last Updated 5 May 2015
Layout: fixed | fluid
Copyright © CodeProject, 1999-2022
All Rights Reserved.
Web01 2.8:2022-09-22:1
CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900