Find Jobs
Hire Freelancers

Automatic data transfer between 2 SQL databases when record is updated

$10-30 USD

Closed
Posted over 5 years ago

$10-30 USD

Paid on delivery
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
Project ID: 18349966

About the project

21 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $64 USD for this job
User Avatar
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, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Thanks
$88 USD in 1 day
4.9 (53 reviews)
6.8
6.8
User Avatar
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 database a table is updated/inserted. I could provide the solution as a script for you to install yourself, or I can add it to your server for you using a Remote Desktop session. If you would like to discuss further, please contact me on chat. Regards Damian
$30 USD in 2 days
5.0 (9 reviews)
5.1
5.1
User Avatar
Hi. Iam expertise i. Sql querying please let me know more details so that I will finish asap ping me
$55 USD in 2 days
4.9 (21 reviews)
4.5
4.5
User Avatar
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 in 1 day
4.9 (2 reviews)
4.5
4.5
User Avatar
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. Lets discuss it over chat. Regards Fatih.
$188 USD in 1 day
5.0 (5 reviews)
4.1
4.1
User Avatar
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 in 3 days
5.0 (19 reviews)
3.8
3.8
User Avatar
I have an extensive experience with transferring data from one server to another. I think I can help you.
$222 USD in 1 day
5.0 (4 reviews)
3.5
3.5
User Avatar
I have 5 years experience in SQL server.I have gone through the requirement carefully.I have handled similar task with different approach like log shipping or through ETL framework.
$45 USD in 1 day
5.0 (4 reviews)
3.1
3.1
User Avatar
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 in 2 days
5.0 (5 reviews)
3.1
3.1
User Avatar
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 in 2 days
5.0 (4 reviews)
3.0
3.0
User Avatar
HI , I have seen your requirement and i feel that i m suitable candidate to do that task .I having 10 + year Experience in Microsoft SQL server Programming,Administration and SSIS parts . there few ways to solve this problem we could discuss on this . I feel my self luck to talk to you so Regards Avin Panwar
$61 USD in 1 day
5.0 (2 reviews)
1.1
1.1
User Avatar
Hola, Como el origen de esta oferta es Argentina, escribiré en español. Tengo al menos 2 ideas para cumplir el requerimiento en un corto tiempo. Asumiendo que hablamos de SQL Server (cualquier versión). Me gustaría conocer mas detalles de las tablas involucradas, si fuera posible contáctame por el chat. Cordialmente Pablo Gutiérrez
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having 5yrs if experience as data engineer and certified Microsoft sql professional. Have written complex sql queries and good at DB, ETL diesgns and solutions
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 doing DB design. Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 Database 2 without requiring any interface but will be done using Database scheduler jobs.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 Experience Experience in database programming
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 source and destination A very safe and efficient way to use is "SQL server Linked servers" to exchange data specially on internal network. Regards, Ben
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ARGENTINA
Agua Sucia, Argentina
0.0
0
Payment method verified
Member since Sep 29, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.