The source instance propagates the client’s full context to the destination instance when it has successfully completed the migration, and the destination instance retrieves the context.
The client’s full context is restored after the migration is complete, making migration completely transparent to the client. However, a migrated connection acquires a new spid.
The client’s context consists of the following elements:
The name of the current database
Any pending batch of commands if the migration occurs in pre-batch mode
The client’s login record
The client’s language and character sets
The client’s capabilities
Any monitor counters and statistic
Any roles
Any set options
Trace flags 3604 and 3605
