I create a WEB site with quotations. What is the best software for creating the database? Is MS Access OK? - create database software
I have an extensive database of contributions, with 6000 entries in Access. I ma not sure how it works on a website. I read reviews saying that access is low and it is better to use SQL. I do not know much about SQL. Does anyone know the best tool for the job?
Thursday, December 31, 2009
Create Database Software I Create A WEB Site With Quotations. What Is The Best Software For Creating The Database? Is MS Access OK?
6 comments:
What are the fees say on the website to see how many people are you expecting just this? I have recently been the implementation of an intranet as it gets 100 visits per day by the staff has. Using Microsoft Access as the back-end, coded the site in ASP. A trouble-free operation for 2 months.
Well, what is best depends on many other factors, no doubt, SQL Server is much, much better, but it can also u costs. From what I understand, but there are many differences. If money is no problem after SQL Server.
You did not mention this front that you are using, but I suppose it is asp or asp.net. In this case, or not, have to be much change in your part of the encoding. To make the exception to the connection string, the net can www.connectionstrings.com () slightly.
You have your access to the database with SQL Server Data Transformation Services. have to give the network address, it is easy to understand and follow.
For better performance of your website, you can index and search, which is a little complicated to understand.
I hope this helps ...
Depending on your site and server technologies. If you use PHP, you should think MySQL (or PostgreSQL). If you are ASP / ASP. NET MS SQL, then, is what you need.
I want to use the MS SQL Server. You can MSDE (search for it). MSDE is a database of local offices. You can build your website with access to databases and evidence, which connect to your MSDE database. It's a free download. Access is not a good program to learn. I believe that MS SQL is much easier to learn and will look good on a resume, or.
I want to use the MS SQL Server. You can MSDE (search for it). MSDE is a database of local offices. You can build your website with access to databases and evidence, which connect to your MSDE database. It's a free download. Access is not a good program to learn. I believe that MS SQL is much easier to learn and will look good on a resume, or.
Personally, I use MySQL - but because I did not. In addition, MySQL is more widely accepted in most servers.
Rawlyn.
Post a Comment