Click here to Skip to main content
15,917,795 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I am using sqlserver2016 and visual studio 2015 community. My doubt is which one of sqlserver I have to give clients.

What I have tried:

I googled but clarity not came for me.
Posted
Updated 2-May-17 20:29pm
v3

You should not include SQL Server in your installation. There are a couple of reasons:
0) You can only distribute SQL Server Express for copyright reasons - not SQL Server full version.
1) They may already have SQL Server installed on the network. If so, then they will presumably want to use that version.
2) If they do have SQL server installed and you start proliferating SQL server Express instances, you are going to annoy the heck out of the database administrator...
3) A single site installation of SQl Server is a lot more likely to be backed up than a number of scattered version under user control.
4) Sql server is quite complex for a "normal" user to install and administer - it is not a good idea!
5) It will destroy the primary advantage of using Sql Server over SqlCE or SQLite - multiuser access. If everyone installs their own copy of SQL server, then you will have multiple copies of your database, each used by a single person. This will cause some confusion, and (depending on how you wrote the original database) may take some considerable effort to combine into a single instance when the problem is realized.

If you must use a multiuser system, then the client should install SQL Server themselves (or you take over DB admin for them and do the installation yourself) - remember that SQL Server is not a cheap product: SQL Server—Pricing an Licensing | Microsoft[^] unless of course you want to pay for ityourself?

If you don't need multiple users accessing your database, then switch your code to one of the single user DB engines like SQLite - or even Access - which require no special installation above that required by your application.
 
Share this answer
 
Comments
vijay_bale 3-May-17 2:43am    
I downloaded sqlexpresslocalDB 2016. Is that enough? As you told I have to install this saparately on usersystem right?
OriginalGriff 3-May-17 3:34am    
Sql Express LocalDb is not a multiuser system: it's a local instance of SQL that is targeted at developers for development only - you cannot use it for release projects.
OriginalGriff 3-May-17 3:39am    
Sql Express LocalDB is not a multiuser DB system - it is a special SQL instance for developers only that doesn't require the full installation - you cannot use it for production code.
vijay_bale 3-May-17 4:15am    
so only sqlserexpress
OriginalGriff 3-May-17 4:23am    
Don't do it. Seriously. It's a complex beast, and installation is non-trivial...
The only SQL server you can 'give' to your clients is the express edition...
It may be LocalDB or Express as you choose, but any other editions are cost money and you can not 'give' them away...
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900