The transaction log for database 'MyDatabase' is full .... Can someone please suggest
Seems your target database on SQL Server is in full recovery mode and the amount of transaction during migration fills the transaction file.
Either run frequently log backup to release the transaction log or change the recovery mode of the database to "simple".