Creation of a web service to update client Access databases from central SQL database
$250-750 AUD
Teslim sırasında ödenir
We have a SQL database containing information which is updated regularly, and needs certain information updated into client Access databases.
Ideally a SQL job or web service etc. that can poll our SQL database looking for relevant data to be updated on the customers ends, then connect to the access DB and update the information in the appropriate fields at the customer end. We would also like for the service to have to authenticate with a DB user (same user on each DB).
Very open to solution options based on your knowledge. After something quick and simple which will perform the above function reliably.
Considerations:
1. Keep it simple, prefer not to have to install anything at client end.
2. Prefer polling at server end, and pushing to client DB
3. Prefer web protocols, keep it simple for firewalls
4. Would like the option to authenticate using a specified username/password for the push
5. Server DB will have certain fields with certain information that needs to be pushed to the client. Client will be identifiable within the server DB.
6. Need to be able to map the client to their IP address for the communications to happen (assuming it will be IP based)
7. There is no PII or other senstive information involved.
Proje NO: #37253910
Proje hakkında
Bu iş için 21 freelancer ortalamada $517 teklif veriyor
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Daha Fazla
Hi there! My name is Ketan and I am part of the Full Stack Sr. Software Professionals team at Illuminity. We have over 14+ years of experience in the field of web development and have worked on many successful projects Daha Fazla
Hi there! I am well-equipped to fulfill the requirements of this role. With my expertise in database management and web development, I can create a robust solution that enables seamless communication between your SQL Daha Fazla
At the server end, I can createa a background windows setvice that runs with a predefined schedule (which will have configuraion that you can control). This windows servicw will be running automatically, pull the requi Daha Fazla
Hi there, I'm bidding on your project "Creation of a web service to update client Access databases from central SQL database" Being a professional electrical engineer, I can do this project for you. please leave a mes Daha Fazla
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform Daha Fazla
Hello, my name is anil and I am a professional with extensive experience in web development, database administration and SQL. I understand that you are looking for a solution to update client Access databases from cent Daha Fazla
Hello, I understand your requirement for syncing records from sql database to access. I have experience working on MSSQL and can create you an small configurable service for incremental syncing of records. Please in Daha Fazla
I am confident that I can provide the solution you are looking for. My skillset includes web development, artificial intelligence, mobile app development and system administration. I understand that you would like fo Daha Fazla
HI, I am a professional SQL database developer with deep knowledge of RDMS. I have 7+ years of experience in databases. If you are looking for an expert on Database design and queries, then you are in the right pl Daha Fazla
Hello, I have enough experience with web app development and I would like to discuss your project in detail, so we can clear up all requirements for it to get started as soon as possible. Thank you!
Hello there! My name is Pallavi and I am a full-time web and mobile app developer working as a freelancer. I have extensive experience in database administration, database programming, Microsoft Access and SQL. I und Daha Fazla
Nice to meet you dgr75, It is a pleasure to communicate with you. My name is Anthony Muñoz, I am the lead engineer for DSPro IT agency and I would like to offer you my professional services. I have more than 10 years Daha Fazla
Based on your requirements and considerations, you can achieve the task of updating client Access databases from your SQL database in a reliable and straightforward manner by implementing of SQL Server Agent Jobs or We Daha Fazla
Hi, i am a 20 year experienced software engineer and architect in dotnet technology. This requirement will need a Windows Service on your Windows server or an SQL Job on your DB Server which will connect to your SQL Se Daha Fazla
