将 MDF 转换为 SDF [英] Converting MDF to SDF

问题描述

我已经做了一些谷歌搜索，试图找出如何将 .MDF 文件转换为 .SDF.除了一篇名为SQL Server 到 SQL Server Compact Edition 数据库复制实用程序"的旧文章之外，似乎没有太多内容.由于它太旧了，我怀疑它是否适用于较新版本的 SQL Server 数据库.现在有没有更成熟和官方的方法来实现这一目标?理想情况下，我需要能够迁移数据和表结构的东西.

I've done a bit of Googling trying to find out how to convert a .MDF file to a .SDF. There doesn't seem to be much around apart from an old article for something called 'SQL Server to SQL Server Compact Edition Database Copy Utility'. As this is so old, I doubt it will work with the newer versions of SQL Server databases. Is there a more established and official method of achieving this now? Ideally I need something that will migrate the data as well as the table structures.

推荐答案

您可以使用我的免费 VS 插件SQL Server Compact Toolbox"通过脚本或直接将数据和架构从 SQL Server 数据库迁移到 SQL Server Compact在图形用户界面中

You can use my free VS add-in "SQL Server Compact Toolbox" to migrate data and schema from a SQL Server database to SQL Server Compact via script or directly in the GUI

这篇关于将 MDF 转换为 SDF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！