使用SQL数据库开发winform应用程序的指南。 [英] Guidance for winform application developement with SQL database.
问题描述
您好，
我设计的&为我的一个客户开发了（WinForm应用程序）教练班级管理系统。
现在，软件已准备好在客户机上安装。
但是我很困惑以下事情。
1）谷歌搜索后，我开始知道，
我需要在我客户的机器上安装SQL Express版本。
我使用的是SQL Server 2008 R2。
然后SQL Express 2008能否支持我的数据库？
2008年是否会出现任何问题2008 R2？
在客户机上安装完整的sql express（2+ GB）是个好主意吗？
2）假设，我在我的客户端机器上安装了整个SQL Express 2008;那么客户端能否看到我的数据库工作结构？ （即表格映射，sp，函数和其他东西）如果是，那么这将是最糟糕的事情。因为客户端可以窃取我的数据库技能
3）在研究所有这些因素的同时，我下载了一个名为HDSchool.SA的软件
该软件自动创建sql数据库;当我关闭应用程序时，它在C盘中创建它的.bak文件。
然后我尝试在SSMS 2008 R2中恢复此.bak文件; SSMS显示版本问题错误。
我无法理解这个软件对数据库的作用。
请告诉我，什么是使用包含所有证券的数据库开发Winform应用程序的正确方法。
我尝试过的方法：
大量搜索谷歌大量搜索谷歌大量搜索谷歌大量搜索谷歌大量搜索谷歌大量搜索谷歌大量搜索谷歌大量搜索谷歌
Hi there,
I designed & developed(WinForm Application) "Coaching Class Management System" for one of my client.
Now, software is ready to install on client machine.
but I am in confusion for following thing.
1) After googled, I came to know that,
I need to installed SQL Express Version on my client's machine.
I used SQL Server 2008 R2.
Then can SQL Express 2008 will support my database?
Is there will be any issue with 2008 & 2008 R2?
Is it good idea to installed whole sql express(2+ GB) on client machine?
2) Suppose, I installed whole SQL Express 2008 on my client machine; then can client able to see my database work structure? (i.e.Table Mapping, sp, function and other things) If yes, then this will worst thing. Because client can thief my database skills
3) While studding all this factors, I download one software called as "HDSchool.SA"
This software automatically create sql database; and when I closed the application it creates it's .bak file in C drive.
then I tried to restore this .bak file in SSMS 2008 R2; SSMS showing me version problem error.
I can't understand what exactly this software did for database.
Please tell me, what is the proper way to developed the Winform application with database with all securities.
What I have tried:
Lots of search on Google Lots of search on Google Lots of search on Google Lots of search on Google Lots of search on Google Lots of search on Google Lots of search on Google Lots of search on Google
推荐答案
1）如果您在开发期间使用过SQL Server 2008 R2但打算将SQL Server 2008加载到客户端计算机上，那么那么SQL Express 2008是否可以支持我的数据库？ 将取决于您在R2中引入的功能 - 此链接将帮助您确定 SQL Server 2008 R2版本支持的功能 [ ^ ]
为什么不下载更新的版本，测试你的软件是否有效，然后在你的安装中包含它？ 2016年可能对你的品味过于前卫，但2014年看起来非常强劲。
无论哪种方式，如果你要在你的安装中包含一些东西，你应该测试您的软件首先运行。
2）无论您是否在客户端计算机上安装整个SQL Express，都无法阻止他们下载SQL Server管理Studio并且可能能够访问您的数据库架构。您需要控制他们可以实现的访问权限 - 这些文章应该有所帮助：
使用SQL Server登录 [ ^ ]
SQL Server安全 [ ^ ]（这是引用其他链接的参考文档）
3）.bak文件可能不是SQL备份。如果您遇到HDSchool软件问题，那么您应该联系HyperDrive InfoTech - 学校和学院管理软件 - HDSchool - HDSchool下载 [ ^ ]
1) If you used SQL Server 2008 R2 during your development but intend to load SQL Server 2008 onto the client machine then "Then can SQL Express 2008 will support my database?" will depend on what features you used that were introduced in R2 - this link will help you determine that Features Supported by the Editions of SQL Server 2008 R2[^]
Why not download a more recent version, test your software works and then include that in your install? 2016 might be too avant-garde for your tastes, but 2014 seems pretty robust.
Either way, if you are going to include something in your install, YOU should test that your software works first.
2) Whether you install "whole SQL Express" on the client machine or not, there is nothing to stop them from downloading SQL Server Management Studio and potentially being able to access your database schema. You need to control just how much access they can achieve - these articles should help:
Working with SQL Server Logins[^]
SQL Server Security[^] (this is a reference document referring to other links)
3) The .bak file may not be a SQL backup. If you are having problems with the HDSchool software then you should contact HyperDrive InfoTech - School and College management software - HDSchool - HDSchool Download[^]
请告诉我，用所有证券开发带有数据库的Winform应用程序的正确方法是什么。
Please tell me, what is the proper way to developed the Winform application with database with all securities.
按照参考文档的方式进行操作 - 链接位于上面的第2点。您还将获取一些关键短语以供进一步研究
Work your way through the reference document - the link is in point 2 above. You will also pick up some key phrases for further research
这篇关于使用SQL数据库开发winform应用程序的指南。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
