将数据库从 Sql Server 2008 迁移到 MySql? [英] Migrate database from Sql Server 2008 to MySql?

问题描述

我想使用 MySql Migration Toolkit 工具将数据库从 Sql Server 2008 迁移到 MySql，但是当该工具建立数据库连接时，我收到此错误:

i want migrate a database from Sql Server 2008 to MySql using a the tool MySql Migration Toolkit but when the tool is establishing the database connection i receive this error :

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ... 
Driver class MS SQL JDBC Driver
Opening connection ... 
Connection jdbc:jtds:sqlserver://localhost:1433/Northwind;user=sa;password=;charset=utf-8;domain=
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMssql.getSchemata :Login failed for user 'sa'.
Details: 
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringMssql.getSchemata(ReverseEngineeringMssql.java:99)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

在 SQL Server 中，我没有用户名和密码来连接到数据库(窗口身份验证)，因此在 SQL 的连接参数中，我在用户名字段 = "sa" 中插入并将字段密码留空.

in SQL Server i have not user and password to connect to the database(Window Authentication) so in the Connection Parameter of SQL i insert in the Username field = "sa" and leaving blank the field password.

您知道为什么我会收到此错误以及如何解决此问题吗?

Do you have any idea why i receive this Error and how work out this issue?

非常感谢您的关注.

干杯:)

推荐答案

尝试使用 SQL Examiner Suite 2010:该工具迁移表/视图/用户和数据，并有全功能的 30 天试用版，因此您可以使用试用版执行迁移:)

Try to use SQL Examiner Suite 2010: the tool migrates tables/views/users and data and have full-featured 30-days trial, so you can perform migration with trial version :)

这篇关于将数据库从 Sql Server 2008 迁移到 MySql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！