Where does the database live?

John Burns

Still early days of learning OOP and databases.

I created a small program that speaks to a database and that data base holds my changes in the table ect but my question is: where does the database reside? its in my PC i know that much, its not in my fridge lol.

If i were to create an installer for my program using Visual studio express and then put that .exe file to another pc and install on there does that mean that the database that was built with my program go with it as well? .... it will just work like it did on mine?

not too sure of the basics, any help would be much appreciated :)

John

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh N15y ago
Accepted answer
Yes, what you said holds true..

when you can create a database which can be accessible from multiple computers either in LAN or Internet or any network and accessible to all 100 or any number of computers, then you need to not worry of deploying the database and all client computers can speak to the same database.

even, while you are hosting in any web, the hosting compannies do privide sql server instances and you can use that to create to the database in it and use to your application..
Crish15y ago
Hi

Thanks I had same problem now i can solve mu issue of Where does the database live.
Santhosh N15y ago
cheers!! have a good day
John Burns15y ago
that makes sense now; thanks for the reply
John Burns15y ago
thanks for the replys, so how is it ever possible to create an application that uses a database but on another computer? would i always have to instal the dabase on the machine im running it on ... or what if it is 100 machines?? :S will i alwasys need to attach it? but sureley that would take up masses of space?

i noticed that the database i use is called a local database ... that means it resides on my PC ... so cant i get a database that is not local ? that exists on the web and then just point my applicaiton towards the database hosted on the web? i take it this is whats ment by SQL database?
Santhosh N15y ago
To begin with Database is one engine ( a seperate process) and your application one more process and whenever you need to connect both, you use some connections (ADO.NET classes with providers to connect to specific DB in case of .Net).
And now, when you developed the application with Data in some database instance which is a seperate altogether from your application, the target location where you need to install the application should be able to connect to the DB from there...
If not you need to include the DB engine in the installer which is possible for smaller dbs like access, excel ..
you can check a sample over here
http://www.codeproject.com/KB/database/DBInstaller1.aspx
Subhendu De15y ago
No. That will not work. You need to create your database and run the scripts there(machine on which the application will be installed).