CODEWITHSUNDEEP
mysqlsql-server
user2069927
user2069927

Reputation: 1

Importing .bak from MSSQL into MySQL database

My companies site uses a mysql database. One of our clients just trying to take advantage of our API is only able to give us the data in the form of a MSSQL .bak file I have been trying to import the file using the migration tool built inot mysql workbench but have no luck. On top of that I am trying to see if this can be done in powershell as I would like to automate this process in the future. Any suggestions or help would be appreciated

Upvotes: 0

Views: 317

Answers (1)

alroc
alroc

Reputation: 28174

You cannot. MS SQL Server backups are proprietary to MS SQL Server and cannot be used with any other RDBMS. You will need to restore this backup to SQL Server, then use an additional tool to transfer the data from SQL Server into MySQL.

Can you do that second portion through PowerShell? Probably. Though SSIS would probably be a better method.

Upvotes: 2

Related Questions