使用SQL Server文件应用程序。无需安装SQL服务器（如ce） [英] Using SQL server file app. Without installing SQL server (like ce)
问题描述
我开发了一些应用程序。使用SQL Server 2008 DB。问题是我希望将它们作为演示启用，因此用户可以在不安装SQL Server的情况下安装它们。一种解决方案是使用SQL ce，其中不需要安装，但我的问题是
如何将SQL Server文件转换为ce（我不能手动执行）
有没有办法提供SQL Sever文件，用户可以测试应用程序。没有安装SQL服务器？
非常感谢！
我尝试了什么：
我搜索过谷歌很多！得到了非常复杂的答案，比编写一个全新的应用程序更复杂。
I have developed a few apps. with SQL Server 2008 DBs. The issue is I wish to enable them as demo, so user could install them without installing SQL Server. One solution is to use SQL ce, where no installation will be required but my problems is
how to convert SQL Server Files to ce (I can not do them manually)
Is there any way that I provide SQL Sever Files, and user could test the app. without installing SQL server?
Thanks a lot!
What I have tried:
I have searched google alot! Got very complexed answers, more complicated than writing a whole new app.
推荐答案
SQLCE可能不是一个好选择 - 它正在被折旧，它不支持很多SQL服务器所做的事情可能并不简单。
我建议使用Access或SQLite - 它们可能更适合你。
转换数据是非常简单：手动创建表，然后编写一个快速应用程序，读取SQL服务器表数据并将其写入新表。
然后只需创建一个使用新数据库系统的演示版本而不是SQL服务器（取决于你首先编写应用程序的程度，这可能是相对微不足道的，或者非常复杂）。希望你把所有的数据库代码放在一个单独的DLL中，所以它只是为了一个新的DLL程序集交换DL层的情况。
抱歉，但是没有做这个，它会为你解决方法。
SQLCE is probably not a good choice - it's being depreciated, and it doesn't support many of the things that SQL server does so converting may not be simple.
I'd suggest Access or SQLite instead - they might work better for you.
Converting the data is pretty simple: manually create the tables, then write a quick app that reads the SQL server table data and write it into the new tables.
Then just create a "demo" version that uses the new DB system instead of SQL server (depending on how well you wrote the app in the first place, this could be relatively trivial, or hideously complicated). Hopefully, you put all the DB code in a separate DLL, so it;s just a case of "swapping out" the DL layer for a new DLL assembly.
Sorry, but there isn't a "do this and it'll fix it for you" approach.
这篇关于使用SQL Server文件应用程序。无需安装SQL服务器（如ce）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
