SQL Server Databases
Overview
This document lists all SQL Server databases used by the Publix Mobile App Chat (S0PMOBAI) system across all environments.
SQL Servers and Databases
Development (DEV)
Failover Group Connection (Recommended):
| Server Name | Database Name | Purpose |
|---|---|---|
cutdfgpmobchat01.database.windows.net | cutdsqdbpmobchat01 | Failover group endpoint (automatically routes to primary) |
Direct Server Connections:
| Server Name | Region | Purpose |
|---|---|---|
cutdasqlpmobchat01.database.windows.net | East US 2 | Direct connection to East US 2 server |
cucdasqlpmobchat01.database.windows.net | Central US | Direct connection to Central US server |
Test (TST)
Failover Group Connection (Recommended):
| Server Name | Database Name | Purpose |
|---|---|---|
cuttfgpmobchat01.database.windows.net | cuttsqdbpmobchat01 | Failover group endpoint (automatically routes to primary) |
Direct Server Connections:
| Server Name | Region | Purpose |
|---|---|---|
cuttasqlpmobchat01.database.windows.net | East US 2 | Direct connection to East US 2 server |
cuctasqlpmobchat01.database.windows.net | Central US | Direct connection to Central US server |
Stage (STG)
Failover Group Connection (Recommended):
| Server Name | Database Name | Purpose |
|---|---|---|
cutsfgpmobchat01.database.windows.net | cutssqdbpmobchat01 | Failover group endpoint (automatically routes to primary) |
Direct Server Connections:
| Server Name | Region | Purpose |
|---|---|---|
cutsasqlpmobchat01.database.windows.net | East US 2 | Direct connection to East US 2 server |
cucsasqlpmobchat01.database.windows.net | Central US | Direct connection to Central US server |
Production (PRD)
Failover Group Connection (Recommended):
| Server Name | Database Name | Purpose |
|---|---|---|
cutpfgpmobchat01.database.windows.net | cutpsqdbpmobchat01 | Failover group endpoint (automatically routes to primary) |
Direct Server Connections:
| Server Name | Region | Purpose |
|---|---|---|
cutpasqlpmobchat01.database.windows.net | East US 2 | Direct connection to East US 2 server |
cucpasqlpmobchat01.database.windows.net | Central US | Direct connection to Central US server |
Note: Always use the failover group endpoint unless you have a specific reason to connect directly to a regional server.