Nesta página, você confirma que o job de migração migrou os dados da instância de banco de dados de origem para a instância de destino do AlloyDB corretamente.
No mínimo, verifique se a instância do banco de dados e as tabelas dela existem na
instância do AlloyDB. Também é possível verificar as contagens de linhas ou os conteúdos
exatos das tabelas.
Execute comandos SQL para verificar a migração. Por exemplo:
No prompt postgres, digite \list para listar os bancos de dados e verificar se você vê a instância de banco de dados de origem.
No prompt postgres, digite \connect SOURCE_DB_NAME e insira a senha quando solicitado para se conectar à instância do banco de dados e conferir as tabelas associadas a ela. O nome do prompt muda de postgres para SOURCE_DB_NAME.
No prompt SOURCE_DB_NAME, digite \dt para acessar as tabelas dessa instância.
No prompt SOURCE_DB_NAME, insira GRANT alloydbexternalsync to USER; porque você quer conceder a esse usuário permissão de acesso aos dados nas tabelas dessa instância. Além disso, substitua USER pelo nome do usuário usado para se conectar à instância do banco de dados de destino.
No prompt SOURCE_DB_NAME, digite SELECT * from TABLE_NAME; para ver as informações replicadas de uma tabela na instância de banco de dados de origem.
Verifique se as informações na tabela estão corretas.
Se tudo estiver como esperado, o Database Migration Service migrou os dados corretamente.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-09-05 UTC."],[[["\u003cp\u003eThis guide provides steps to verify that data has been correctly migrated from a source database instance to an AlloyDB database instance.\u003c/p\u003e\n"],["\u003cp\u003eThe minimum verification involves checking for the existence of the database instance and its tables within the AlloyDB instance.\u003c/p\u003e\n"],["\u003cp\u003eUsers can verify the migration by accessing the read replica of their migration job via the Google Cloud console and executing SQL commands in Cloud Shell.\u003c/p\u003e\n"],["\u003cp\u003eThe verification process includes listing databases, connecting to the source database, viewing its tables, granting access, and selecting data from a replicated table.\u003c/p\u003e\n"],["\u003cp\u003eSuccessful verification, evidenced by expected results, confirms that the Database Migration Service has accurately transferred the data.\u003c/p\u003e\n"]]],[],null,["# Verify a migration\n\n\u003cbr /\u003e\n\n[MySQL](/database-migration/docs/mysql/verify-migration \"View this page for the MySQL version of Database Migration Service.\") \\| [PostgreSQL](/database-migration/docs/postgres/verify-migration \"View this page for the PostgreSQL version of Database Migration Service.\") \\| PostgreSQL to AlloyDB\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\nVerifying a migration\n---------------------\n\nIn this page, you confirm that the migration job migrated data from your source database instance to the destination AlloyDB database instance correctly.\n\n\u003cbr /\u003e\n\nAt a minimum, verify that the database instance and its tables exist in the\nAlloyDB instance. You can also verify the tables' row counts or exact\ncontents.\n\n\nThe following steps show a minimal example:\n\n1. Go to the [AlloyDB clusters page](https://console.cloud.google.com/alloydb) in the Google Cloud console.\n2. Click the read replica entry of your migration job.\n3. Click the **Activate Cloud Shell** icon that appears in the upper-right region of the page.\n4. At the Cloud Shell prompt, press **Enter**.\n5. Optional: If an **Authorize Cloud Shell** dialog box appears, then click **Authorize**.\n6. At the **Enter password** prompt, enter the password that you either provided or that Database Migration Service generated for you in [Define and create the destination AlloyDB instance](/database-migration/docs/postgresql-to-alloydb/create-migration-job#dest).\n7. Run SQL commands to verify the migration. For example:\n 1. At the **postgres** prompt, enter `\\list` to list the databases and verify that you see your source database instance.\n 2. At the **postgres** prompt, enter `\\connect `\u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e, and enter the password when prompted, to connect to the database instance and see the tables associated with the instance. The name of the prompt changes from `postgres` to \u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e.\n 3. At the \u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e prompt, enter `\\dt` to see the tables of this instance.\n 4. At the \u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e prompt, enter `GRANT alloydbexternalsync to `\u003cvar translate=\"no\"\u003eUSER\u003c/var\u003e`;` because you want to give this user permission to access the data in the tables of this instance. Also, replace \u003cvar translate=\"no\"\u003eUSER\u003c/var\u003e with the name of the user you used to connect to the destination database instance.\n 5. At the \u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e prompt, enter `SELECT * from `\u003cvar translate=\"no\"\u003eTABLE_NAME\u003c/var\u003e`;` to see the information that's replicated from a table in your source database instance.\n 6. Verify that you see the correct information in the table.\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\nIf everything you check is as you expect, then Database Migration Service has migrated the data correctly."]]
