Server/Network/Database? Not sure what I need for small office?
-
Hi I am setting up my own business I am in the process of deciding how to set up a small office. I am trying to create a database for Product, Customer, Orders, Employees etc. When I move into the office would the best option be to have the main server computer which holds the database and then connect workstations which will just have the standalone forms on for adding new products for example? I have just started using OpenOffice base to create the database, would I be able to have standalone forms on the workstations which send the information to the database on the main server? Also I have an OpenCart on-line store with mysql database and would be receiving orders through there. Would I be better off using my online server i use for the store to hold this database I am trying to create, then I guess I would not need a server in the office? if i did this could i still have standalone forms that would connect to mysql database? Im a complete virgin to this so any help and advice on what the best way to go and equipment needed would be great. Thanks Kim x
-
Answer:
It really does not matter where you choose to house your data. Just make sure that a) it's secure, b) the route it takes to get where it's going is secure and c) that you can access the data from anywhere. Having a server inside your network is the best security you can get, but the minute you want to access that data on the road or at home you are going to have issues. You need to find an inexpensive solution to secure your data the minute it leaves your office. I use Jumpto for this and have for about a year. Let me know if you have any specific questions and I will try to answer.
Kim at Yahoo! Answers Visit the source
Other answers
http://www.salesforce.com/au/?ir=1 http://www.jcurvesolutions.com/ http://www.netsuite.com.au/portal/au/home.shtml OR the haed way .... 1) Zimbra (MS-Exchange replacement); proprietary email shouldn't go thru google or yahoo mail servers. 2a) OpenVPN - whatever location you are at is bugged. Assume this. 2b) TrueCrypt - every laptop has this and all our data is stored in TC volumes, including PST files for those who insist on Outlook still. 3) vTiger - FOSS CRM application 4) Alfresco - FOSS document management done really well 5) MediaWiki - for quick communications and idea capture. We try to capture meeting notes, and other internal process docs in this tool. It is easy to change the content when something needs to be updated. 6) dotProject - project management/tracking and issue tracking. If you are late, that customer won't be back. 7) Tons of FOSS infrastructure - Ubuntu, Xen, openldap, postfix, clamav, openoffice, pidgin, apache, rdiff-backup, samba, cups ... the list goes on and on. 8) Skype - 123Conference isn't bad either 9) dd-wrt/open-wrt/tomato - turn your $20 router into a $600 router with VLAN support. 10) VirtualBox - laptop virtualization; not for production use IMHO. 11) Microsoft tools because you can't get completely away from some of them. MS-Office, MS-Visio, MS-Server 2003/2008 (for our customers). 12) Assorted other apps: pdf995, Quicken H&B, Quickbooks, Indesign, etc. We looked at 37folders/basecamp and were very impressed, but our security needs don't allow for external hosting except at the VM level. We are paranoid because we know what can happen. Our customers are paranoid too. http://www.dotproject.net/ for comments for business use. http://getsatisfaction.com/
Goerge
Oh boy. You sound like you know enough to be dangerous. First off, I would highly recommend you look into third party software that already does what you want. There is tons of software that is already been designed to do what you are asking so why reinvent the wheel? It will take you literally thousands of hours to duplicate what you can purchase for a couple hundred bucks or less. Second, I would also recommend that whatever you go with have it run off a hosted server. It is much cheaper up front to pay monthly than to buy and hire a tech to configure a server (although you will still need a tech if you want employees sharing files in your office.). Also, with a remote hosted server, you can setup access from any internet connection and your data is safer and protected from theft or fire.
Ken
Kim, Start with a business plan. Planning in advance will help you avoid many common mistakes. Most startups and small businesses need not buy or rent a server. There are literally millions of servers available for your use as a service at a price far below the cost to buy and maintain your own. Google alone has over 900,000 servers available for your use. I suggest you register your domain and set up Google Apps. Keep your data in the cloud, where it's protected by world class security that no small business can afford. I also would avoid buying workstations unless you really need to install local software. Every employee who does not absolutely require locally installed software should get a Chromebook, which will vastly simplify and reduce your administration, maintenance, and cost. Chromebooks are less expensive than many workstations at around $300 to $500. With Chromebooks, you don't pay Microsoft $200 to license Windows, you don't have to worry about antivirus, back ups, constantly patching your software, etc. and they go from off to the Internet in under 10 seconds. There are many off the shelf solutions for ecommerce as a service, but that's another question. Let me know if I can help you.
Douglas Baumwall
Related Q & A:
- Can I create a second filestream container on an existing SQL Server 2008 database without going offline?Best solution by Database Administrators
- I need help on what I need to buy or do.Best solution by Yahoo! Answers
- What I need to know about Treo 650?Best solution by the-gadgeteer.com
- Can you tell me what I need to do and get while travelling to Africa?Best solution by Yahoo! Answers
- Can I mail a small box in the mail box using post office?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.