Cancelled

Design SQL database changes and write some C# code

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.

Skills: .NET, C# Programming, Microsoft SQL Server

See more: write c code, write c++ code program for preparing for www ethiotsgereda com menu, zen graphic design sql database, design sql database web front end, design sql database excel workbook, design canadian postal code sql database, design sql database renting cars, write code address book iphone, design sql database schema, create sql database customer order details code, find database changes sql 2005, design blackberry application sql database, sql 2005 view database changes, sql show results database changes, backup sql database code, sql script database changes, invoice billing project sql database design document, write code transfer data sql server excel

About the Employer:
( 9 reviews ) Endeavour hills, Australia

Project ID: #15129954

Awarded to:

creatorul

Hello, My name is Daniel Bogdan and I am a Microsoft Certified software engineer with strong background developing rich client applications, web applications and other various software products. I am proficient in More

$35 AUD in 60 days
(155 Reviews)
7.7

46 freelancers are bidding on average $212 for this job

ambar

With just a simple staging table on local DB, your issue be solved. How?- Synchronise the staging table to the server once in a while (one per minute / hour / day, depending on your needs); Simple Job Relevant Skills More

$147 AUD in 3 days
(104 Reviews)
8.3
deepindersingh

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 More

$150 AUD in 15 days
(35 Reviews)
6.4
$222 AUD in 8 days
(77 Reviews)
6.0
azmatakhtar

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 More

$55 AUD in 3 days
(42 Reviews)
5.4
shreesols

With due respect on your defined architecture, just want to say you are making it complex. We can make it in more easiest and cheaper way. But it does not mean it will not be a professional item. Relevant Skills and More

$300 AUD in 20 days
(23 Reviews)
5.4
TanzeelAhmed

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 More

$250 AUD in 3 days
(20 Reviews)
5.4
carlosperezit

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 More

$155 AUD in 10 days
(20 Reviews)
4.9
wasifmuneer

Hello, Please give me chance to work with you on this project, I am Microsoft Full Stack developer, having expertise on web based and desktop base application development, including mobile apps as well using Xamarin, More

$222 AUD in 3 days
(11 Reviews)
4.3
AliSafder

Centralizing is not as straight forward as you may think... I need to see the code how the data is saving... It could be that we may not need to change anything in the code... Relevant Skills and Experience You do not More

$150 AUD in 3 days
(17 Reviews)
4.4
more123456

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 More

$155 AUD in 7 days
(8 Reviews)
4.4
LogicalTec

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. [url removed, login to view] allow 200 characters only. PM ? Relevant Skills More

$155 AUD in 10 days
(12 Reviews)
3.8
ketangodhani10

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 More

$155 AUD in 3 days
(6 Reviews)
3.6
deo401

Hi. I have developed an app that is doing what you requested. I have a POS with backoffice that can send data from different stores to one centralize Database but also can update each store with data. Relevant Skills More

$155 AUD in 3 days
(8 Reviews)
3.8
$147 AUD in 1 day
(1 Review)
3.3
$177 AUD in 7 days
(3 Reviews)
3.4
dunitech

Hey There !! We have seen the job post of yours and very interested to start work with you as we have delivered out the similar kind of project I am having major 11+ years experience in PHP PHP5 HTML5 CSS3 Shop More

$155 AUD in 3 days
(4 Reviews)
3.1
slavavardanarman

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, More

$1388 AUD in 40 days
(4 Reviews)
2.6
sahumk2000

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 More

$222 AUD in 3 days
(4 Reviews)
2.7
PghProProgrammer

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 More

$200 AUD in 10 days
(5 Reviews)
2.5
jeethendrav

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

$88 AUD in 3 days
(4 Reviews)
2.0