blocks|key|1733272|text|来自SQL+server的.BAK文件为Microsoft磁带格式(MTF)+ref：http://www.fpns.net/willy/msbackup.htm|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1733273|bak文件可能包含SQL+server用来存储数据库的LDF和MDF文件。|1733274|您将需要使用SQL+server来提取这些内容。SQL+Server+Express是免费的，可以完成这项工作。|1733275|因此，安装SQL+Server+Express版，并打开SQL+Server+Powershell。在那里执行sqlcmd+-S+<COMPUTERNAME>\SQLExpress+(以管理员身份登录)|style|CODE|1733276|然后发出以下命令。|1733277|restore+filelistonly+from+disk='c:\temp\mydbName-2009-09-29-v10.bak';
GO|code-block|syntax|javascript|1733278|这将列出备份的内容-您需要的是告诉您逻辑名称的第一个字段-一个是实际的数据库，另一个是日志文件。|1733279|RESTORE+DATABASE+mydbName+FROM+disk='c:\temp\mydbName-2009-09-29-v10.bak'
WITH+
+++MOVE+'mydbName'+TO+'c:\temp\mydbName_data.mdf',+
+++MOVE+'mydbName_log'+TO+'c:\temp\mydbName_data.ldf';
GO|1733280|此时，您已经解压缩了数据库-然后，将Microsoft's+"Sql+Web+Data+Administrator".与this+export+tool一起安装，您将拥有一个包含该数据库的SQL脚本。|1733281|entityMap|0|LINK|mutability|MUTABLE|url|http://www.fpns.net/willy/msbackup.htm|1|http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en|2|http://www.eggheadcafe.com/articles/20040913.asp^0|17|12|0|0|0|0|1J|Z|0|0|0|0|0|I|15|1|1O|G|2|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|D|3|E|5|6|7|1E|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1F|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|1G|8|@$A|1H|B|1I|J|K]]|9|@]|C|$]]|$1|L|3|M|5|6|7|1J|8|@]|9|@]|C|$]]|$1|N|3|O|5|P|7|1K|8|@]|9|@]|C|$Q|R]]|$1|S|3|T|5|6|7|1L|8|@]|9|@]|C|$]]|$1|U|3|V|5|P|7|1M|8|@]|9|@]|C|$Q|R]]|$1|W|3|X|5|6|7|1N|8|@]|9|@$A|1O|B|1P|1|1Q]|$A|1R|B|1S|1|1T]]|C|$]]|$1|Y|3|-4|5|6|7|1U|8|@]|9|@]|C|$]]]|Z|$10|$5|11|12|13|C|$14|15]]|16|$5|11|12|13|C|$14|17]]|18|$5|11|12|13|C|$14|19]]]]

The .BAK files from SQL server are in Microsoft Tape Format (MTF) ref: <a href="http://www.fpns.net/willy/msbackup.htm" rel="noreferrer">http://www.fpns.net/willy/msbackup.htm</a>

The bak file will probably contain the LDF and MDF files that SQL server uses to store the database.

You will need to use SQL server to extract these. SQL Server Express is free and will do the job.

So, install SQL Server Express edition, and open the SQL Server Powershell. There execute <code>sqlcmd -S &lt;COMPUTERNAME&gt;\SQLExpress</code> (whilst logged in as administrator)

then issue the following command.

<pre><code>restore filelistonly from disk='c:\temp\mydbName-2009-09-29-v10.bak';
GO
</code></pre>

This will list the contents of the backup - what you need is the first fields that tell you the logical names - one will be the actual database and the other the log file.

<pre><code>RESTORE DATABASE mydbName FROM disk='c:\temp\mydbName-2009-09-29-v10.bak'
WITH 
 MOVE 'mydbName' TO 'c:\temp\mydbName_data.mdf', 
 MOVE 'mydbName_log' TO 'c:\temp\mydbName_data.ldf';
GO
</code></pre>

At this point you have extracted the database - then install <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&amp;displaylang=en" rel="noreferrer">Microsoft's "Sql Web Data Administrator".</a> together with <a href="http://www.eggheadcafe.com/articles/20040913.asp" rel="noreferrer">this export tool</a> and you will have an SQL script that contains the database.

blocks|key|1518362|text|我没有设法找到一种直接做这件事的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1518363|相反，我将bak文件导入SQL+Server2008Express，然后使用MySQL+Migration+Toolkit。|offset|length|1518364|像护身符一样工作！|1518365|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/migration-toolkit/en/index.html^0|0|12|N|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

I did not manage to find a way to do it directly.

Instead I imported the bak file into SQL Server 2008 Express, and then used <a href="http://dev.mysql.com/doc/migration-toolkit/en/index.html" rel="noreferrer">MySQL Migration Toolkit</a>.

Worked like a charm!

blocks|key|1733151|text|虽然我的MySQL背景有限，但我不认为你会有太多的幸运。但是，通过将数据库恢复到MSSQL服务器，然后创建一个SSIS或DTS包以将表和数据发送到MySQL服务器，您应该能够迁移所有数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1733152|希望这能有所帮助|1733153|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Although my MySQL background is limited, I don't think you have much luck doing that. However, you should be able to migrate over all of your data by restoring the db to a MSSQL server, then creating a SSIS or DTS package to send your tables and data to the MySQL server.

hope this helps

blocks|key|1518228|text|我对此深表怀疑。您可能希望使用DTS/SSIS来完成此操作，就像Levi所说的那样。一种认为您可能想要做的是在不实际导入数据的情况下启动该过程。只要做足够的工作就可以获得基本的表结构。然后，您将希望围绕结果表结构进行更改，因为无论创建的是什么结构tat，充其量都是不稳定的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1518229|您可能还需要更进一步，创建一个临时区域，该区域首先以字符串(varchar)形式接收所有数据。然后，您可以创建一个执行验证和转换的脚本，将其放入“真正的”数据库中，因为这两个数据库并不总是能很好地协同工作，尤其是在处理日期时。|1518230|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I highly doubt it. You might want to use DTS/SSIS to do this as Levi says. One think that you might want to do is start the process without actually importing the data. Just do enough to get the basic table structures together. Then you are going to want to change around the resulting table structure, because whatever structure tat will likely be created will be shaky at best.

You might also have to take this a step further and create a staging area that takes in all the data first n a string (varchar) form. Then you can create a script that does validation and conversion to get it into the "real" database, because the two databases don't always work well together, especially when dealing with dates.

blocks|key|1733396|text|对于那些尝试上面Richard的解决方案的人，这里有一些可能有助于导航常见错误的附加信息：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1733397|1)运行restore+filelistonly时，您可能会收到操作系统错误5(访问被拒绝)。如果是这种情况，请打开SQL+Server配置管理器，并将SQLEXPRESS的登录名更改为具有本地写入权限的用户。|1733398|2)+@“这将列出备份的内容-您需要的是告诉您逻辑名称的第一个字段”-如果您的文件列出了两个以上的头文件，您还需要在RESTORE+DATABASE命令中说明如何处理这些文件。如果您没有指明如何处理数据库和日志以外的文件，系统显然会尝试使用.bak文件中列出的属性。从其他人的环境中恢复文件将产生一个“该路径具有无效属性。它需要是一个目录”(因为该路径在您的计算机上不存在)。只需提供一条MOVE语句就可以解决此问题。|1733399|在我的例子中，有第三个FTData类型的文件。我添加的移动命令：|1733400|MOVE+'mydbName_log'+TO+'c:\temp\mydbName_data.ldf',
MOVE+'sysft_...'+TO+'c:\temp\other';|code-block|syntax|javascript|1733401|在我的例子中，我实际上必须为第三个文件创建一个新目录。最初，我试图将其发送到与.mdf文件相同的文件夹中，但在执行恢复时，在第三个FTData文件上产生了“无法正确初始化”错误。|1733402|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|U|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

For those attempting Richard's solution above, here are some additional information that might help navigate common errors:

1) When running restore filelistonly you may get Operating system error 5(Access is denied). If that's the case, open SQL Server Configuration Manager and change the login for SQLEXPRESS to a user that has local write privileges.

2) @"This will list the contents of the backup - what you need is the first fields that tell you the logical names" - if your file lists more than two headers you will need to also account for what to do with those files in the RESTORE DATABASE command. If you don't indicate what to do with files beyond the database and the log, the system will apparently try to use the attributes listed in the .bak file. Restoring a file from someone else's environment will produce a 'The path has invalid attributes. It needs to be a directory' (as the path in question doesn't exist on your machine).
Simply providing a MOVE statement resolves this problem. 

In my case there was a third FTData type file. The MOVE command I added:

<pre><code>MOVE 'mydbName_log' TO 'c:\temp\mydbName_data.ldf',
MOVE 'sysft_...' TO 'c:\temp\other';
</code></pre>

in my case I actually had to make a new directory for the third file. Initially I tried to send it to the same folder as the .mdf file but that produced a 'failed to initialize correctly' error on the third FTData file when I executed the restore.

blocks|key|1733467|text|SQL+Server中.bak文件特定于数据库方言，且与MySQL不兼容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1733468|尝试使用etlalchemy将SQL+Server数据库迁移到MySQL。它是我创建的一个开源工具，用于简化不同RDBMS之间的迁移。|offset|length|1733469|这里在the+github+page上提供了快速安装和示例，并且可以在here中找到关于项目起源的更详细解释。|1733470|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/seanharr11/etlalchemy|1|2|http://thelaziestprogrammer.com/sharrington/databases/migrating-between-databases-with-etlalchemy^0|0|4|A|0|0|3|F|1|Z|4|2|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]|$D|11|E|12|1|13]]|A|$]]|$1|H|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|O]]|Q|$5|K|L|M|A|$N|R]]]]

The .bak file from SQL Server is specific to that database dialect, and not compatible with MySQL.

Try using <a href="https://github.com/seanharr11/etlalchemy" rel="nofollow">etlalchemy</a> to migrate your SQL Server database into MySQL. It is an open-sourced tool that I created to facilitate easy migrations between different RDBMS's. 

Quick installation and examples are provided here on <a href="https://github.com/seanharr11/etlalchemy" rel="nofollow">the github page</a>, and a more detailed explanation of the project's origins can be found <a href="http://thelaziestprogrammer.com/sharrington/databases/migrating-between-databases-with-etlalchemy" rel="nofollow">here</a>.

The title is self explanatory. Is there a way of directly doing such kind of importing?

How to import a SQL Server .bak file into MySQL?

日志文件

SQL Server

数据库

服务器

MySQL

标题是不言而喻的。有没有一种直接进行这种导入的方法？

问如何在MySQL中导入SQL Server .bak文件？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL中导入SQL Server .bak文件？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL中导入SQL Server .bak文件？
EN