Suljettu

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, website redirect fix, types programming, types data structure, tables data structure, table data structure, structure stores, strings programming, sql server web, ruby rails sql server, ruby rails query, ruby rails database, rails send, programming ruby rails, programming types, programming sql, programming ruby, programming data structure, post ruby rails, portal fix, new web create, new data structure, sql create database, fix website redirect, different types programming

About the Employer:
( 16 reviews ) Bellevue, United States

Projektin tunnus: #1739880

4 freelanceria on tarjonnut keskimäärin 214 $ tähän työhön

tsstaff

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)
3.6
rajeshwarieso

For more details please check PMB... Thanks

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

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)
0.0
szdezso

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

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