MySQL Bugs: #15279: Could not use MySQL Migration Toolkit Transfer the DB

Bug #15279	Could not use MySQL Migration Toolkit Transfer the DB
Submitted:	28 Nov 2005 2:19	Modified:	1 Dec 2005 11:50
Reporter:	xi xin	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	1.0.20rc	OS:	Windows (Microsoft Windows Server 2003SP1)
Assigned to:		CPU Architecture:	Any

Description:
--------------------------------------------------------------------------------
-- MySQL Migration Toolkit Report --
-- --
-- Title: Summary Of The Migration Process --
-- Date: 2005-11-23 10:46 --
--------------------------------------------------------------------------------

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

Number of migrated schemata: 1

Schema Name: masterwork_dbo //note: this is a db in MSSQLSERVER8.0
(SQLSERVER2000)
- Tables: 0 //note: could not tranfer any table.
- Views: 0
- Routines: 0
- Routine Groups: 0
- Synonyms: 0
- Structured Types: 0
- Sequences: 0

Details:

- Tables
- Views
- Routines
- Routine Groups
- Synonyms
- Structured Types
- Sequences

2. Data Bulk Transfer
---------------------

How to repeat:
Just once, never repeated.
Repeated another time, but error at [Tasks to execute].

Suggested fix:
No idea.

Hi!

I was unable to reproduce this bug.  Can you please tell me exactly what you did to receive this error message ?

Thanks

In fact, this is first time I using Migration Toolkit in [Windows Server 2003 Standard Edition SP1],  fisrt tansfer succeed, but the result as [MySQL Bugs: #15279], at release times, the processure of tranfer are all stop at [Tasks to execute].And I had no idea of it.^_^
Maybe give up Migration Toolkit and using another way to solute such prublem.

Why rely such words always, if troble you much, 
you could send message clearly.

Thank you for a problem report. So, you are migrating something from MS SQL Server, right? What version of MySQL are you migrating to? Can you repeat the problem tyou described? Is there something special in your SQL Server database? How many tables? According to the information you provided you had not selected anything to migrate or something went absolutely wrong. That is why you were asked for more information, about the exact steps you performed.

ok, I could get such information:
MySQL version : MySQL SERVER Version 5.0.9-beta
The tables in SQLServer_v8.0 : caculate twice[ 110 tables/once, 113 tables/twice]
The situation for erroe occupetting : Bug #15279 occupetted just at first time;
                                                  Bug #15278 occupetted at reales time, and
                                                  the situation is never changed.

I think that maybe I could privoder for you at this time now.Sorry for my hurried 
words this before, in fact the Migration Toolkit let me imaging most at migratting 
the tables in SQLSERVER to MYSQLSERVER quickly.You know the price of SQLSERVER2005 is not that I could cost, The SQLSERVER updating was such 
taking longer steps(of course including tech and the fee)^_^.

Can you, please, try to migrate a simples MS SQL Server database, with one table. Describe what you get and see on each step.

Also, please, install MySQL 5.0.15 at least (GA release). 5.0.9 is old, it was beta, and many bugs in it were fixed already.

dear Valeriy:

   Very sorry, in fact, I got the version of 5.0.16(The lastes version,
that could get from http://dev.mysql.com/downloads/mysql/5.0.html),
but error still as #15279.

no, is #15278.

Duplicate of bug #15278. That bug report contains more detailed information of what the problem really is.