在visual studio桌面应用程序中使用哪个数据库,基于服务或本地SQL Server db?
我正在做一个酒店项目。我正在使用Visual Studio 2013来制作这个项目。我需要使用.exe文件在2台客户端的计算机上安装此软件。
我有几个疑问:
1.我应该选择哪个数据库? (我相信酒店数据库会快速增长)。基于Service和本地db都可以轻松处理大数据吗?
2.基于服务的数据库,如何以及在何处存储数据以及如何从中访问数据客户端机器?
3.在哪里备份数据库?
提前致谢。
我尝试了什么:
我即将开始为应用程序创建数据库。
I am working on a hotel project. I am using Visual Studio 2013 to make this project. I need to install this software on 2 client's machines using .exe file.
I have a few queries:
1. Which database should I choose? (I believe hotel database will grow very fast). Can both Service based and Local db handles large data easily?
2. In case of Service based db, how and where to store the data and how to access it from the client machines?
3. Where to keep the backup of the database?
Thanks in advance.
What I have tried:
I am about to start making database for the application.
我可以建议SQL服务器,之间的连接机器可以通过ODBC完成
Hi,
I can suggest SQL server, connectivity between the machines can be done through ODBC
除了解决方案1之外,您可能会发现MSDN文档中的这些文章很有用:
规划SQL Server安装 [ ^ ]
SQL Server数据库备份的最佳实践建议 [ ^ ]
MS SQL Server管理 [ ^ ]
顺便说一句,我认为你的意思是服务器而不是基于服务 - 但是localDB不合适
Further to Solution 1, you might find these articles in the MSDN documentation useful:
Planning a SQL Server Installation[^]
Best Practice recommendations for SQL Server database backups[^]
MS SQL Server Administration[^]
By way, I think you mean Server based not Service based - however localDB would not be appropriate