Objective - Migrate data from MSSQL on premise to MYSQL RDS AWS.
Source MSSQL 2008 r2 - Characterset Latin1
Destination - MYSQL 5.7 Character set utf8mb4
Problem - While migrating data using AWS DMS tool the task fails with invalid UTF8 character as some of the data in the source table has non asci (Unicode) character set. hence cannot use AWS DMS since it uses UTF8 character set to migrate.
End objective is to migrate with reconciling row count and sum of numeric value of database please have data kept in replication mode to propagate any new changes done on SQL to be replicated in MySQL.
few mins lag is acceptable as this is only required for the cutover process.
Total number of tables approx 470
Total size of DB approx 100 gb
I have put a placeholder price but need to discuss more to price it appropriately. open to discussion on price.
15 freelancere byder i gennemsnit ₹9988 for dette job
MSSQL to MySQL, 470 tables, 100GB Relevant Skills and Experience MS SQL, MySQL Proposed Milestones ₹5555.5 INR - Convert table structures to MySQL ₹5555.5 INR - Migrate data
Hi,Sir. Thanks for considering my proposal. I think that I am suitable person for your project and I can finish it in time. Hope to get a positive response from your side. Please hire me. Thanks & Regards.