# Frequently asked questions

## How is Pro billed?

Pro is **$79 per Azure DevOps organization per month**, billed through [codex-architecture.com](https://codex-architecture.com/pricing) via Stripe — not through Microsoft. Install the extension free from Marketplace, then subscribe with your organization ID.

## Is there a free trial?

Yes. New Pro subscriptions include a **14-day free trial**. Start checkout on the pricing page and complete Stripe signup.

## How do I find my Azure DevOps Organization ID?

Add a pipeline step: `echo Organization ID: $(System.CollectionId)` or open **Organization settings → Overview**. You need this GUID for Pro checkout.

## Does this replace Flyway or Liquibase?

No. SQL Pipeline Deploy is for teams with **hand-written release scripts** in git (`Release_*` folders, numbered `00_` scripts). It is not a migration framework with undo or schema diff.

## Does this work on Linux agents?

The bundled runner targets **Windows agents** today. Use a Windows pool or a self-hosted Windows agent for the database deploy job.

## What happens if a script fails?

The pipeline **fails fast** by default. The failed script's transaction is rolled back. Enable **Continue on error** only when you intentionally want remaining scripts to run.

## How does the deployment ledger work?

On first run, scripts are registered in `DeploymentScripts`. On later runs, scripts marked executed are skipped. Renaming a script registers it as a new script.

## Can I parameterize scripts per environment?

Yes. Use **SQLCMD variables** — `$(Environment)` in your `.sql` files and pass JSON or `name=value` pairs in the task input.

## Can I use an Azure service connection instead of a connection string?

Yes. Provide **SQL Server**, **database**, **username**, and **password** inputs (password as a secret variable). Connection string is optional when discrete SQL inputs are set.

## Where is my data sent?

The task runs on your agent and connects directly to **your** SQL Server. License checks call `codex-architecture.com/api/license` with your organization ID only. See the [privacy policy](https://codex-architecture.com/privacy).

## How do I get support?

- **Free:** Marketplace Q&A and [support@codex-architecture.com](mailto:support@codex-architecture.com)
- **Pro:** Email support within 2 business days
- **Enterprise:** Priority support — [enterprise@codex-architecture.com](mailto:enterprise@codex-architecture.com)