02 Migrate data from SQL Server to MySQL using SSIS

02 Migrate data from SQL Server to MySQL using SSIS
sql-mode="NO_ENGINE_SUBSTITUTION,ANSI_QUOTES"
DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=localhost;DATABASE=test;UID=root;Password=mysql123
Download the file\script used in the Video from below link

Migrate data from SQL Server to MySQL using SSIS
How do I export data from SQL Server to MySQL?
How do I transfer data from MySQL to SQL Server using SSIS?
Can SSIS be used for data migration?
Can SSIS connect to MySQL?

Happy Learning.

[ah__]

thank you so match.
whats change if i want to make migration from oracle to mysql ?

[ipelengmekgwe]

The problem is the ANSI drivers. You don't need to update the my.ini file, you need to use the Unicode drivers, Driver={MySQL ODBC 8.4 Unicode Driver}

[balamuruganpjb]

Guys, if you are facing the driver error while selecting the tables - use select queries to fetch data.

[swapnilvmestry]

I'm facing issue columns cannot convert between unicode to non unicode strings
Please help me on this

[pradnyakasar]

Test connection failed because of an error in initializing provider. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified....how to resolve that?

[TestVM-fwuo]

Please guide me on know how to execute the MySQL statement from MySQL DB (not the SQL server) using Execute SQL task? I have tried using ODBC connection but I am getting an error "[Execute SQL Task] Error: Failed to acquire connection "MySQLDB-32". Connection may not be configured correctly or you may not have the right permissions on this connection.

[PawanKumarSingh-giyj]

@learn ssis, can we populate scd data from sql server to mysql if yes, pleaes let me know. actually I am facing issues and unable to do so. Pleaes help if possible.

[pradnyakasar]

test connection failed because of an error in initializing provider connection string property has been not initialized, I am getting this error

[hoangminhninh]

I encounter performance issue when inserting into MySQL, 30 records/sec, the table is new, I tried other DB destinations like SQL Server, Postgress, it's fine. Did you have the same issue

[mirzajafarov]

hI, but mysql database on linux server and i cant handle 4200 error because i cant find my.inf file. Can u help me with another video or something?

[quanweizhang]

When I tried to set up connection to mysql, it failed with error below. Any suggestions? Thanks

Test connection failed because of an error in initializing provider. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[sameershaikh-fnuc]

How can i migrate a whole database which contains tables, stored procedure and views i tried with mysql work bench but sp didn't migrate and i founded mis match rows count in between 2 server

[pradnyakasar]

when I am going in OLE db source and in New option there will not any option means in data connection, there is not showing any option, how to resolve that?

[faizanmajid]

Great video sir. Thank you for teaching us these things via these videos.

[ChokoDemon]

thanks a lot <3 such a usefull video

[pradnyakasar]

My 1 table containing data upto 10Lakh, how to migrate from sql server to mysql?

[mundodaisa]

Very nice! I need to migrate around 20 tables from, which is the better way to do it?

[ericsos]

This is very informative video. Great job.I have always get confused with the implementation between SQL SERVER and MySQL. You have cleared me some doubts. Awesome project..
So i would like to know how can i populate different ODS table from one single table of another database? ok like i have created a ODS Layer(a database i named Prospect_ODS) and created 3 different tables so i would love now to populate these 3 different tables from another single table that belong in another database i named Prospect_DW. How can i do it using SSIS and loading it without duplicate data? thank you Aqil and i will be much appreciate for a little help ..

Thanks in advance!!