Suljettu

Automatic data transfer between 2 SQL databases when record is updated

We need someone experienced in automatic data transfer between 2 different SQL databases residing on 2 different servers.

Background:

1. We have a Commercial Cash Register program that updates the its Sales database when customer pays for their order.

SQL Database A on Server1

2. We have an internal Order Details database that managers our order details

SQL Database B on Server 2

Both servers are on the same internal network.

When a customer pays at the register, [login to view URL] is updated with the order number and amount paid.

We want to automatically trigger an update in our [login to view URL] with similar information

There are only approximately 100 orders per day, so this is not something that has large volume of data to move.

Currently our operators are manually having to update the order status at the end of the day, so we want to do away with that need.

The application behind Database A, has no configurable integration capabilities, so we need to do this via integrating with the database itself when records are added.

We have looked at SQL Service Broker (SSBS) as a possible method of doing this but you may have simpler alternatives to offer.

Thanks

Taidot: Tietokannan hallinto, Tietokantaohjelmointi, Microsoft SQL Server, SQL

Näytä lisää: how to compare two tables in sql in different databases, new data comparison wizard, sql server sync tables between databases, how to compare two databases in sql server, synchronize sql server databases in different remote sources, sql data compare, synchronization between two sql server database, sql query to compare two tables in different databases in sql server, free online tuition sql databases, google maps sql databases, convrt data date format sql, foxpro data entry forms sql server, secure data transfer, automatic data entry table using javascript, xml data transfer sql server, data transfer oracle sql server using vbnet, server type sql mysql data transfer, sql sever configure server data transfer, data transfer sql server local service provider, sql xml data transfer

Tietoa työnantajasta:
( 0 arvostelua ) Agua Sucia, Argentina

Projektin tunnus: #18349966

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

feninsoftech

Hi, This will be achieved by creating linked server between both databases and defining triggers to update data on other server. I have 9 years experience in development and deployment that includes SQL Server, S Lisää

$88 USD 1 päivässä
(46 arvostelua)
6.6
damianhill40

Hello, I have read your project description and understand the problem you need to resolve. I could provide you a sql trigger script that would insert a new record into the table on server b, when a row in databa Lisää

$30 USD 2 päivässä
(9 arvostelua)
5.1
aishwary9122

Hi.. Just read about database replication article and implement it. Database Replication is the best way to archive this task. And you can do it by yourself... plenty of videos out there for this. Thanks

$30 USD 1 päivässä
(2 arvostelua)
4.5
sreenivas2903

Hi. Iam expertise i. Sql querying please let me know more details so that I will finish asap ping me

$55 USD 2 päivässä
(12 arvostelua)
3.9
yubor

hi, would be glad to help with this project. i suppose that replication will be more suitable for you than ssb. regards, yuri

$100 USD 3 päivässä
(19 arvostelua)
3.8
HDDevelopment

Dears, I am expert in SQL server with 10+ years of experience in database and web development i have a good solution for this issue based on database without using any external tools. Thank you

$50 USD 2 päivässä
(4 arvostelua)
3.0
vw8098368vw

Hi there, I carefully read your requirement and I can do this Database-1 to Database-2 synchronisation task. for this we can go through Microsoft Sync Framework. thanks

$40 USD 2 päivässä
(3 arvostelua)
2.7
AllProgs

Estimado, tengo amplia experiencia trabajando con bases de datos, puedo realizarle el trabajo que necesitas para actualizar una base de datos desde la otra, si gusta me escribe y conversar los detalles del trabajo, qu Lisää

$20 USD 1 päivässä
(8 arvostelua)
2.9
bbbssolutions

1. 10 Years of experience 2. Expert in ASP.net,C#.net,VB.net,Sql server,MySql,MS Access,Crystal Report 3. Worked in almost 150 projects. 4. Dedication,timely execution and perfection is my key Skill.

$25 USD 3 päivässä
(2 arvostelua)
2.3
vcallegarip

I have an extensive experience with transferring data from one server to another. I think I can help you.

$222 USD 1 päivässä
(2 arvostelua)
1.6
CanadaAppTeam

Hello, I have had many projects on Database data exchange and depending on the following factors we can decide which method to use: 1- Data size and delay tolerance 2- Connection framework 3- MSSQL Version on sourc Lisää

$55 USD 2 päivässä
(0 arvostelua)
0.0
Juan10123

Este tipo de trabajo es al que estoy acostumbrado en mi oficio, es mi día a día y podemos darle solución rápida y a su problema.

$35 USD 1 päivässä
(0 arvostelua)
0.0
gaurav1985vw

Why can't you create a link server on your database A server pointing to database B server with rpc true options, and write a trigger on data base A which will update records of database B? Relevant Skills and Experie Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
atifiu

I have 7+ years of experience working as Database developer. I would suggest that we can create a text file on Database 1 and at the End of the day that file will be used to update Database 2 by uploading it on Data Lisää

$111 USD 3 päivässä
(0 arvostelua)
0.0
Pingduoduo

Hi... How are you?. I saw your description carefully and i 'm very interesting your project. I have rich experience in your proejct types, so i can do your project perfectly. -------------- We can use cron job o Lisää

$50 USD 1 päivässä
(0 arvostelua)
0.0
bobysiswanto

I have an experience with data migration with Oracle Database. Oracle has some features to do migration between one database to another (odbc is one of the bridge).

$25 USD 1 päivässä
(0 arvostelua)
0.0
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
prashanthpuli23

I have good knowledge on SQL scripting and i have 2 soulutions for tbis type of problems. I will suggest one of them based on the requirements.

$40 USD 2 päivässä
(0 arvostelua)
0.0
fadata

Hi, I am currently working on a similar project (https://www.freelancer.com/projects/project-18300481/ and almost completed) I will deploy it on18/12/2018 to them I will need 1 day in order adapt it to your enviornment Lisää

$188 USD 1 päivässä
(0 arvostelua)
0.0
mexmarius

Hi there, I can build this using 2 sql queries, 2 batch files, and 2 windows schedule tasks. I am a skilled SQL developer with over 7 years experience in building intricate SQL systems for household names and local c Lisää

$40 USD 2 päivässä
(0 arvostelua)
0.0