4
I am finishing an application and will compile using Inno Setup. The system is using SQL Server.
I’ll install the system on other computers.
The database is installed on the computers that will receive the application or I will have to install Sqlerver on each computer?
I’m using Visual Studio 2013 Express.
6
It depends on what you did, but I would say that it is not necessary to install on all computers, in general it is only necessary on the computer that will be the server.
Of course, if you have done everything without thinking about it before you may have problems accessing the server and you will have to fix the application configuration. It is one thing to make to run on your machine, another is to do to run remotely. Obviously on the server you will have to install SQL Server, and if you already have a basic database to start running the application, it should be put there.
If you used an extra library to cease SQL Server other than . NET defaults, you will need to distribute it to your installation.
There are cases that the application may need the database in the client as well. Using SQL Server is not recommended there. At least not in its full version. It is better to use the SQL Server Compact which is an embedded data bank in the application. Or better still, use the Sqlite, even because SQL Compact has been discontinued.
I get it... but if you install locally? Because I see some programs that we download from the internet and that are installed locally. This would be possible?
I don’t know if I understand what you mean but yes, it is possible, even to include SQL Server in the installation. This does not mean that it can be installed without paying anything. Outside of the development it needs to be licensed and costs expensive. I think unless I have a good reason the bank installed locally or is demo or it has something very specific. Of course if you need a small local database very simple the most common is to use Sqlite. Before it was recommended to use SQL Server Compact but even Microsoft does not encourage more with the strength of before and speaks in Sqlite
I think in your case you should use Sqllite as @bigown said. Installing multiple instances of SQL Server would be laborious and very expensive. How big is your app? If it is large and the access to the database is intense, then it is better to think about having a server to centralize the database.
Okay. It’s a small application. It’s an agenda for the conference room that’s gonna be with the receptionist. It will contain only the name of the applicant, the date and times of entry and delivery.... In that case, how would I apply Sqlite to my application? It is currently on Sqlserver ( that came with Visual Studio Express 2013 )
In fact it seems to be too simple and it makes sense to be alone locally, but that’s another question. See [tour] and [help]. To summarize: unless you have done thinking about the exchange, which does not seem to be the case, you have to rewrite every application data access mechanism.
Browser other questions tagged c# .net database sql-server deploy
You are not signed in. Login or sign up in order to post.
You can accept an answer if it solved your problem. You can vote on every post on the site as well. Did any help you more? Something needs to be improved?
– Maniero