# Skip API data upgrade in cloud migration
When running the data upgrade during cloud migration, you can experience a long-running upgrade because of the API upgrade. To prevent this condition, you can skip the API data upgrade during cloud migration, and then run it after going live on the tenant. Skipping the API data upgrade is done on a per-company basis. The affected API entities aren't ready for use until you complete their data upgrades.
There are two ways to skip the API data upgrade during cloud migration. One way is to disable it as part of the on-premises upgrade process. The other way is to disable it using cloud migration management in the Business Central online environment.
## Skip from the online environment
Before you can do this task, you have to complete cloud migration setup and data replication.
1. Sign in to Business Central online<https://businesscentral.dynamics.com>.
1. Search for and open the Cloud Migration Management page.
1. Select the Manage API Upgrade action to open the API Upgrade Overview page.
1. To disable the API data upgrade for a company, do the following steps:
 1. On the API Upgrade Overview page, select the company in the Company Name column.
  The API Data Upgrade List opens in a new browser tab.
 1. On the API Data Upgrade List page, select Disable API Data Upgrades > OK.
  You can close the API Data Upgrade List tab after you make the selection.
1. Repeat the previous step for each company you want to disable the API data upgrade.
The API Upgrade Overview page doesn't show the changes until it's refreshed. Press F5 to refresh it.
## Skip from on-premises upgrade
You can use the following SQL query to skip upgrade for a single company. Replace SetCompanyName with the company name. Run the query only if the disable tag doesn't already exist for that company:
```sql
DECLARE @UpgTag nvarchar(250);
SET @UpgTag = UPPER('MS-469217-DisableAPIDataUpgrade-20230411')

INSERT INTO [dbo].[Upgrade Tags$63ca2fa4-4f03-4f2b-a480-172fef340d3f] (Tag, [Tag Timestamp], [Skipped Upgrade], Company)
VALUES (
    UPPER(@UpgTag),
    '1753-01-01 00:00:00.000',
    1,
    UPPER('SetCompanyName')
);
```
You can use the following SQL query to skip upgrade for all companies:
```sql
DECLARE @UpgTag nvarchar(250);

SET @UpgTag = UPPER('MS-469217-DisableAPIDataUpgrade-20230411')

INSERT INTO [dbo].[Upgrade Tags$63ca2fa4-4f03-4f2b-a480-172fef340d3f] (Tag, [Tag Timestamp], [Skipped Upgrade], Company)
SELECT
    UPPER(@UpgTag),
    '1753-01-01 00:00:00.000',
    1,
    UPPER([Name])
FROM
    Company
WHERE
    UPPER([Name]) NOT IN (
        SELECT [Company]
        FROM [Upgrade Tags$63ca2fa4-4f03-4f2b-a480-172fef340d3f]
        WHERE Tag = UPPER(@UpgTag)
    )
```
## Completing API data upgrade after going live
When you're finished with the cloud migration, run the API data upgrade. See Run API data upgrade<migration-finish#API>.
## Next steps
Run data upgrade<migration-data-upgrade>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migration-skip-api-data-upgrade, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/administration/migration-skip-api-data-upgrade/
