MySQL迁移工具包& SQL Express
我正在尝试将数据库从 SQL Server Express 移植到我的 MySQL 数据库。我已确保 SQL Express 在端口 1433 等上运行，MySQL 迁移工具包甚至能够看到我的 SQL Server Express 数据库中的不同数据库/模式。
问题是 MySql 迁移工具包不会让我按“下一步”，直到我输入用户名/密码，这对我来说没有意义，因为它能够连接到 Express DB 并查看所有没有这些模式的模式。
我尝试使用“高级”设置直接指定连接字符串，但这对我来说也不起作用。我可能把字符串弄错了。帮助？
I'm trying to port a database from SQL Server Express over to my MySQL database. I've made sure the SQL Express is running on port 1433 and all, and the MySQL Migration toolkit is even able to see the different databases/schemas I have in my SQL Server Express DB.
The problem is that MySql Migration toolkit won't let me press "next" until I enter a username/password, which doesn't make sense to me since it is able to connect to the Express DB and view all of the schemas without those.
I've tried using the "advanced" settings to directly specify the connection string, but that's not working for me either. I'm probably getting the string wrong. Help?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
好的。在源数据库中选择 MS SQL Server。在高级设置中写入
jdbc:jtds:sqlserver://10.210.4.2:1433/INFRASTRUCTURE;instance=MENG;user=sa;password=XXX;charset=utf-8;domain=
测试与 clic 按钮数据库的连接以检索列表来自服务器。
如果没有连接，则：
啊!并启用并启动 SqlServer Browser 服务！
嗯，填写另一个文本框以激活下一个按钮。
MySqling 快乐！
OK. In Source Database select MS SQL Server. In Advanced Settings write
jdbc:jtds:sqlserver://10.210.4.2:1433/INFRASTRUCTURE;instance=MENG;user=sa;password=XXX;charset=utf-8;domain=
Test your connection with clic button database to retrive list from server.
If no conect then:
Ah! and enable and Start SqlServer Browser service!
Uhhh fill the other text box to activate the next button.
Happy MySqling!
对于任何其他试图获得这项工作的可怜人，请尝试一下。为 SQL Express 启用 TCP/IP 连接似乎可以解决问题。
http://www.pierrebuckley。 com/2010/06/02/resolving-connection-error-with-mysql-migration-toolkit/
For any other poor soul trying to get this work, try this. Enabling TCP/IP connections for SQL express seems to do the trick.
http://www.pierrebuckley.com/2010/06/02/resolving-connection-error-with-mysql-migration-toolkit/
默认情况下，SQL Express 具有用户“sa”和空密码的访问权限。尝试一下。
By default SQL Express has access for user 'sa' and empty password. Try that.
啊哈！我得到了它！我能够使用这个连接字符串使其工作：
我将其放在高级文本框中，然后只是一个用于用户名的空格（不过可能是任何东西）。
（sa 和空密码技巧对我不起作用）
Ahah! I got it! I was able to make it work using this connection string:
I put that in the advanced text box, and then just a space for the username (that probably could have been anything though).
(The sa and empty password trick wouldn't work for me)