How to Import Data from MySQL Table to SQL Server Table by using Import Wizard - MySQL To SQL Import

How to Import Data from MySQL Table to SQL Server Table by using Import Wizard. In this video you are going to learn how you can import data from Mysql table to SQL server 2019 by using import export wizard. You will be using ADO.Net drive on MySQL Source and then write query to get the data from MySQL table and map to SQL Server table.

To read the data from MySQL Table, you need a user and have to provide read permission to user that you will use in Import Wizard.


Script to create user in mysql and provide permissions

create user 'tb'@'localhost' identified by 'dba123'; grant all on techbrothersit.* to 'tb'@'localhost'; flush privileges; show grants for 'tb'@'localhost';



No comments:

Post a Comment

Note: Only a member of this blog may post a comment.