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

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.

Taidot: .NET, C-ohjelmointi, Linux, Ruby on Rails, SQL

Näytä lisää: push sql ruby, what ruby on rails, what is ruby programming, what is data structure in programming, what is data structure in c, what is data structure, what is data in data structure, what is a data structure in c, what is a data structure, what data structure, what can i create with ruby on rails, what are the types of data structure, what are the application of data structure, what are data structure, website redirect fix, types of programming, types of data structure, types data structure, tables in data structure, table data structure

Tietoa työnantajasta:
( 16 arvostelua ) Bellevue, United States

Projektin tunnus: #1739880

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


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 15 päivässä
(4 arvostelua)

For more details please check PMB... Thanks

$155 USD 7 päivässä
(1 arvostelu)

Custom software development - The Administrator removed this message due to advertising which breaches our Terms and Conditions.

$250 USD 1 päivässä
(0 arvostelua)

I have experience for n tier app, db, and cloud app design and developments.

$200 USD 4 päivässä
(1 arvostelu)