MySQL Bugs: #40010: Source & Target Information Getting Misplace

Bug #40010	Source & Target Information Getting Misplace
Submitted:	14 Oct 2008 5:33	Modified:	14 Oct 2008 20:38
Reporter:	chris rackley	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.1.12	OS:	Windows (Vista Home Preminum)
Assigned to:		CPU Architecture:	Any

Description:
I am migrating from a MSSQL on one server to a MYSQL on another server. I enter all the information for the source (the MSSQL) and all the info for the target (the MYSQL).

The program does all its checks and says everything is fine. Once I get to the last screen however it shows an error that access was denied and when actually looking at the report, it tried to use the source and target as the MSSQL.

Why??

How to repeat:
Migrate from a MSSQL on one server to a MYSQL on another server

Thank you for a problem report. What exact version of Migration Toolkit do you use?

just updated the version number. 

thanks

Thank you for the bug report. I couldn't repeat with small sample created on XP running SQL Server 2005:

1> create database db8
2> go
1> use db8
2> create table tb8 (id int)
3> go
Changed database context to 'db8'.
1> insert into tb8 values (1)
2> go

(1 rows affected)
1>

On Linux granted an user:

[miguel@hegel dbs]$ 5.0/bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.72-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on *.* to 'miguel'@'%' identified by 'miguel';
Query OK, 0 rows affected (0.00 sec)

Running Migration Toolkit on XP:

--------------------------------------------------------------------------------
-- MySQL Migration Toolkit Report                                             --
--                                                                            --
-- Title:   Summary Of The Migration Process                                  --
-- Date:    2008-10-14 17:32                                                  --
--------------------------------------------------------------------------------

1. Schema Migration
-------------------

  Number of migrated schemata: 1

  Schema Name:            db8_dbo
  - Tables:               1
  - Views:                0
  - Routines:             0
  - Routine Groups:       0
  - Synonyms:             0
  - Structured Types:     0
  - Sequences:            0

  Details:

  - Tables
      `db8_dbo`.`tb8`
      ---------------
  - Views
  - Routines
  - Routine Groups
  - Synonyms
  - Structured Types
  - Sequences

and the database and tables was migrate to the Linux server:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| db8_dbo            | 
| mysql              | 
| test               | 
+--------------------+
4 rows in set (0.02 sec)

mysql> use db8_dbo
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------+
| Tables_in_db8_dbo |
+-------------------+
| tb8               | 
+-------------------+
1 row in set (0.00 sec)

mysql> select * from tb8;
+------+
| id   |
+------+
|    1 | 
+------+
1 row in set (0.01 sec)

mysql>