Where does the database live?

Question

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

Santhosh N · 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..

Crish · Answer

Hi Thanks I had same problem now i can solve mu issue of Where does the database live.

Santhosh N · Answer

cheers!! have a good day

John Burns · Answer

that makes sense now; thanks for the reply

John Burns · Answer

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 N · Answer

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 De · Answer

No. That will not work. You need to create your database and run the scripts there(machine on which the application will be installed).