We have an existing mySQL DB that is used to manage a marketing contact list of approximately 250,000. Presently, we have a DBA who is required to perform any actions, reports, imports, exports, etc. We want to enable an interface and infrastructure for any nonDBA (secretary, manager, anyone) to be able to easily conduct 100% of all data management.
Presently, we create a datalink from the DB to MS Excel for a couple staff members to work with the data. This is cumbersone and the datalink can be unreliable. Plus, there are data management functions that Excel does not do.
You will need to do the following:
1. Recreate a new database system.
2. Create a user interface that anyone in our staff can use for all DB functions.
3. Host the DB on GoDaddy or someplace else that we mutually agree.
4. Import the existing DB.
5. Design import and export processes with various other IT systems that we have. In particular, we have a CRM system and an email distribution system that each need to mechanisms to interface with the SQL DB and/or have a clear and reliable process to exchange and update data.
6. Setup backup processes.
7. Thorough document the system and all processes.
8. Train our staff on its use.
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan.
With Regards Sri Technocrat.
Hi,
I have more 10 years experience in MS Access, MS Excel and MS SQL server, so I'm realy GURU in this.
I can help you with this project,
Best Regards,
Alex