bak文件转换成sql文件,如何将bak文件转换为sql文件（sql bak文件到mysql支持）和执行该文件自动恢复...

最新推荐文章于 2024-12-31 11:08:23 发布

涡涡头

最新推荐文章于 2024-12-31 11:08:23 发布

阅读量776

点赞数

文章标签： bak文件转换成sql文件

博主想将SQL Server的bak文件转换成MySQL支持的.sql/.csv/.xml文件，还需脚本自动从服务器驱动器取文件并执行恢复到在线MySQL数据库。博主有两个基于VB的系统，想在新Web应用中实现文件转换和更新数据库，解决方案是使用MySql Migration Tool kit。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

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) .

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.

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