1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 24-Mar-2026 11:48 GMT
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
Virtual Interior Walkthrough for Modern Luxury Townhome
Category: 3D Animation, 3D Modelling, 3D Rendering, 3ds Max, Interior Design
Budget: $400 - $800 USD
24-Mar-2026
13:23 GMT
UI Design for CRM Landing Page
Category: Figma, Graphic Design, HTML, UI / User Interface, User Experience Research, User Interface / IA, Web Design
Budget: ₹600 - ₹1500 INR
24-Mar-2026
11:04 GMT
Modern Clean Figma Showcase Site
Category: Figma, Graphic Design, Photoshop, UI / User Interface, User Interface / IA, Web Application, Web Design, Web Development
Budget: ₹1500 - ₹12500 INR
24-Mar-2026
11:03 GMT
E-Commerce Product Image Scraper
Category: BeautifulSoup, Python, Scrapy, Selenium, Web Scraping
Budget: ₹600 - ₹1500 INR
24-Mar-2026
11:02 GMT
Comprehensive Audit and Enhancements for TrainPizza
Category: Conversion Rate Optimization, Graphic Design, HTML, PHP, User Experience Research, Web Design, Website Audit
Budget: ₹1500 - ₹12500 INR
24-Mar-2026
11:01 GMT
video editors needed
Category: Editing, Video Editing, Video Production, Video Services
Budget: $115 - $200 HKD
24-Mar-2026
11:01 GMT
TYPO3 Upgrade & Redesign
Category: Accessibility, Database Management, HTML, PHP, SEO, TYPO3, Web Design, Web Development, Website Optimization
Budget: €250 - €750 EUR
24-Mar-2026
11:00 GMT
Cell Replication for new found NanoCells
Category: Engineering, General Labor, Mechanical Engineering, Network Administration, Wireless
Budget: €750 - €1500 EUR
24-Mar-2026
10:59 GMT
Urgent Email Restore & Migration
Category: Cloud Computing, CPanel, Linux, Network Administration, PHP, System Administration, Technical Support, Troubleshooting, Web Hosting, Web Security
Budget: $10 - $30 USD
24-Mar-2026
10:57 GMT
AI Search Optimization Expert | Rank on Google, ChatGPT & AI Platforms
Category: AI (Artificial Intelligence) HW / SW, AI Chatbot Development, AI Content Creation, AI Development, AI Model Development, AI Text To Text, Internet Marketing, Link Building, Search Engine Marketing (SEM), SEO
Budget: ₹75000 - ₹150000 INR
24-Mar-2026
10:55 GMT
Social Media Manager Πωλήσεων Αυτοκινήτων
Category: A / B Testing, Advertising, Analytics, Content Creation, Content Strategy, Digital Marketing, Facebook Marketing, Social Media Management, Social Media Marketing
Budget: €250 - €750 EUR
24-Mar-2026
10:55 GMT
SEO | AEO | GEO Expert Proposal
Category: Content Strategy, Content Writing, Conversational AI, Generative AI, Internet Marketing, Keyword Research, Link Building, Marketing, Prompt Engineering, SEO
Budget: ₹150000 - ₹250000 INR
24-Mar-2026
10:53 GMT
Edición Creativa de Promos
Category: Adobe Premiere Pro, After Effects, Animation, Creative Design, DaVinci Resolve, Graphic Design, Motion Graphics, Video Editing, Video Production, Video Services
Budget: £18 - £36 GBP
24-Mar-2026
10:53 GMT
Framtida medgrundare sökes: Är du experten som kan bygga webb och sociala medier i världsklass?
Category: Business Analysis, Business Development, Business Plans, Facebook Marketing, Internet Marketing, Marketing Strategy, SEO, Social Media Marketing, Social Networking, Web Development
Budget: €8 - €100000 EUR
24-Mar-2026
10:52 GMT
Rancang Robot Interaksi Manusia
Category: 3D Animation, 3D Modelling, AutoCAD, CAD / CAM, Embedded Systems, Motor Control, Raspberry Pi, Robotics
Budget: $250 - $750 USD
24-Mar-2026
10:52 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Short URL:
1001fp.com
Mobile version:
m.1001freelanceprojects.com
Copyright © 2005-2025 1001 Freelance Projects