I has been used SQL server database since 2009 but not for website. I had also used oracle and MS access. I am not having a good enough knowledge about creating online database. If you have any experiences with that, you can lead me with your suggestion.
If your Website is small enough say couple of records then you can go with MS Access itself but i guess in that case you need to make your computer as the server. However if you have hundreds of records then you can go for Mysql since Oracle might cost you alot. You can get Mysql online database hosting for $2-$8 dollars/month. You can use Php with Mysql for coding. Regards, Jenelia
True and real suggestion... Apart from this, if your requirement go more for more and more data base then you need to use software like CRM, ERP etc, which you can get from Zoho. You can take a Free Trial also... And if you are an expert then you can create your own internal software for tracking huge data base.
Right ! However aren't CRM and ERP's are softwares in themselves with a Database of their own ? And can CRM and ERP be integrated into existing applications for storing data ?
Use Access if you have a small number of records and if you have windows hosting, it's easy and quick to work with it. If you plan on having a large database then go for mySQL, it works both on Windows & Linux, the database size is smaller and it should be easy for you to pick it up if you've worked with SQL...well the query syntax between Access & mySQL is "almost" identical, so even if you start with access first and decide to change later it won't be a huge job...I know I've done it....MySQL has a bit more features in the queries though.