Find Jobs
Hire Freelancers

Create data push from Postgres/Ruby to SQL Server/C#

$30-250 USD

Closed
Posted over 11 years ago

$30-250 USD

Paid on delivery
Here's the setup: As-is state: 1 client application (written in Pasqual) that communicates to a web portal (website) via an API call (site and API written in Ruby on Rails) that stores data in a Postgres database. To-be state: future rewrite of client but need now to have Pasqual client send data (either directly or post API-call, store the data in MS SQL Server tables), with no changes to current client application With that said, I have a few caveats. The MS SQL Server table structure (num of tables, columns, types of columns and naming convention) are all different. I can change the URL that the client is calling to redirect the data which appears to be URL Query Strings being sent to the API. I also have the option of letting it keep doing what it does now since this move to the new web portal using the current client is only a short-term fix for the next 3-6 months. My thought here is to do something like a db-link, trigger, foreign table? to port only the data I need into the new table structure from in MS SQL Server, from Postgres, leaving everything else uninterrupted since all I need is the current client data which will then be visually displayed in the new portal once in my SQL Server tables.
Project ID: 1739880

About the project

4 proposals
Remote project
Active 12 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
4 freelancers are bidding on average $214 USD for this job
User Avatar
I can provide the full migration (including the C# client) at the quoted price. Please give me the detailed specs of the project. Thank you.
$250 USD in 15 days
4.7 (4 reviews)
3.6
3.6
User Avatar
For more details please check PMB... Thanks
$155 USD in 7 days
4.6 (1 review)
2.4
2.4
User Avatar
Custom software development - The Administrator removed this message due to advertising which breaches our Terms and Conditions.
$250 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience for n tier app, db, and cloud app design and developments.
$200 USD in 4 days
0.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
Bellevue, United States
5.0
16
Payment method verified
Member since Apr 3, 2011

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.