SDF2MDF

Developers and general users who might be relying on Microsoft SQL Server Compact for their database endeavors and application development could require the need to transfer such specific database to other formats, in order to achieve better interoperability with other platforms and DBMSs. SDF2MDF, just as its name suggests, is an app whose sole purpose is to allow users to migrate their Microsoft SQL Server Compact database files to either Microsoft SQL Server or LocalDB database environments, via a minimalist, step-by-step wizard.

Having installed the app, users can then proceed with selecting their SQL CE files, which correspond to the Microsoft SQL Server Compact database environment, and they also need to input their corresponding password.

One thing to note though is that if your SQL CE files were created using a version earlier than 4.0, these will be automatically upgraded. The database file needs to be contained within a folder that doesn’t have write restrictions.

It is at this point that it’s worth mentioning that users can perform a duplication of their database file, prior to the actual conversion, just to avoid any accidental data corruption. We enjoy the fact that the app will automatically create a LocalDB destination in the User folder, regardless if the provided name does not exist.

Just before the actual conversion process, users are prompted with the choice wizard, for sending their data to either the SQL Server or, the aforementioned LocalDB environment.

SDF2MDF will provide a reliable tool for those who need a simple and straightforward solution for migrating their Microsoft SQL Server Compact for use on other database management systems.