Design SQL database changes and write some C# code

Виконано Опубліковано %project.relative_time Оплачується при отриманні

$30-250 AUD

Оплачується при отриманні

Виконано Оплачується при отриманні

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.

.NET Програмування на C# Microsoft SQL Server

ID Проекту: #15129954

Про проект

42 заявок(-ки) Дистанційний проект Остання активність 6 роки(ів) тому

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та часові рамки

Отримайте плату за вашу роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручено:

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 Більше

$35 AUD за 60 дні(-в)

(155 відгуків(-и))

7.7

42 фрілансерів(-и) готові виконати цю роботу у середньому за $203

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 Більше

$147 AUD за 3 дні(-в)

(113 відгуків(и))

8.3

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 Більше

$300 AUD за 20 дні(-в)

(28 відгуків(и))

6.8

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 Більше

$150 AUD за 15 дні(-в)

(42 відгуків(и))

6.6

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 Більше

$55 AUD за 3 дні(-в)

(46 відгуків(и))

5.8

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 Більше

$250 AUD за 3 дні(-в)

(27 відгуків(и))

5.7

jitendrabaraiya

A proposal has not yet been provided

$495 AUD за 30 дні(-в)

(3 відгуків(и))

5.2

jcrbahia

although I did not do a deep analysis of the relationship, I think you could. make a trigger "sql", with some integration of .Net, mainly because if you are going to use SqlExpress,make it something more portable. But Більше

$277 AUD за 5 дні(-в)

(3 відгуків(и))

5.0

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 Більше

$155 AUD за 10 дні(-в)

(23 відгуків(и))

5.0

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 Більше

$155 AUD за 7 дні(-в)

(14 відгуків(и))

5.4

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 Більше

$150 AUD за 3 дні(-в)

(17 відгуків(и))

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. freelancer.com allow 200 characters only. PM ? Relevant Skills Більше

$155 AUD за 10 дні(-в)

(18 відгуків(и))

4.0

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 Більше

$155 AUD за 3 дні(-в)

(7 відгуків(и))

3.7

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 Більше

$155 AUD за 3 дні(-в)

(8 відгуків(и))

3.8

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 Більше

$200 AUD за 10 дні(-в)

(7 відгуків(и))

2.8

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 Більше

$222 AUD за 3 дні(-в)

(5 відгуків(и))

2.9

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, Більше

$1388 AUD за 40 дні(-в)

(5 відгуків(и))

2.6

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 за 3 дні(-в)

(4 відгуків(и))

2.0

prefectworld

expert in NET, C# Programming, Microsoft SQL Server Relevant Skills and Experience NET, C# Programming, Microsoft SQL Server Proposed Milestones $30 AUD - budget

$30 AUD за 2 дні(-в)

(1 відгук)

0.1

suniljoshi151

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 Більше

$200 AUD за 3 дні(-в)

(1 відгук)

0.0

AavadeshPatel

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 Більше

$111 AUD за 5 дні(-в)

(0 відгуків(и))

0.0

Опублікувати схожий проект

Design SQL database changes and write some C# code

Про проект

Хочете заробити?

Переваги подання заявок на Freelancer

Доручено:

42 фрілансерів(-и) готові виконати цю роботу у середньому за $203

Freelancer

Огляд

Умови

Додатки