如何将bak文件转换为sql文件（sql bak文件到mysql支持）和执行该文件自动恢复 [英] How to convert bak file into sql file (sql bak file to mysql supported) and the execute that file to restore automatically

问题描述

我要将sql server的bak文件转换为.sql / .csv / .xml文件，用于mysql数据库。

i want to convert a bak file of sql server into .sql/.csv/.xml file for mysql database.

然后我需要一个脚本自动从服务器驱动器选择文件（假设文件在D盘在我的计算机和脚本将自动选择文件从D盘）和执行sql / csv文件恢复到我的sql数据库（在线）。

And then i need a script that will automatically pick the file from server drive(suppose file is in D drive in mycomputer and script will automatically pick file from D drive) and execute sql/csv file to restore into my sql database(online) .

其实我有两个系统，1-是在本地主机上运行的VB上，并在系统中每天生成一个bakup文件
，现在我要为同一个系统创建一个新的Web应用程序运行在VB上。
i希望在我的web应用程序中我写一个脚本，将选择和备份文件和ist转换为mysql supoported格式（sql / csv / xml）（如果必要），然后执行该文件更新到mysql在线数据库。

Actually i have two system, 1- is on VB that runs on local host and generates a bakup file daily in the system and now i am going to create a new web application for same system that runs on VB. i want that in my web application i write a script that will pick and backup file and ist convert into mysql supoported format(sql/csv/xml)(if necessary) and then execute that file for updating into mysql online database.

任何种类的帮助将会被高度认可。
可以通过使用MySql迁移工具包来实现。

ANy kind of help will be highly appericiated. many thanx in advance.

推荐答案

首先安装软件，请按照以下步骤操作：

Possible by using MySql Migration Tool kit. First install the software ,follow below steps

这篇关于如何将bak文件转换为sql文件（sql bak文件到mysql支持）和执行该文件自动恢复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！