在哪里找到Microsoft的Microsoft SQL 2000的还原软盘? [英] Where find restore soft for microsoft my sql 2000 ?

问题描述

在哪里找到Microsoft my sql 2000的还原软软件?
我们如何从mysqldump文件中恢复具有不同名称的mysql数据库.我不想打开转储文件并对其进行编辑.还有其他更好的方法吗?

Where find restore soft for microsoft my sql 2000 ?
How can we restore mysql database with different name from mysqldump file. I dont''t want to open dump file and edit it. Any other better methods?

推荐答案

........
........
........
A)
好的.你不能首先，因为没有像 microsoft my sql 2000 这样的产品.您有 mysql 或 Microsoft SQL Server 或两者都有，但是没有它们的混合.而且，您无法将mysqldump输出直接导入到任何Microsoft SQL Server中.好吧，这不一定是正确的，因为mysqldump能够产生可以在SQL Server中执行的输出，但是只能在非常严格的情况下执行.

但是为什么要这么做?
您可以使用 SSMA [ 如果要从mysql还原到mysql到另一个数据库，请执行以下操作:
http://alvinalexander.com/blog/post/mysql/how- restore-mysql-database-from-backup-file [ ^ ]
但是您要么需要排除转储数据库的创建(不要添加-数据库)，要么需要编辑文件...

........
........
........
A)
Ok. You can''t. First of all, because there is nothing like microsoft my sql 2000. You have either mysql or Microsoft SQL Server or both, but there is no mixture of them. And no way you can import mysqldump output into any Microsoft SQL Server directly. Well, this is not necessarily true, as mysqldump is able to produce output that can be executed in SQL Server but only under really strict circumstances.

But why do you want to do this?
You can use SSMA[^] to facilitate migration. And you can also use other tools to copy data from a live MySQL instance to a live SQL Server instance. But there is no automatic method to transcribe programatic assets.

B) "microsoft" was just an acronym of "windows"... and 2000 was just misstyping...
If you want to restore from mysql to mysql into a different database, follwo this:
http://alvinalexander.com/blog/post/mysql/how-restore-mysql-database-from-backup-file[^]
But you either need to exclude dumping database creation (don not add --databases), or you will need to edit the file...

这篇关于在哪里找到Microsoft的Microsoft SQL 2000的还原软盘?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！