# MODIFIABLE REQUEST FOR PROPOSALS (RFP) TEMPLATE
## Project Title: Microsoft SQL Server, SSIS & SSRS Migration to Oracle Autonomous Database 23ai & OCI
- **RFP Document Reference**: `VNA-RFP-011` (Companion to Solution Brief `VNA-SB-011`)
- **Issuing Organization**: `[INSERT ORGANIZATION / COMPANY NAME]`
- **Issue Date**: `[2026-10-27]`
- **Proposal Due Date**: `[INSERT DATE, e.g., +30 Calendar Days]`
- **Reference Architecture Portal**: https://sql-server-to-oracle-oci.web.app/
- **Template Attribution**: This site is designed by Viscosity.AI

---

## SECTION 1: ISSUING ORGANIZATION PROFILE & PROCUREMENT SCHEDULE (MODIFIABLE)

> **Instructions for RFP Author**: Replace all bracketed placeholders (`[...]`) below with your organization's specific dates, contacts, and environment metrics before issuing to prospective bidders.

| Procurement Milestone | Target Date / Entry (Modifiable) |
|---|---|
| Issuing Organization Name | `[Insert Legal Entity Name]` |
| Primary Procurement / Technical Contact | `[Insert Name, Title, Email]` |
| RFP Issue Date | `[2026-10-27]` |
| Vendor Written Questions Due | `[Insert Date - Week 2]` |
| Organization Responses to Vendor Q&A | `[Insert Date - Week 3]` |
| Final Vendor Proposals & Pricing Due | `[Insert Date - Week 4]` |
| Technical Architecture Demos / Oral Presentations | `[Insert Date - Week 5]` |
| Target Contract Award & Phase 0 Kickoff | `[Insert Date - Week 6]` |

### 1.1 Executive Summary & Business Objectives
`[INSERT COMPANY NAME]` ("Organization") is soliciting competitive proposals from qualified enterprise architecture and engineering firms to modernize and transition our current **Microsoft SQL Server (2008 R2 - 2022), T-SQL, SSIS & SSRS** environment to **Oracle Database 23ai / Autonomous Database on OCI (or SQL Server on OCI)**.

Our primary business and technical objectives are:
- SQL Server Enterprise Edition per-core licensing combined with Windows Server Datacenter and Software Assurance renewals makes running sprawling 4-to-16 core SQL Server VMs prohibitively expensive.
- Hundreds of undocumented SQL Server Integration Services (`.dtsx` SSIS) packages and SQL Server Reporting Services (`.rdl` SSRS) reports keep legacy servers alive years past End-of-Support.
- Running SQL Server on generic AWS or Azure VMs hits storage IOPS throttling limits unless you provision oversized compute shapes.

---

## SECTION 2: CURRENT ENVIRONMENT BASELINE INVENTORY (MODIFIABLE)

Bidders must size their technical delivery plan and fixed-fee milestone pricing against the baseline inventory table below:

| Inventory Dimension | Current Baseline Count / Footprint (Modifiable) | Target Modernization SLA / Objective |
|---|---|---|
| Legacy Source Stack (`Stack X`) | Microsoft SQL Server (2008 R2 - 2022), T-SQL, SSIS & SSRS | Full retirement / modernization |
| Target Architecture (`Stack Y`) | Oracle Database 23ai / Autonomous Database on OCI (or SQL Server on OCI) | Production-grade HA/DR & security |
| SQL Server T-SQL Procedures & Views | `[Insert Count, e.g., 500 T-SQL objects]` | 100% functional parity & optimization |
| SSIS (.dtsx) Packages & SSRS (.rdl) Reports | `[Insert Count, e.g., 180 ETL/Reports]` | Automated AST & schema uplift |
| SSRS Report Query Fan-Out Rationalization (Core SQL Views + Runtime APEX Filters) | `[Insert Count, e.g., 78 % fan-out reduction]` | `[Target Rationalization / SLA]` |
| Target Cutover Downtime Window | `[e.g., < 15 Minutes / Near-Zero Downtime]` | Rehearsed parallel run + rollback plan |
| Security, Compliance & Identity | `[e.g., SSO/MFA via Entra ID / Okta, Row-Level VPD, Audit Logs]` | Zero critical/high CVEs at Go-Live |

---

## SECTION 3: MANDATORY TECHNICAL SCOPE OF WORK & DELIVERABLES (MODIFIABLE)

The selected partner shall execute the project across four gated phases (**Phase 0: AST Discovery & Architecture Blueprint**, **Phase 1: Core Foundation & Data/Code Conversion**, **Phase 2: Integration, Runtime Filtering & UAT**, and **Phase 3: Parallel Run, Cutover & Hypercare**).

### 3.1 Core Architectural Requirements
1. **[MODIFIABLE REQUIREMENT 1]**: Two Proven Target Lanes Based on Application Coupling: Lane 1 (Full Replatform to Oracle 23ai + APEX) converts custom SQL Server databases, T-SQL procedures, and SSRS reports into Oracle Autonomous Database 23ai and Oracle APEX. Lane 2 (SQL Server Consolidation on OCI / OCVS) consolidates third-party COTS SQL Server databases onto OCI DenseIO NVMe / Block Volume Ultra High Performance with Microsoft license mobility or BYOL.
2. **[MODIFIABLE REQUIREMENT 2]**: Automated T-SQL, SSIS (`.dtsx`), and SSRS (`.rdl`) Conversion: Our XML parser extracts SQL queries and transformations from `.dtsx` and `.rdl` files, converting SSIS dataflows into OCI Data Integration / PL/SQL pipelines and SSRS reports into APEX Interactive Reports and AOP.
3. **[MODIFIABLE REQUIREMENT 3]**: Oracle Database@Azure & OCI-Azure Interconnect: For hybrid estates where .NET apps remain in Azure, we deploy over the sub-2ms private OCI-Azure Interconnect or Oracle Database@Azure with zero cross-cloud egress fees.
4. **[MODIFIABLE REQUIREMENT 4]**: Query Fan-Out Rationalization & Runtime/Inference Filtering: Instead of migrating cloned reports and DataWindows 1-for-1, our AST SQL parser clusters queries by their canonical core JOIN graph, builds governed Oracle 23ai views only for those core queries, and generates dynamic WHERE clauses, faceted filters, and ad-hoc report variations at runtime and via AI inference (APEX 24.2 Smart Filters & Select AI).

### 3.2 Component-Level Conversion & Deliverable Matrix
Bidders must confirm compliance with each component conversion requirement below:

| Req ID | Legacy Artifact / Baseline Workload | Required Target Architecture | Engineering Method & Acceptance Criteria | Priority (Modifiable) |
|---|---|---|---|---|
| REQ-01 | SQL Server Databases & Schemas (`dbo.*`) | Oracle 23ai Pluggable Databases (PDBs) / Autonomous DB | SQLcl / GoldenGate Schema & Data Migration | `[Mandatory / Optional]` |
| REQ-02 | T-SQL Stored Procedures, Views & Functions | Oracle 23ai PL/SQL Packages & SQL Macros | AST Transpilation (with native 23ai Boolean & IF EXISTS) | `[Mandatory / Optional]` |
| REQ-03 | SSIS Packages (`.dtsx`) & SQL Agent Jobs | OCI Data Integration / `DBMS_SCHEDULER` & PL/SQL | XML Dataflow Extraction & Serverless Orchestration | `[Mandatory / Optional]` |
| REQ-04 | SSRS Reports (`.rdl` Paginated & Tabular) | Oracle APEX 24.2 Reports + APEX Office Print / OAC | RDL Query Harvester & Template Rebinding | `[Mandatory / Optional]` |
| REQ-05 | SQL Server Linked Servers (`OPENQUERY`) | Oracle Database Links / ORDS REST Data Sources | Federated Query Optimization | `[Mandatory / Optional]` |
| REQ-06 | Cloned Reports / Queries Differing Only by WHERE Clause or Group-By (Query Fan-Out) | Canonical Core SQL View + APEX 24.2 Runtime / AI Inference Filters | AST Join-Graph Clustering (75-90% Report Count Reduction) | `[Mandatory / Optional]` |

### 3.3 Mandatory Platform & Tooling Standards
- Oracle Autonomous Database 23ai & Oracle Base Database Service on OCI
- Oracle GoldenGate for SQL Server (heterogeneous real-time CDC)
- OCI Data Integration & Oracle Data Integrator (ODI) for SSIS replacement
- Oracle APEX 24.2 & Oracle Analytics Cloud (OAC) for SSRS replacement

---

## SECTION 4: VENDOR TECHNICAL Q&A QUESTIONNAIRE & SCORING RUBRIC

Bidders must provide direct, concise written responses to each question below. The Issuing Organization's evaluation committee will grade responses using the embedded benchmark criteria.

### Vendor Question 1: How do Oracle 23ai new features simplify migrating from SQL Server?
- **Bidder Response Requirement**: Provide a concrete architectural explanation, reference toolset, and verifiable production proof. Generic marketing statements will be scored zero.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: Oracle Database 23ai introduced native SQL `BOOLEAN` data types, `SELECT` without `FROM DUAL`, `CREATE TABLE IF NOT EXISTS`, multi-row `VALUES` constructors, `UPDATE/DELETE` with direct `FROM` joins, and `DBMS_SQL.RETURN_RESULT`, removing 90% of historical T-SQL-to-Oracle friction.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 2: What if a third-party vendor application only supports Microsoft SQL Server?
- **Bidder Response Requirement**: Provide a concrete architectural explanation, reference toolset, and verifiable production proof. Generic marketing statements will be scored zero.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: We host and consolidate those COTS SQL Server instances on OCI Compute with Flexible OCPU shapes and high-IOPS Block Volumes (or via OCI-Azure Interconnect), typically cutting infrastructure and storage costs by 40%+ compared to AWS/Azure.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 3: What is included in the downloadable PDF Solution Brief?
- **Bidder Response Requirement**: Provide a concrete architectural explanation, reference toolset, and verifiable production proof. Generic marketing statements will be scored zero.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: The PDF Solution Brief includes the SQL Server-to-Oracle 23ai feature parity guide, our SSIS/SSRS XML extraction workflow, and a 4-cloud SQL Server hosting cost comparison.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 4: How do you prevent report and query fan-out bloat, and how do you guarantee zero vendor lock-in?
- **Bidder Response Requirement**: Detail your methodology for clustering redundant legacy queries/reports into canonical core SQL views with runtime or AI-inference filtering, and specify customer code/data ownership upon project completion.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: Bidder must demonstrate deterministic AST SQL clustering (collapsing 75%-90% of cloned reports into core database views with runtime predicates), 100% customer ownership of all DDL, PL/SQL, application source code, and Terraform scripts, and zero proprietary runtime lock-in.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 5: Describe your automated regression testing, parallel run, and zero-downtime cutover methodology.
- **Bidder Response Requirement**: Specify how data parity, business-rule equivalence, and rollback safety are verified prior to production cutover.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: Bidder must provide automated row-count and cryptographic hash reconciliation, automated unit/UI test suites (e.g., utPLSQL, Playwright), and a rehearsed cutover runbook with sub-minute rollback capability.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

---

## SECTION 5: COMMERCIAL PRICING & LICENSING MATRIX (MODIFIABLE)

Bidders must complete the fixed-price milestone table below and disclose all recurring software or cloud consumption assumptions.

| Milestone / Cost Category | Deliverable & Acceptance Gate | Fixed Fee / Annual Cost (USD) | Estimated Duration (Weeks) |
|---|---|---|---|
| **Phase 0: Discovery & AST Code/Schema X-Ray** | Verified inventory, dead-code manifest, core SQL fan-out map, and final blueprint | `$[Insert]` | `[2 - 3 Weeks]` |
| **Phase 1: Target Environment & Automated Uplift** | Provisioned target stack, schema migration, and core business logic conversion | `$[Insert]` | `[4 - 8 Weeks]` |
| **Phase 2: UI, Integrations, Reporting & UAT** | Completed application/portal screens, runtime reports, AOP templates, and UAT sign-off | `$[Insert]` | `[3 - 6 Weeks]` |
| **Phase 3: Production Cutover & Hypercare** | Rehearsed cutover, reconciliation sign-off, documentation, and 30-day hypercare | `$[Insert]` | `[2 - 3 Weeks]` |
| **Optional: Annual Managed Services / Support** | 24x7 monitoring, patching, DBA performance tuning, and quarterly enhancements | `$[Insert / yr]` | `[12 Months]` |

---

## SECTION 6: PROPOSAL EVALUATION SCORECARD (MODIFIABLE)

| Evaluation Criterion | Weight (%) | Description |
|---|---|---|
| **1. Technical Architecture & Automation Tooling** | `35%` | Depth of AST automation, query fan-out rationalization, database/cloud architecture, and zero lock-in. |
| **2. Verifiable Production Experience & References** | `25%` | Proven track record delivering identical `SQL Server, SSIS & SSRS to Oracle / OCI` engagements with measurable outcomes. |
| **3. Cutover Safety, Testing & Compliance** | `20%` | Rigor of data reconciliation, automated regression testing, security/compliance controls, and rollback safety. |
| **4. Commercial Value & Total Cost of Ownership (TCO)** | `20%` | Transparent fixed-fee milestone pricing and 3-to-5 year software/cloud licensing savings. |
| **TOTAL** | **`100%`** | |

---
*Template Reference: `VNA-RFP-011` | Companion Portal: https://sql-server-to-oracle-oci.web.app/ | This site is designed by Viscosity.AI*