I am pretty sure you have heard of the word "replace" - use it to replace those 3 chars with another single delimiter that is not used within the text.

and...

and unless all your tables are columnstore tables do the backups with native compression turned on - files will be significantly smaller leading to faster backups and less space required.

Restores...

yes - that is one of the pains of using the files - on the cases where you have values on your tables with the delimiter you use you need...

you now really on to the realm of MYSQL forums - while some here may be able to help this is not the best forum for it.

regarding the integer display...

• This reply was modified 2 years, 10 months ago by frederico_fonseca.

so... decided to experiment it myself.

Workbench data migration is a pile of crap.. no wonder you are having issues.

your best option is to use the option "create a batch file...

DID you try the script file option on workbench?

and you running workbench on same server?

if so then in all likelyhood your server is maxed - such a small spec for 2 db servers is bad - and if...

if workbench is that slow it may have to do with your server specs - or with your network.

can you tell us the specs of both servers - as well...

don't create new threads on same subject - please keep discussion on your original thread https://www.sqlservercentral.com/forums/topic/migrate-10-gb-database-from-mssql-to-mysql

spam - exact copy of https://www.reddit.com/r/dataengineering/comments/wvpic5/comment/ilhadig/ - from 2 month ago

anything against reading the manuals? relevant information will be there - and for some of those options should you have them on a video you would likely see a biased...

it has to do with the passwords for some logins being encrypted using that cypher - so only way to allow those clients to connect is for the server to...

multiple ways - I was just giving one of the ways with an incentive to search for it and try to understand it.

and... substring vs stuff - which one is...

you missing the fact I said reverse (use twice)

without giving you the code look at functions charindex, substring and reverse(use twice) - using these 3 you will be able to get that split