In Progress

Nopcommerce - create data triggers, and tables database synchronization 2 JOB PAYS $175

JOB PAYS $175.00

I Need to sync databases to manage online transactions and in store transactions. and inventory entries

WEBSITE IS ASP.NET, pos.net. the databases currently have a type of enhanced syncing that was done but not all information is being sync in the table. currently both tables are not the same. both databases are on the same server. database is mssql. tables will also need to be modified or created as necessary

Looking to create database triggers/scripts to sync bidirectional data from pos to website, vise verse. real time syncing should take place. For example. if a transaction is made on website, all functions related sale of a purchase or the input of inventory will be recorded in the pos system as well as the website. So if someone purchases an item places that item in their cart and buys it, total quantity remain in stock, what was sold, whats remaining etc, will be recorded in the opposing database. This the best way to keep track of inventory and sale

specifications of site and server:

database: MSSQL 2012

LOCATION OF DATABASE: BOTH ON DEDICATED SERVER

NUMBER OF TABLE TO CREATE: This is a nopcommerce site. so most of the table would be in the pos system. number of table unknown

special note: most of the tables that will need to be created are in the pos system. both databases are different and most tables are need in pos system

website platform: ASP

Skills: .NET, MySQL, HTML, Database Administration, ASP.NET

See more: data swing forms database, create car booking access database, search data fields mysql database, extract data html tables mysql database, tables create real estate website database, create data entry database excel, create program for extract product data from particular online shop -- 2, create program for extract product data from particular online shop 2, enterprise architect create data model from database, how to create multiple pivot tables from one data source, magento 2 create custom module with database, create html form to insert data into mysql database using php, create html form to insert data into mysql database using node js, magento 2 create data model, magento 2 get data from custom database table in phtml, how to fetch data from a database and display it in magento 2, why do you think organizing data into tables and relationships is a good way to design a database, magento 2: create custom module with database, create an html form and insert data into the database using python, create an html form and insert data into the database using django

About the Employer:
( 51 reviews ) flint, United States

Project ID: #28597836

Awarded to:

mdramindz

Hello, I work on nopCommerce. Please view my profile here: https://www.freelancer.com/u/mdramindz.html I'm interested to hear more about the project and about the services. If you message me I'd be very happy to disc More

$175 USD in 7 days
(26 Reviews)
5.3

5 freelancers are bidding on average $134 for this job

ManzoorH

Hello I have 9+ years of experience in .NET and SQL Server. I can write triggers on the busy database and we can record each and every step in the other database. if any thing bought or sale, stocking everything happ More

$175 USD in 4 days
(14 Reviews)
4.4
yauhenispoda

I read your description carefully and figured out your idea. No problem. I have plenty of experience with database manupulation in Asp.net I have a few further detailed questions We can discuss via chat. I will be look More

$140 USD in 7 days
(10 Reviews)
4.5
kundansql

Hi there! I would like to take a look at your prod SQL Server box(es) to get an idea how can sync operation can be done an easy and effective way. I am Database Developer, Administrator and Performance Engineer; with More

$150 USD in 2 days
(5 Reviews)
2.5
jcercos

Hi sir, I'm a certified programmers in dot NET languages with experience in ASP.NET, [login to view URL], C#.NET and VB.NET. I'm certified database administrator too with experience in SQL statements, oracle database servers and m More

$30 USD in 9 days
(4 Reviews)
1.4