Which Database to Use
-
eg_Anubhava wrote:
It is free or not?
Go and look at the link; I cannot do everything for you!
I must get a clever new signature for 2011.
-
SQL server Express[^] or SQL Compact Edition would probably fit the bill.
I must get a clever new signature for 2011.
-
Hello everybody, I am developing an Application in which have a data base which i can share in different machines(more then 2). So I wanna use any database which support sharing. Because the application is download from web and it is small application.So i want to use the Fee and Small Size database. My Application is like as billing. So please suggest me what database to use for my application. Thanks
If you can think then I Can.
eg_Anubhava wrote:
So i want to use the Fee and Small Size database.
Free you can have, but database-servers aren't optimized at size - they're optimized on performance.
eg_Anubhava wrote:
So please suggest me what database to use for my application.
One that's located on a PC that can be reached by all other computers (database shouldn't be blocked by a firewall) You'll need Sql Express, MySql or something comparable.
I are Troll :suss:
-
Sql Compact isn't a database-server, it's a file-based system. It's not recommended in a multi-user environment.
I are Troll :suss:
Dear Sir, Thanks for good suggestions. Actually My Application is a Small Application which User can download from Web. In Which application i want to use the data which i can compact with my application. And I want to use it Application to For Multi User Support. In this Case Access Database is the good and free database but it generate problems in Multiuser. Please give me ur views. Thanks
If you can think then I Can.
-
Sql Compact isn't a database-server, it's a file-based system. It's not recommended in a multi-user environment.
I are Troll :suss:
-
Dear Sir, Thanks for good suggestions. Actually My Application is a Small Application which User can download from Web. In Which application i want to use the data which i can compact with my application. And I want to use it Application to For Multi User Support. In this Case Access Database is the good and free database but it generate problems in Multiuser. Please give me ur views. Thanks
If you can think then I Can.
eg_Anubhava wrote:
And I want to use it Application to For Multi User Support.
That sounds like they need to access a database simultaneously. That'd mean that they'd have an application at their own computer, and they would need to be able to access another computer that contains the database. That's your database-server. Usually, that's located somewhere in a LAN, a company-network. If you're going to share data over the internet, then you might want to consider "the cloud" - using Amazons' API to store your data remotely. That way, you wouldn't need to worry about databases and how to access it. Otherwise, you'll need to expose the database to the internet. That means providing a computer with Sql Server and hooking it up to the internet for 24hrs/day, or finding a webhost. Some providers disallow direct connections to their database, in which case you'd need a layer of webservices to communicate with the database.
I are Troll :suss:
-
eg_Anubhava wrote:
And I want to use it Application to For Multi User Support.
That sounds like they need to access a database simultaneously. That'd mean that they'd have an application at their own computer, and they would need to be able to access another computer that contains the database. That's your database-server. Usually, that's located somewhere in a LAN, a company-network. If you're going to share data over the internet, then you might want to consider "the cloud" - using Amazons' API to store your data remotely. That way, you wouldn't need to worry about databases and how to access it. Otherwise, you'll need to expose the database to the internet. That means providing a computer with Sql Server and hooking it up to the internet for 24hrs/day, or finding a webhost. Some providers disallow direct connections to their database, in which case you'd need a layer of webservices to communicate with the database.
I are Troll :suss:
Yes off Course, I want to share my database in LAN network. My Application is same like ERP. So i want to select the database which multiple system can access at the same time without generating problem. I think Microsoft Access generate the problem while sharing database. So please suggest me which one is good in selected database. MSaccess SQL Server Oracle MySql Microsoft SQL Server Thanks
If you can think then I Can.
-
Yes off Course, I want to share my database in LAN network. My Application is same like ERP. So i want to select the database which multiple system can access at the same time without generating problem. I think Microsoft Access generate the problem while sharing database. So please suggest me which one is good in selected database. MSaccess SQL Server Oracle MySql Microsoft SQL Server Thanks
If you can think then I Can.
-
Sql Server, Oracle and MySql are the ones that would fit this job, and I'd recommend Sql Server because that's integrated the most into .NET. Microsoft Access shouldn't be used.
I are Troll :suss: