Design SQL database changes and write some C# code
$30-250 AUD
Pagado a la entrega
This is the first in what will likely be many projects and I’m hoping to find someone who I can work with throughout all the projects (there is currently no timeline for the other projects, although I’m hoping to begin over the next few months).
The Project:
I currently have an in-house, .NET point of sales application using a SQL Server database that runs independently in two of my shops. In the future I will be having an app written to allow my staff to remotely manage some of their work. Because of this, I need a way to sync both local and remote database changes with each other. I am thinking of having a central database, hosted in AWS which can be read from and updated using AWS Lambda’s (with Authentication and security) and a way to pull the changes from the central AWS database to the local databases as well as push local changes to the central one.
The two shops are separate companies and any changes sent between the local and AWS database need to be segregated by that company. Each company has a few users, each of which can have a company code, login name and password for authentication and to identify which company the data is from.
I need a method to track the changes made between the central database and the local databases and I was thinking that using AWS Lambda’s to interact with the central database and a local Windows service to interact with the local database as well as interact with the AWS Lambdas would be the best way to do it. (If you have a better idea on how to achieve this, I’m open to suggestions).
I will also need a method added to the Lambda that will allow file transfer to and from Amazon S3 storage to let my staff (eventually) upload PDF’s and store them. The files will need to be tracked so that they can be pulled back out and downloaded. These should also be segregated by company and use the same authentication.
NOTE: Because eventually mobile apps will be needing to access the central database using the Lambdas, whatever you build, must have methods of security and authentication (I’m open to your suggestions) as well as be something that an app will be able to access and work with.
NOTE: I will be adding another few shops to this within the next 6 months and some of them will be initially running SQL Express, so please make sure that anything you build uses functionality that supports SQL Express.
I will supply:
I have attached a word document with some SQL scripts to build sample tables from our current database and have supplied some sample data in there as well. You are required to use these samples to decide what changes are required to our current database in the local version as well as what changes would be required to be able to use the database as the central database (they can of course be different). Initially I thought using staging tables to host the changed data, or perhaps adding additional fields to track changes but it’s really up to you on what you think is best.
What you will deliver:
(As mentioned, if you have a better and more efficient way of achieving what I need please let me know)
1 x AWS Lambda (or an alternative) written in C# to update, insert and delete information in a SQL database (with security and authentication) as well and send, receive and store PDF files to an Amazon s# instance - segregated by user/company.
1 x Windows service (or an alternative) that will periodically push updates from the local database to the AWS hosted database and pull updates from the AWS hosted database to the local database (sync changes)
1 x Central SQL database, modified from the supplied sample to work with the AWS Lambda (which I will deploy on an AWS SQL instance)
1 x local (on-site) SQL database, modified from the supplied sample to work with the Windows service (which will be deployed in several locations)
If you have any questions please let me know.
Nº del proyecto: #15129954
Sobre el proyecto
42 freelancers están ofertando un promedio de $203 por este trabajo
Hello Sir, I have 10+ years of web development experience in ASP.NET MVC, ASP.NET Web forms(C#), Classic ASP, SQL Server, HTML5, CSS, jQuery, javascript, JSON and XML.I have handled similar projects. Please review m Más
Hi , i have studiees your lengthy requirements and future Road map. it is more like SAAS model software and i will recommend to build web apis rest services using o Auth authentication that can be consumed from web, io Más
I REVIEWED YOUR PROJECT DETAILS & WOULD LIKE TO OFFER YOU MY SERVICE OF DOING FIRST TASK FOR FREE Relevant Skills and Experience I am Senior Software developer, having 7+ years experience with team of additional 2 dev Más
I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Habilidades y experiencia relevante I'm Más
Hello, I have more than 10 years of experience in .NET Development with experience in all the technologies. I have developed and deployed more than 200 applications till date using .NET technologies Relevant Skills a Más
Hello Friend, very well explanation. I readout the whole description and have some ideas about how we can keep the multiple DBs sync with centralize one. freelancer.com allow 200 characters only. PM ? Relevant Skills Más
I am a full stack .Net Developer and having 3+ years’ experience in same, and a strong educational background featuring a master degree in Computer Science. Relevant Skills and Experience -Strong database knowledge: M Más
Hi, I went through the project details and I would say I am impressed with the sort of research you have done. I would definitely be interested in working with you on this project. I am professional web developer and Más
I have gone through the requirement, I can do it. I have 13yrs experience in microsoft technologies including Web, Windows and mobile programming Relevant Skills and Experience I have more than 13 yrs exp as Architect Más
Hello, as I understand, you want to create the main database, from which, each time a local database should be created, and then the bd kernel should be updated from the local. Соответствующие навыки и опыт we did so, Más
I have over 8 years of experience working as a full stack .Net developer. Relevant Skills and Experience C#, SQL Server, WCF, Asp.Net, MVC, JavaScript Proposed Milestones $88 AUD - Implement the system
expert in NET, C# Programming, Microsoft SQL Server Relevant Skills and Experience NET, C# Programming, Microsoft SQL Server Proposed Milestones $30 AUD - budget
7+ years of experience in web development and designing, having complete understanding in WordPress, PHP, HTML,CSS, MySQL, Ms-Sql, Mongo DB, Oracle, Java Please feel free to contact Relevant Skills and Experience Word Más
offline application user data store in local database. it will be automatically synch all data in central database. user can upload documents in AWS S3 server. Relevant Skills and Experience I am .Net developer having Más
