It is necessary to check the scripts and update the data in the Postgres database.

Budget: 4200 UAH Deadline: 3 days

Hello. I can help with reviewing and refining SQL scripts for PostgreSQL, comparing data between two databases, analyzing discrepancies, and preparing corrective SQL scripts. To assess, please clarify:
1. What version of PostgreSQL is used on both servers?
2. What is the approximate volume of data (number of tables and records)?
3. In what format will the Excel files and table structure descriptions be provided?
4. Are there existing SQL scripts that need to be refined, or will part need to be written from scratch?
5. What is the budget and desired timeline for completion?

Budget: 3500 UAH Deadline: 4 days

Good day, Ekaterina!

Understood: we need to verify and organize the data in Postgres, reconcile between Excel spreadsheets and two databases on different servers, search for discrepancies, and create SQL scripts for corrections. For each block (items for repair, categories/groups/subgroups, quantity statistics, spare parts), provide the total number of discrepancies plus a fix script. Execution via AnyDesk in Navicat, I work this way.

How I will ensure reliability:
- For each point, first DIAGNOSIS: an SQL query showing discrepancies (count plus the actual records), so you can see the volume before corrections;
- then a FIX script, idempotent (re-running does not break) and in a transaction (rollback if something goes wrong);
- reconciliation of Excel and Postgres and between the two databases through temporary staging tables, to avoid touching production data directly until confirmed;
- for each block, a report showing discrepancies N became 0.

Safe: first in a transaction with verification, then confirmation. No blind corrections on the production database.

Clarification: two databases on different servers, do we connect them through export/import (dump/staging) or is there direct access (dblink/FDW)? This affects the approach to reconciliation.

We work through Safe step by step: Stage 1, diagnosis scripts for all blocks (you see all discrepancies), then correction scripts. Zero risk.

Estimate: 3500 UAH, 4 days. Examples of work: Freelancehunt https://guardlabs.online Expand

Budget: 14000 UAH Deadline: 5 days

Good day! I did an Excel ↔ Postgres reconciliation as a reproducible scenario, not manual editing: first a read-only reconciliation on staging, I calculate discrepancies by keys (product, category, group, balance, serial number), then separate idempotent SQL scripts for corrections and a report for each item. I upload to the production database only after running on the test one and your OK — to avoid surprises on both servers. Is there a test database available, or should we run the reconciliation on a dump of the production one? Ready in 5 days.

Budget: 2000 UAH Deadline: 7 days

Hello, I have worked on data synchronization between two PostgreSQL databases — we identified discrepancies in over 15,000 product records and automatically corrected them through scripts, which is similar to your task.

Could you please let me know if the data in the Excel tables has a fixed format or if the structure can change between updates?

I suggest we get in touch; I will provide you with free technical consultation and we can create a development plan + I will tell you about my team!

Budget: 3000 UAH Deadline: 2 days

Hello!

The task is clear — reconciling and aligning data between two Postgres databases (+ Excel), with a report on discrepancies and correction scripts. Let's get straight to the point, because with inventory data (products, spare parts, balances) the cost of error is high: data cannot be corrected blindly.

Therefore, I work strictly in two stages — and this is exactly the structure you outlined: first, a detection script (read-only) — it calculates discrepancies and provides a table of "what and where does not match," without any changes. You review and confirm. Only then do I run the correction script — separately, in a transaction, checking the number of affected rows before and after, so that the "correction" does not affect anything extra and it is clear what exactly has changed. This way, balances and reference data will remain intact.

When comparing two servers — I match by keys, taking into account that names/identifiers in the databases may differ, while the entity is the same. For each of the 6 points, I provide: number of discrepancies → table → correction script, exactly in your acceptance format. Access via AnyDesk/Navicat — fine, I work in your environment.

One clarification, which affects the entire correction: when the data in the two databases diverges — which one is the source of truth (which one do we align to)? And on which fields do we consider records to be "the same entity"? Let me know — I will give an accurate estimate.

Budget: 2500 UAH Deadline: 3 days

Hello! I am ready to refine SQL scripts for comparing data between Excel spreadsheets and two Postgres databases on different servers - according to the specified list (items for repair, categories/groups/subgroups, quantity of items, spare parts, repair products). For each item, I will prepare a script to identify discrepancies and a correction script. I work via AnyDesk + Navicat. To get started, I need access to both servers and samples of the Excel spreadsheets.

Budget: 3000 UAH Deadline: 3 days

Hello. The task is clear: to adjust SQL scripts for Postgres that compare and organize data between external Excel spreadsheets and two Postgres databases on different servers, according to your list (items for repair, categories and groups, quantity of items in segments, spare parts with relationships, repair products, stock reconciliation). For each item, a discrepancy table and a correction script are needed.

This is exactly my area; I have been working with PostgreSQL and SQL for four years. The logic here is standard for reconciliations: we pull external data (Excel into a temporary table), match by keys, count the number of discrepancies with a separate query, and correct them with a second script, carefully and reversibly, so that the corrections can first be run in a check mode and then applied. The reconciliation between two databases on different servers is done either through exporting to a common intermediate table or via postgres_fdw if the servers can see each other.

One question about access: is the work done only through AnyDesk and Navicat on your side, or can I get direct access to the databases for debugging the scripts? And should discrepancies for each item only be recorded in the report, or should corrections be applied immediately?

Budget: 2000 UAH Deadline: 1 day

Feel free to contact me, I will do it.

Budget: 10000 UAH Deadline: 1 day

Hello!

The task is clear — SQL scripts for comparing data between two PostgreSQL databases and Excel, identifying discrepancies and correction scripts for each of the 6 points.

I work with PostgreSQL, and the submission format matches yours: discrepancy script → discrepancy table → correction script → correctness check in both databases.

Running via AnyDesk and Navicat — no problem.

We will discuss the details and exact price privately after you share the table structure and an example of the Excel file.

I look forward to collaborating! Expand

Budget: 5000 UAH Deadline: 5 days

Hello.

I can take on the task involving PostgreSQL and Excel spreadsheets. For such adjustments, it is important to first obtain a control picture of the discrepancies, and only after that run the UPDATE scripts.

I suggest performing the work as follows:
1. Loading Excel data into temporary / staging tables
2. SQL queries for reconciliation for each block
3. A discrepancies table and the number of records for each item
4. Agreement on the correction logic
5. Separate SQL correction scripts
6. Rechecking after the update

In the scripts, I will include:
- Transactions before changes
- Checking the number of records before/after
- The ability to rerun without corrupting data
- Separate queries for diagnostics and separate ones for corrections
- Minimization of manual edits directly in the production database

Before starting the work, I need to clarify:
- Is there a test database or dump?
- What fields are the keys for comparison?
- Are the Excel spreadsheets the benchmark or do they also need to be verified?
- Is there direct access between the two PostgreSQL servers?
- What current scripts already exist?

I can work via AnyDesk / Navicat, but before making changes, it is advisable to have a backup or a test run.
We can discuss the details in private messages. Expand

Budget: 2500 UAH Deadline: 2 days

Hello!

The task is standard, I will complete it without any problems. I hold the 38th place in the SQL ranking on the relevant site, so I have good practical experience working with databases.

I look forward to collaborating!

Budget: 2500 UAH Deadline: 1 day

Good day. I will do it within 1 day! Ready to start now. Huge experience. Write to discuss.

Budget: 6000 UAH Deadline: 6 days

Good day, Ekaterina.

In brief:

Your data in PostgreSQL will be fully verified and synchronized with Excel spreadsheets and between servers. Each of the six verification points will receive a clear report on discrepancies and SQL scripts for their resolution. Using a direct connection through Navicat will allow for safe updates without the risk of data loss. I will use the excelize library to work with Excel files, which guarantees accurate reading and matching of data. As a result, you will have a consistent database where all products, categories, spare parts, and stocks will be fully aligned.

In detail:

Discrepancies between two PostgreSQL servers and external Excel spreadsheets often arise due to desynchronization of key fields—especially when spare parts are linked to repair items through complex category and subgroup relationships. Your six verification points cover exactly those areas where typical discrepancies accumulate, and each of them requires a separate report with a record count, as well as a separate script for their correction.

Your database will be fully verified through Navicat: for each point, you will receive a discrepancy table, a discrepancy script, and a data correction script for synchronizing both databases. Excel files are matched using the excelize library—this is more reliable than manual import, as type and encoding checks eliminate missed rows without notification. Before executing any UPDATE or DELETE, a backup will be created—this will protect against data corruption if the matching reveals unexpected matches. Your scripts will be adapted to the acceptance format: reconciliation script, discrepancy table, correction script, correct data in both databases.

To avoid scope creep, it is advisable to finalize the exact list of tables and fields for comparison for each of the six points before starting—this way, the correction scripts will cover exactly what is needed, without surprises.

Later, automated verification triggers and constraints can be created. This will eliminate the recurrence of discrepancies in categories and stocks, as the system will automatically reject incorrect data at the PostgreSQL architecture level.

SQL views can also be developed for monitoring product and spare part statistics. This will allow you to instantly see current discrepancies in Navicat without the need to run manual verification scripts each time. Expand

Budget: 1500 UAH Deadline: 1 day

Good afternoon, Ekaterina. I am ready to take on the review of scripts and update the data in your Postgres database.

I have experience working with PostgreSQL and writing SQL scripts for finding discrepancies, matching tables, and updating attributes. The specifics of working with external Excel tables and cross-server comparisons are clear to me.

I am ready to work according to your requirements:
— I will connect via AnyDesk.
— All runs and adjustments of scripts will be conducted directly in Navicat.
— I will strictly follow all 6 points (from checking repair attributes to reconciling balances and serial numbers).

Regarding the price and deadlines, I have oriented myself with the rate (1500 UAH, I will complete it in 1 day). Please let me know if the scripts for correction have already been written and only need adjustments, or if part of the matching logic needs to be written from scratch? I am ready to discuss the details and get started.

Budget: 2800 UAH Deadline: 1 day

Hello! I am ready to help with your project. I have extensive experience in development and can implement all the necessary components according to your documentation. I guarantee quality execution within the agreed deadlines.

Budget: 1000 UAH Deadline: 3 days

Good day!

I have extensive experience working with PostgreSQL, optimizing SQL scripts, and integrating data from Excel. I am ready to professionally review and update your databases, including cross-server synchronizations and working through Navicat.

Message me privately, and we will clarify the details.

Budget: 8000 UAH Deadline: 5 days

Good afternoon! We have experience in data migration and synchronization between remote Postgres instances. We implement the task by writing optimized SQL procedures for processing external files and cross-server queries, ensuring data integrity during updates.