将SQL Server备份文件还原到SQL Server Compact DB. [英] Restore SQL Server Backup file to SQL Server Compact DB.

问题描述

大家好，

我们可以将SQL Server(即* .bak)占用的备份文件还原到SQL Server Compact数据库或以任何方式将.bak文件转换为.sdf文件吗?或用于此类活动的任何工具?

关于

Hi All,

Can we restore backup file taken by SQL Server (i.e.*.bak) to SQL Server Compact database or convert .bak file to .sdf file in any way? or any tools available for such activities?

Regards

推荐答案

确定.由于它只是一个文件，因此您可以复制该文件以进行备份，然后将其复制回以进行还原.

Sure. Since it is just a file, you can copy the file to make a backup, then copy it back to restore it.

Sql Server Compact数据库实际上是一个基于文件的数据库，如Access.因此，您只需要备份文件，然后将其粘贴回去即可还原.

无需任何特定工具即可执行此操作. ;)
:)

Sql Server Compact database is actually a file based database like Access. So you need to just take backup of the file and then paste it back to restore it.

No need to go for any specific tool to do this. ;)
:)

这篇关于将SQL Server备份文件还原到SQL Server Compact DB.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！