what is the spec of that database instance? that will have an impact on it regardless of how you do it

and were you creating the index online or offline? -...

if they have direct access to the databases there is no way for you to prevent them from extracting the data. (other than using a tool like CyberArk which can...

is that size on the...

they don't  want us to help. they want us to do the full code for them for free.

based on the sample data string_split() will not work as it lacks the...

• This reply was modified 3 years, 7 months ago by frederico_fonseca.

assuming you are using SSIDDB it does not allow kerberos delegation.

quote from https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver16

SSISDB doesn't support constrained delegation. In a double-hop environment, if the service account of the SQL server that...

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 3 years, 7 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