Can I import data files from MySQL to MSSQL?

I have 2 database; MySQL has data inside and another is MSSQL that has emply data I need to transfer all data from MySQL to MSSQL but as I explored it, I never saw import files. Someone tried this?

I'm manually typing it. Sorry I'm not trained to do this. Please help!

Hi

Yes you can INSERT data from MySql to MsSql using the
menu tools\export data as SQL\
In the popup screen you can select the database you want to copy to.

for this you do have to use the session manager ,create a connection to both database and connect to them.

There is one MAJOR restriction ... you can only INSERT 1000 rows into a MsSql .
A workaround is to copy all data to clipboard and then make multiple INSERTS with less than 1000 rows.

Eric

Hi

Yes you can INSERT data from MySql to MsSql using the
menu tools\export data as SQL\
In the popup screen you can select the database you want to copy to.

for this you do have to use the session manager ,create a connection to both database and connect to them.

There is one MAJOR restriction ... you can only INSERT 1000 rows into a MsSql .
A workaround is to copy all data to clipboard and then make multiple INSERTS with less than 1000 rows.

Eric

Thank you for your response. I tried to export it and error shows.
Please see image attached.