Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What are two prerequisites for setting up and automating a Database Migration Service task to move data from an on-premises PostgreSQL instance to Cloud SQL?
A
Drop or disable all users except database administration users.
B
Disable all foreign key constraints on the source PostgreSQL database.
C
Ensure that all PostgreSQL tables have a primary key.
D
Shut down the database before the Data Migration Service task is started.
E
Ensure that pglogical is installed on the source PostgreSQL database.
