Guidance for winform application developement with SQL database.

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

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

Posted 4-Apr-16 21:13pm

Nilesh Dalvi

Updated 4-Apr-16 23:25pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2016-04-04T23:25:00

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[^]

Quote:
Please tell me, what is the proper way to developed the Winform application with database with all securities.

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