Đã Đóng

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.

Kỹ năng: .NET, Lập trình C, Linux, Ruby on Rails, SQL

Xem thêm: 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

Về Bên Thuê:
( 16 nhận xét ) Bellevue, United States

Mã Dự Án: #1739880

4 freelancer đang chào giá trung bình $214 cho công việc này


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 trong 15 ngày
(4 Đánh Giá)

For more details please check PMB... Thanks

$155 USD trong 7 ngày
(1 Đánh Giá)

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

$250 USD trong 1 ngày
(0 Đánh Giá)

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

$200 USD trong 4 ngày
(1 Đánh Giá)