> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bytebase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Batch Change

<Card title="Tutorial: Batch Change with Database Group" icon="graduation-cap" href="/tutorials/batch-change-with-database-group" horizontal />

Bytebase allows you to change a collection of databases in a single workflow. These databases usually have a homogenous structure while belonging to different development environments, geographic locations, SaaS tenants, data centers or data partitions.

## Change databases from multiple environments

A development pipeline usually consists of multiple environments.
Each environment has its isolated database to store the respective data. A schema change will be propagated from each database following the development pipeline. You may have multiple databases in one stage as well.

In Bytebase, you can select multiple databases from different environments to apply the database change.

<img src="https://mintcdn.com/dbx/VfAunp5k2-AsJzmC/content/docs/change-database/batch-change/bb-db-edit-schema.webp?fit=max&auto=format&n=VfAunp5k2-AsJzmC&q=85&s=1eb119283d2be4b468950f8335a63035" alt="bb-db-edit-schema" width="2200" height="716" data-path="content/docs/change-database/batch-change/bb-db-edit-schema.webp" />

Then Bytebase will then create an issue to track the multi-database changes. You may deploy changes one database after another or batch deploy databases at the same stage.

## Database group

Database groups allow you to manage and batch change multiple databases together. This is particularly useful for SaaS multi-tenant architectures, geographic deployments, or database partitioning scenarios.

<Card title="Database Group Configuration" icon="layer-group" href="/administration/database-group">
  Learn how to create and manage database groups
</Card>

### Batch change databases in a group

1. Within the project, click **Database > Groups** on the left-side bar. Click **Edit Schema**, choose **Database Group**, select the database group you'll operate and click **Next**.

   <img src="https://mintcdn.com/dbx/VfAunp5k2-AsJzmC/content/docs/change-database/batch-change/bb-db-group-edit.webp?fit=max&auto=format&n=VfAunp5k2-AsJzmC&q=85&s=ca2b106f010ef5e7d6672244d40b6cef" alt="bb-db-group-edit" width="2828" height="1078" data-path="content/docs/change-database/batch-change/bb-db-group-edit.webp" />

2. An issue with the selected databases will be previewed. Add the SQL in the text field and click **Create**. The issue is created and waiting for approval.

   <img src="https://mintcdn.com/dbx/VfAunp5k2-AsJzmC/content/docs/change-database/batch-change/bb-issue-batch-created.webp?fit=max&auto=format&n=VfAunp5k2-AsJzmC&q=85&s=4b77244cf154962c43c4de6bb572f2c2" alt="bb-issue-batch-created" width="2426" height="1480" data-path="content/docs/change-database/batch-change/bb-issue-batch-created.webp" />
