A
A
Al Sm2016-10-22 16:01:01
MySQL
Al Sm, 2016-10-22 16:01:01

Accessing db from bac backup and converting to mysql?

Hello. Please tell me, I got a database backup in *.bak, *.bakpac format.
Initially, the database on the server was in ms sql.
Tried installing different versions of MS SQL Server Studio Management etc.
But none of the programs managed to somehow deploy this backup.
Can you please tell me how to open this database?
And is it possible to somehow convert it to mysql format?
Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Nemiro, 2016-10-24
@radio_mus

You need to use the latest version of SQL Server because backup files created in newer versions of SQL Server cannot be restored in older ones.
As far as conversion is concerned, MySQL Workbench has functions to import data from SQL Server . SQL Server Management Studio
also has the ability to export to MySql via the .NET Framework Data Provider for MySql . But for this, you must first restore the SQL Server database .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question