Suljettu

Migrating Data from MSSQL to MYSQL

Objective - Migrate data from MSSQL on premise to MYSQL RDS AWS.

Environment -

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

Taidot: Tietokannan hallinto, Microsoft SQL Server, MySQL

Näytä lisää: migrate sql server to mysql using mysql workbench, import mssql to mysql, convert mssql to mysql free, mssql to mysql converter online, mysql workbench migration wizard, transfer data from sql server to mysql, mysql migration toolkit, convert mssql to mysql stored procedure, mysql offline data replication, mysql update data csv, mysql add data form, php mysql insert data, php mysql show data, php mysql import data, mysql export data

About the Employer:
( 1 review ) Mumbai, India

Projektin tunnus: #14808046

16 freelanceria on tarjonnut keskimäärin 10058 ₹ tähän työhön

mahmoudgamal008

I have more than 5 years of experience in both SQL Server and MySQL. I have migrated many databases before from SQL Server to MySQL and vis versa. Relevant Skills and Experience I have more than 1800 answers in Stacko Lisää

10000 ₹ INR 1 päivässä
(40 arvostelua)
5.5
maxpl

I am a full stack web developer from Poland, I have 6+ years of experience in webdesign/development, WordPress, E-commerce, Mobile Development (Android and IOS), SEO and done number of projects. Relevant Skills and Lisää

27777 ₹ INR 10 päivässä
(6 arvostelua)
4.7
mak94pk

Hi, Firstly, Thank you for reviewing my proposal. I have gone through your requirements and came to know that you need an expert web developer to build your website. I have strong knowledge and 3+ years experience in Lisää

7777 ₹ INR 3 päivässä
(11 arvostelua)
4.3
7777 ₹ INR 1 päivässä
(9 arvostelua)
4.0
7777 ₹ INR 3 päivässä
(3 arvostelua)
3.4
MYehia565

A proposal has not yet been provided

16500 ₹ INR 3 päivässä
(5 arvostelua)
3.8
7777 ₹ INR 3 päivässä
(3 arvostelua)
2.1
9998 ₹ INR 3 päivässä
(1 arvostelu)
1.2
ewway

I am production support oracle database Administrator/Architect with 15+ years of experience. I have done various database migrations MS Sql to MySQL oracle/MS SQL/MySql to oracle/MS SQL/MySql Relevant Skills and Ex Lisää

5555 ₹ INR 7 päivässä
(2 arvostelua)
1.1
7777 ₹ INR 3 päivässä
(3 arvostelua)
0.4
sorinoivanov

I have good experience on this. Relevant Skills and Experience Database Migration Proposed Milestones ₹5000 INR - Build migration part ₹6111 INR - Complete Project n

11111 ₹ INR 3 päivässä
(0 arvostelua)
0.0
maebrahim

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

11111 ₹ INR 3 päivässä
(0 arvostelua)
0.0
juying508

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.

5555 ₹ INR 3 päivässä
(0 arvostelua)
0.0
Udnalluri

A proposal has not yet been provided

7777 ₹ INR 3 päivässä
(0 arvostelua)
0.0
amankm

I've recently worked on this kind of project and have very good experience in this domain. I have been in this industry for 13 years, I am new and hence I do not have any ratings/testimonials to. Relevant Skills and Lisää

7777 ₹ INR 3 päivässä
(0 arvostelua)
2.4
8888 ₹ INR 3 päivässä
(0 arvostelua)
0.0