1001 Freelance Projects -- FileMaker Pro to Microsoft SQL Server (MS SQL) Migration

Latest Projects from
Freelance Marketplaces

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)

Project	Started
Employment Verification in Turkey Category: Business Analysis, Customer Service, Data Collection, Data Entry, Documentation, Proofreading, Report Writing, Research Budget: $10 - $60 USD	27 Feb 2026 05:04 GMT
Food-Safe Cooling Insert Design Category: 3D CAD, Chemical Engineering, Engineering, Food Safety, Manufacturing Design Budget: $250 - $750 USD	27 Feb 2026 05:04 GMT
AI Image & Short Video Creator (Fashion Concept Execution) Category: After Effects, AI Art Creation, AI Content Creation, AI Graphic Design, AI Image Editing, AI Rendering, Animation, Fashion Design, Graphic Design, Motion Graphics Budget: $10 - $30 CAD	27 Feb 2026 05:03 GMT
Automate AutoCAD Data Extraction Category: AutoCAD, Automation, Data Extraction, Data Processing, Excel, Python, Scripting, Visual Basic Budget: ₹12500 - ₹37500 INR	27 Feb 2026 05:02 GMT
Guiones Virales para Reels Temática Impresión 3D Category: After Effects, Article Writing, Content Writing, Creative Writing, Script Writing, Social Media Marketing, Viral Marketing Budget: $30 - $250 USD	27 Feb 2026 05:02 GMT
CEO Journey Interview Category: Business Analysis, Business Writing, Content Creation, Content Development, Content Writing, Copywriting, Editorial Writing, Interviewing, Journalism, Research Budget: $250 - $750 USD	27 Feb 2026 05:02 GMT
Modern Instagram Reel Video Editing Category: Adobe Premiere Pro, After Effects, Final Cut Pro, Social Media Management, Video Ads, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: $10 - $11 USD	27 Feb 2026 05:01 GMT
Copy Typing -- 2 Category: Android, Data Entry, Data Management, Data Processing, Excel, Time Management, Typing Budget: ₹12500 - ₹37500 INR	27 Feb 2026 05:01 GMT
Health & Wellness Blog Writer Category: Article Rewriting, Article Writing, Blog, Blog Writing, Blogging, Content Writing, Copywriting, Research Writing, SEO Writing Budget: ₹750 - ₹1250 INR	27 Feb 2026 04:59 GMT
Vintage Badge Artwork Design Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Logo Design, Print Design, Vector Design Budget: $30 - $250 USD	27 Feb 2026 04:58 GMT
Tutor Privat Konsep Sulit Category: Academic Writing, Content Development, Education & Tutoring, Educational Research, Instructional Design, Learning Management Systems (LMS), Public Speaking, Teaching / Lecturing Budget: $15 - $25 USD	27 Feb 2026 04:58 GMT
Recording Desktop Web App for Short Social Tutorials (Long-Term Project) Category: Adobe Premiere Pro, Social Media Marketing, Video Ads, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services, Video Streaming, Videography Budget: $10 - $30 USD	27 Feb 2026 04:56 GMT
Minecraft Hindi Video Editor Category: Adobe Premiere Pro, Audio Services, Final Cut Pro, Sound Design, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR	27 Feb 2026 04:54 GMT
Substack Promotions Category: Advertisement Design, Branding, Business Card Design, Creative Design, Flyer Design, Graphic Design, Marketing, Photoshop, Print Design, Visual Design Budget: €250 - €750 EUR	27 Feb 2026 04:54 GMT
App de Gestão de Projetos Category: Android, Backend Development, Flutter, Graphic Design, IPhone, Mobile App Development, Node.js, React Native Budget: $30 - $250 USD	27 Feb 2026 04:52 GMT

Browse All Projects

New!
Проекты на русском (Projects in Russian)