Nesta página, confirma que a tarefa de migração migrou corretamente os dados da instância da base de dados de origem para a instância da base de dados de destino do AlloyDB.
No mínimo, verifique se a instância da base de dados e as respetivas tabelas existem na instância do AlloyDB. Também pode validar a quantidade de linhas ou o conteúdo exato das tabelas.
Clique na entrada da réplica de leitura da tarefa de migração.
Clique no ícone Ativar Cloud Shell apresentado na região superior direita da página.
Na linha de comandos do Cloud Shell, prima Enter.
Opcional: se for apresentada uma caixa de diálogo Autorizar Cloud Shell, clique em Autorizar.
No comando Introduza a palavra-passe, introduza a palavra-passe que forneceu ou que o serviço de migração de bases de dados gerou para si em Defina e crie a instância do AlloyDB de destino.
Execute comandos SQL para validar a migração. Por exemplo:
No comando postgres, introduza \list para listar as bases de dados e verifique se vê a instância da base de dados de origem.
No comando postgres, introduza \connect SOURCE_DB_NAME e introduza a palavra-passe quando lhe for pedido para se ligar à instância da base de dados e ver as tabelas associadas à instância. O nome do comando muda de postgres para SOURCE_DB_NAME.
No comando SOURCE_DB_NAME, introduza \dt para ver as tabelas desta instância.
No comando SOURCE_DB_NAME, introduza GRANT alloydbexternalsync to USER; porque quer conceder a este utilizador autorização para aceder aos dados nas tabelas desta instância. Além disso, substitua USER pelo nome do utilizador que usou para estabelecer ligação à instância da base de dados de destino.
No comando SOURCE_DB_NAME, introduza SELECT * from TABLE_NAME; para ver as informações replicadas de uma tabela na instância da base de dados de origem.
Confirme que vê as informações corretas na tabela.
Se tudo o que verificar estiver como esperado, significa que 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-08-21 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."]]
