Re: Migrate MSSQL Database (10+GB database size) to MySQL community

[Shamshad Ali]

Hiring is not in my control - again it will cost, It is sort of R&D, either we can go for switching from MSSQL to MySQL and save $s.

We can't go for Enterprise, it has to be paid $$.

Here, I am initiating some more errors, if someone understand, let comment who can best respond on this.


I can't share the DDL and data as it is not allowed, However, these errors may help in understanding the problem and your support may add some knowledge, how these can be handled. Its all about Learning and experience.


- `MyDB`.`tbl_TRENTRY`
Succeeded : copied 502491 of 502491 rows from [MyDB].[dbo].[tbl_TRENTRY]
- `MyDB`.`tbl_ACCOUNTS`
Succeeded : copied 1400871 of 1400871 rows from [MyDB].[dbo].[tbl_ACCOUNTS] error `MyDB`.`tbl_ACCOUNTS`:Found record bigger than max_allowed_packet error `MyDB`.`tbl_ACCOUNTS`:Failed copying 1399571 rows
- `MyDB`.`tbl_ACCOUNTS_HST`
error `MyDB`.`tbl_ACCOUNTS_HST`:Type mismatch fetching field 3 (should be string, was MYSQL_TYPE_LONG) error `MyDB`.`tbl_ACCOUNTS_HST`:Failed copying 1632291 rows error `MyDB`.`tbl_ACCOUNTS_HST`:Type mismatch fetching field 3 (should be string, was MYSQL_TYPE_LONG) error `MyDB`.`tbl_ACCOUNTS_HST`:Failed copying 1632291 rows
- `MyDB`.`tbl_ACCOUNTS_HST_OLD`
Succeeded : copied 0 of 0 rows from [MyDB].[dbo].[tbl_ACCOUNTS_HST_OLD] Succeeded : copied 0 of 0 rows from [MyDB].[dbo].[tbl_ACCOUNTS_HST_OLD]
- `MyDB`.`tbl_CONDUCTOR_DETAILS`
Succeeded : copied 485278 of 485278 rows from [MyDB].[dbo].[tbl_CONDUCTOR_DETAILS]
- `MyDB`.`tbl_TRANSACTIONS`
error `MyDB`.`tbl_TRANSACTIONS`:Inserting Data: Data too long for column 'Transaction_description' at row 1 error `MyDB`.`tbl_TRANSACTIONS`:Failed copying 485278 rows
- `MyDB`.`tbl_TRANSACTIONS_HST`
error `MyDB`.`tbl_TRANSACTIONS_HST`:Inserting Data: Data too long for column 'Transaction_description' at row 1 error `MyDB`.`tbl_TRANSACTIONS_HST`:Failed copying 625770 rows
- `MyDB`.`tbl_ACTIVITY`
Succeeded : copied 0 of 0 rows from [MyDB].[dbo].[tbl_ACTIVITY]
- `MyDB`.`tbl_GOODS_SERVICES`
Succeeded : copied 0 of 0 rows from [MyDB].[dbo].[tbl_GOODS_SERVICES]
- `dbo`.`tbl_ACCOUNTS`
error `dbo`.`tbl_ACCOUNTS`:Found record bigger than max_allowed_packet error `dbo`.`tbl_ACCOUNTS`:Failed copying 1400871 rows