hub Coordinated Release Control

Release & Database Control

Every database and where it physically lives — your PC, the consolidated central server, and each client site — with a GitHub-backed, data-preserving patch-release procedure across all of them.

arrow_back Site
Software Systems apps
3
Logical Databases database
3
DB Instances (locations) lan
10
Deployments rocket_launch
4
conveyor_belt

Coordinated patch-release procedure

1 code

GitHub

SQL project (.sqlproj/DACPAC) + app code, versioned by branch, commit & tag.

2 computer

Dev (My PC)

Build & test against the local dev copy on SQL Express.

3 dns

Coordinated master

Publish to the central server — the integrated source of truth.

4 inventory_2

Client release

Stage a per-client release version on central; pull client data to test.

5 verified_user

Client live

SqlPackage publish: schema + data fixes only — client data preserved.

undo

Reverse flow: pull a client's live data back to central (test snapshot) to reproduce issues before the next push.

Databases & where they live

Master on central · dev copy on your PC · data-preserving copies at clients
database

APWiseControl

SQL Server · APWise.Web · 2 location(s)

Coordinated: InitialControlSchema
Location Role Server / directory Version Data policy Status

My PC (Dev)

 DevCopy

HP11\SQLEXPRESS

C:\Program Files\Microsoft SQL Server\...\DATA

 InitialControlSchema Disposable dev copy InSync

Central — Coordinated

 Coordinated

sql-central.australiaeast.cloudapp.azure.com

F:\Data

 InitialControlSchema Source of truth InSync
database

APWiseSchools

SQL Server · APWiseSchools · 6 location(s)

Coordinated: v2.4.0 (coordinated)
Location Role Server / directory Version Data policy Status

My PC (Dev)

 DevCopy

HP11\SQLEXPRESS

C:\projects\APWiseSchools\db

 v2.4.1-dev Disposable dev copy Ahead

Central — Coordinated

 Coordinated

sql-central.australiaeast.cloudapp.azure.com

F:\Data

 v2.4.0 Source of truth InSync

Central — Loreto Release

Loreto College

 ClientRelease

sql-central.australiaeast.cloudapp.azure.com

F:\Data\ClientReleases

 v2.3.1 Mirror of client release Behind

Central — St Mary's Release

St Mary's College

 ClientRelease

sql-central.australiaeast.cloudapp.azure.com

F:\Data\ClientReleases

 v2.3.0 Mirror of client release Behind

Loreto College — Live

Loreto College

 ClientLive

loreto-sql (client site)

D:\SQLData

 v2.3.1 Preserve client data — schema + fixes only Live

St Mary's College — Live

St Mary's College

 ClientLive

stmarys-sql (client site)

D:\SQLData

 v2.3.0 Preserve client data — schema + fixes only Live
database

APXSchools

SQL Server · APXSchools · 2 location(s)

Coordinated: 20260615_AddWorkflowTemplate
Location Role Server / directory Version Data policy Status

My PC (Dev)

 DevCopy

HP11\SQLEXPRESS

C:\projects\APXSchools\db

 20260615_AddWorkflowTemplate Disposable dev copy InSync

Central — Coordinated

 Coordinated

sql-central.australiaeast.cloudapp.azure.com

F:\Data

 20260615_AddWorkflowTemplate Source of truth InSync

Deployment map — where, when, by whom, which version

Site / client Flow Method / data GitHub From → To By / when Status

St Mary's College

Production

 northPush

Schema migration + data fix

Preserve client data

release/2.4 @f7e9a02

v2.4.0-rc1

sql-central.australiaeast.cloudapp.azure.com

sql-central: APWiseSchools (coordinated)

arrow_downwardstmarys-sql: APWiseSchools

Adam (ReleaseManager)

2026-06-19 03:00

 Pending

Loreto College

Staging

 southPull

Client data pull (test)

Test snapshot to central

release/2.4 @f7e9a02

v2.4.0-rc1

loreto-sql

loreto-sql: APWiseSchools (live)

arrow_downwardsql-central: APWiseSchools_Loreto_Test

DataAgent-01

2026-06-18 22:00

 Completed

apwise.com

Production

 northPush

Software publish (IIS)

Full replace

main @a1b2c3d

v1.0.0

HP11\SQLEXPRESS

C:\projects\APWise.OnMicrosoft\publish\APWise.Web

arrow_downwardC:\inetpub\sites\apwise.com

Adam (ReleaseManager)

2026-06-18 08:30

 Completed

Loreto College

Production

 northPush

Schema migration + data fix

Preserve client data

main @9c4d11a

v2.3.1

sql-central.australiaeast.cloudapp.azure.com

sql-central: APWiseSchools (coordinated)

arrow_downwardloreto-sql: APWiseSchools

Adam (ReleaseManager)

2026-06-01 11:00

 Completed
edit_note Register entries (release / deployment) — optional admin tools

Register a release

Register a deployment (push or pull)

Releases

Release System App / DB GitHub Target Status
REL-2026-008 APWiseSchools v2.3.1
20260601_Patch_AttendanceFix		 main @9c4d11a
v2.3.1		 Loreto College Completed
REL-2026-010 APWiseSchools v2.4.0
20260619_CoordinatedSchema		 release/2.4 @f7e9a02
v2.4.0-rc1		 sql-central (coordinated master) In Progress
REL-2026-001 APWise.Web v1.0.0
InitialControlSchema		 main @a1b2c3d
v1.0.0		 apwise.com Completed

Recent agent activity

Agent Event Release Site When
DeployAgent-01 HealthCheck — IIS worker healthy after apwise.com deployment. REL-2026-001 apwise.com 2026-07-20 21:37
DeployAgent-01 PatchPush — Applied attendance data-fix patch to Loreto (client data preserved). REL-2026-008 Loreto College 2026-07-20 21:22
DataAgent-01 DataPull — Pulled Loreto live data to central for v2.4 testing. REL-2026-010 Loreto College 2026-07-20 21:02
An unhandled error has occurred. Reload X

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.