
Closed
Posted
Paid on delivery
I need an experienced database engineer to move our current Oracle workload over to Microsoft SQL Server—and be able to roll the data back the other way should we decide to revert. This is a true end-to-end migration: tables, indexes, constraints, sequences, views, procedures, functions, triggers, and the historical data itself all have to arrive intact on the new platform, with type mappings and performance characteristics that feel native to SQL Server. You will plan the cut-over, build the conversion scripts, run the ETL (Oracle Data Pump, SQL*Plus, SSMA, SSIS—whatever combination you prefer), and document every decision so the team here can maintain the system afterward. Zero data loss and verifiable referential integrity are non-negotiable, and the production window for the final switch needs to stay under two hours. Deliverables • Schema conversion scripts and repeatable migration procedure • Fully migrated SQL Server database validated against the Oracle source • Performance benchmark report before and after migration • Roll-back plan proving the data can safely return to Oracle if required • Post-migration checklist and hand-over documentation Acceptance criteria: a checksum match on every table, successful execution of our core business procedures in SQL Server, and throughput equal to or better than the Oracle baseline. If this sounds like a routine you’ve mastered, let’s talk timelines and approach. I want a c# code to do this.
Project ID: 40522874
18 proposals
Remote project
Active 21 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs