I have a roadblock where we want to import a sql file which is in format of mysql db, it has drop and create table schema and has insert data scripts for those tables.
The way I tried to import the sql file is below. i) Import the .sql file first in mysql db. ii) Import it in SQL Server with the help of standard Import data vizard connecting both the db and mapping the table there.
Now the question which I am facing are below.
- Is is possible to import this .sql file directly in sql server 2019 somehow using SSIS ?
- If the answer to above question is yes, then how?, please provide any link or wayout, I am new to SSIS.
- Else if the answer to the first question is No, then am I doing it right in the way I imported this file above?