1001 Freelance Projects
Latest Projects from
Freelance Marketplaces
View Project
View this project in detail
(Note: you will be redirected to external marketplace)
Project title:
FileMaker Pro to Microsoft SQL Server (MS SQL) Migration
Posted by:
External project from PeoplePerHour
Started:
20-Sep-2025 12:27 GMT
Description:
The business refurbishes IT equipment in three key areas: PCs/Laptops, AV, and Networking.

The current FileMaker Pro system handles order intake (goods-in), tracks unit-level details (brand, model, serial, spec, upgrades), manages engineering workflow (notes, statuses, ready-to-ship), and records shipping info. It also stores commercial data (purchase & shipping prices ex-VAT), supports basic reporting (daily/weekly outputs), and provides user-facing screens to process stock quickly.

This project migrates to a cloud-hosted MS SQL database with a custom internal web app: React (Tailwind + chart library) front-end and a thin API (Node/.NET) that serves data and KPIs. The UI must match or improve current layouts and support core KPI dashboards.

This scope includes Sections 1–3 only. Section 4 (automation, real-time P&L, AI) is not to be implemented now; a separate Technical Backdrop describes groundwork. Sections 1–3 must be built with future expansion in mind.

Section 1 – Core Migration to MS SQL

Objective: Recreate FileMaker logic and data in a normalized, indexed MS SQL schema, ready for API consumption.

Deliverables

Cloud-hosted MS SQL setup with least-privilege access control.

Logical data model & ERD (from FileMaker exports/screenshots).

Normalized schema with PK/FK, key indexes, and core views.

Full data migration (cleansing, transformation notes, reconciliation).

Reference tables (suppliers, engineers, statuses, codes, brands, categories, channels).

Documentation: schema guide, migration steps, backup/restore process.

Acceptance Criteria

Row counts validated; FK relationships enforced.

Sample lookups return in ~1s or less.

Backup and restore tested and documented.

Section 2 – Custom UI + API

Goal: Deliver an internal web app as usable as (or better than) FileMaker, with a thin API layer.

Frontend (React + Tailwind) – Minimum Screens

Goods-In: intake, supplier link, statuses, notes, timestamps.

Production Worksheet: engineer queue, actions/notes, ready-to-ship toggle.

Dispatch/Shipping: ready list, carrier/label refs, shipped timestamps.

Search/Record View: search by SKU/serial/unit; editable detail view with validation.

API (Node/.NET)

REST endpoints for units, goods-in, shipments, production queues, engineers, KPIs.

Server-side validation; created_by/updated_by and timestamps.

Internal/trusted users now; design to accept OIDC/Azure AD later.

Acceptance Criteria

All workflows achievable with same or fewer clicks vs FileMaker.

Field validation + audit fields recorded.

Responsive for desktop use; access limited to internal/trusted users.

Section 3 – KPI Dashboards & Reports

KPIs Required

Time from goods-in to finished/ready-to-ship/shipped (per unit & per batch).

Engineer throughput (units/day or week); flag returns if available.

Shipping volumes (daily/weekly), sliced by brand/supplier/category.

Basic batch profitability: purchase + logged costs vs revenue (where data exists).

Deliverables

React KPI views (charts/tables via Recharts/Chart.js) backed by API/SQL views.

Exports: daily/weekly in CSV/PDF (server-side export endpoint); Google Sheets optional later.

Brief docs: KPI definitions and SQL per card.

Acceptance Criteria

KPI outputs match test calculations on supplied data.

Scheduled or manual exports work as expected.

Inputs We Provide

FileMaker exports (CSV/Excel), layout screenshots.

Sample KPIs and example calculations.

SQL credentials and app/API environment (or guidance).

Named contacts for testing/decisions.

Out of Scope

Automation, live P&L, smart pricing, forecasting (see Technical Backdrop).

Amazon SP-API, Linnworks, Repricer, etc., beyond preparatory schema/API surfaces.

Public/external UI; mobile optimization.

Non-Functional Requirements

Security: Least-privilege access; secrets not in repos (use env/KeyVault).

Backups: Daily backups; at least one restore tested successfully.

Performance: Fast queries (
Project ID:
3450273
Project category:
Project budget:
View this project in detail
(Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Complete a Teaching Video on Canva
Category: After Effects, Animation, Video Editing, Video Production, Video Services
Budget: $100 - $200 USD
09 Dec 2025 21:30 GMT
Video Editing, Photo Editing, and Business Pamphlet Design
Category: Brochure Design, Graphic Design, Photoshop, Photoshop Design, Video Editing
Budget: ₹25000 - ₹50000 INR
09 Dec 2025 17:11 GMT
Konten Kreatif dan Inspiratif -- 2
Category: Blog Writing, Content Creation, Content Development, Content Marketing, Content Strategy, Copywriting, Creative Writing, Social Media Management
Budget: $250 - $750 USD
09 Dec 2025 16:55 GMT
Rewrite Development Site Copy
Category: Article Rewriting, Article Writing, Branding, Business Writing, Content Writing, Copywriting, Creative Writing, Editing, Ghostwriting, Technical Writing
Budget: $250 - $750 USD
09 Dec 2025 16:55 GMT
Mastercam modeling and Programming -- 2
Category: 3D CAD, 3D Design, 3D Modelling, Automotive Engineering, CAD / CAM, CNC Programming, Engineering Drawing, Manufacturing Design, Mechanical Engineering, Product Design
Budget: ₹12500 - ₹37500 INR
09 Dec 2025 16:55 GMT
Fast-Paced Instagram Video Editing
Category: Adobe Premiere Pro, After Effects, Social Media Marketing, Video Editing, Video Post Editing, Video Production, Video Services, Videography
Budget: £20 - £250 GBP
09 Dec 2025 16:55 GMT
Build a Custom Visual Page Builder (No-Code Editor) for My SaaS
Category: AngularJS, Frontend Development, JavaScript, Liquid Template, Node.js, React.js, REST API, SaaS, Web Development
Budget: ₹12500 - ₹37500 INR
09 Dec 2025 16:54 GMT
Stone Texture Recolor to Light Gray
Category: Photoshop
Budget: $30 - $250 USD
09 Dec 2025 16:53 GMT
International Business Strategy Report
Category: Academic Writing, Business Analysis, Business Strategy, Data Analysis, Market Research, Research Writing
Budget: $250 - $750 SGD
09 Dec 2025 16:51 GMT
Shopify Store builder website audit and optimization 09 Dec 2025 16:47 GMT
Revit work file edit and add site plan 09 Dec 2025 16:47 GMT
Client-Attracting Mobile App
Category: Android, API Integration, IOS Development, IPhone, Mobile App Development, PHP, UI / User Interface, UX / User Experience
Budget: $10 - $30 USD
09 Dec 2025 16:46 GMT
Virtual Assistant Needed to Find and Contact U.S. Developers
Category: Data Entry, Email Marketing, Excel, Full Stack Development, Lead Generation, Social Media Management, Virtual Assistant, Web Search
Budget: $750 - $1500 USD
09 Dec 2025 16:46 GMT
Shopify Hydrogen Developer 09 Dec 2025 16:46 GMT
Promoter for Udemy Information Security Courses -- 3
Category: Affiliate Marketing, Content Marketing, Digital Marketing, Email Marketing, Internet Marketing, Keyword Research, Link Building, Marketing Strategy, SEO, Social Media Marketing
Budget: $30 - $250 USD
09 Dec 2025 16:46 GMT
Browse All Projects
Projects by Skills ...
android
ajax
asp
aspnet
cms
cpp
csharp
css
delphi
design
drupal
excel
facebook
flash
html
java
javascript
joomla
iphone
mysql
photoshop
php
python
ruby
seo
sql
sysadm
translate
typing
twitter
vbnet
xml
wordpress
writing
New!
Проекты на русском
(Projects in Russian)

Copyright © 2005-2024
1001 Freelance Projects