X
X
Xambey2017-10-13 21:47:02
MySQL
Xambey, 2017-10-13 21:47:02

Converting MS SQL database to MySql database without a server?

Hello! Faced such problem: there is MS SQL Server (2016) on which there is some database X, I need to convert it (DB) into a database for MySql.
What I have done so far:

  1. I made a backup of the database through MS SQL Management Studio, i.e. I have a bak file for migration + LDF and MDF files of the database
  2. Googled how migrations are done, chose MySql Workbench for this
  3. Passed the stage of connection to MS SQL Server, everything is fine

Here I ran into a problem: I need to set up a connection to the target MySql server, but at the moment I don’t have it, because it won’t be on this machine.
Question:
What do I need to do to get just a backup file of my database, but only for MySql? Or maybe you know some other program that can do this?
So that after n-th amount of time, using recovery tools, restore my database on Y MySql Server?
PS There is decent data, bak weighs 500Mb, there is a lot of information about users (about 200k users of chats), backups, if any, there is also a virtual machine with Linux for testing

Answer the question

In order to leave comments, you need to log in

1 answer(s)
T
ThunderCat, 2017-10-13
@Xambey

there is also a virtual machine with Linux for testing

sudo apt-get install mysql-server
fails?
UPD: get SQL

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question