MDF (MS SQL database) to SDF (SQL Server database) conversion is possible, and can be done either as export from Microsoft SQL Server tool or with some dedicated database conversion tool, like Full Convert Enterprise.
Regardless of the tool used, this mdl to sdf conversion should be doable and is likely used for the purposes of data transfer.
Updated: July 14, 2022