Membuat dan mengonfigurasi instance tujuan Cloud SQL untuk SQL Server
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Untuk migrasi SQL Server homogen ke Cloud SQL,
Database Migration Service mengharuskan Anda membuat dan mengonfigurasi
instance tujuan Cloud SQL terlebih dahulu. Lakukan langkah-langkah berikut:
Buat instance tujuan. Pastikan Anda menggunakan resource komputasi dan memori yang memadai untuk memenuhi kebutuhan migrasi dan mengikuti persyaratan yang tercantum dalam
batasan yang diketahui.
Buat dan konfigurasikan pengguna migrasi khusus di instance Cloud SQL tujuan Anda. Pengguna ini diperlukan agar Database Migration Service berhasil
terhubung ke instance tujuan dan memantau data Anda. Anda harus memberikan
nama pengguna dan sandi untuk akun ini di tahap berikutnya, saat
membuat profil koneksi tujuan.
Buat akun pengguna database di instance Cloud SQL untuk SQL Server tujuan Anda. Lihat
Membuat dan mengelola pengguna dalam dokumentasi Cloud SQL.
Tetapkan hak istimewa berikut ke akun pengguna:
Untuk SQL Server 2019: VIEW ANY DEFINITION dan VIEW SERVER STATE
Untuk versi yang lebih baru: VIEW ANY DEFINITION dan VIEW SERVER PERFORMANCE STATE
Untuk mengetahui informasi tentang cara menetapkan hak istimewa ke akun pengguna, lihat
Mengubah izin untuk pengguna dalam dokumentasi Cloud SQL.
Berikan izin Cloud Storage ke akun layanan yang terkait dengan instance tujuan Anda. Akun ini dibuat setelah Anda membuat
instance tujuan.
Periksa alamat email yang terkait dengan akun layanan ini di
halaman detail instance Cloud SQL. Lihat
Melihat informasi instance dalam dokumentasi Cloud SQL.
Tambahkan izin storage.objects.get dan storage.objects.list ke akun layanan. Untuk mengetahui informasi tentang cara mengelola akses dengan Identity and Access Management, lihat
Mengelola akses ke project, folder, dan organisasi dalam dokumentasi IAM.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-05 UTC."],[[["\u003cp\u003eDatabase Migration Service requires a pre-configured Cloud SQL destination instance for homogeneous SQL Server migrations.\u003c/p\u003e\n"],["\u003cp\u003eYou must create a dedicated migration user within the destination Cloud SQL instance with specific privileges: \u003ccode\u003eVIEW ANY DEFINITION\u003c/code\u003e and \u003ccode\u003eVIEW SERVER STATE\u003c/code\u003e for SQL Server 2019, or \u003ccode\u003eVIEW ANY DEFINITION\u003c/code\u003e and \u003ccode\u003eVIEW SERVER PERFORMANCE STATE\u003c/code\u003e for later versions.\u003c/p\u003e\n"],["\u003cp\u003eGrant the service account associated with your destination instance \u003ccode\u003estorage.objects.get\u003c/code\u003e, and \u003ccode\u003estorage.objects.list\u003c/code\u003e permissions.\u003c/p\u003e\n"],["\u003cp\u003eThe destination instance must be configured with sufficient compute and memory resources to meet migration demands, while also following the requirements listed in the known limitations.\u003c/p\u003e\n"]]],[],null,["# Create and configure the Cloud SQL for SQL Server destination instance\n\nFor homogeneous SQL Server migrations to Cloud SQL,\nDatabase Migration Service requires that you first create and configure your\nCloud SQL destination instance. Perform the following steps:\n\n1. [Create your destination instance](/sql/docs/sqlserver/create-instance). Make sure you use enough compute\n and memory resources to cover your migration needs and follow the requirements\n listed in\n [known limitations](/database-migration/docs/sqlserver/known-limitations).\n\n2. Create and configure a dedicated migration user in your destination\n Cloud SQL instance. This user is required for Database Migration Service to successfully\n connect to your destination instance and monitor your data. You need to provide\n the username and password for this account at a later stage, when you\n [create the destination connection profile](/database-migration/docs/sqlserver/create-destination-connection-profile).\n\n 1. Create the database user account in your destination Cloud SQL for SQL Server\n instance. See\n [Create and manage users](/sql/docs/sqlserver/create-manage-users) in the Cloud SQL documentation.\n\n 2. Assign the following privileges to the user account:\n\n - For SQL Server 2019: `VIEW ANY DEFINITION` and `VIEW SERVER STATE`\n - For later versions: `VIEW ANY DEFINITION` and `VIEW SERVER PERFORMANCE STATE`\n\n For information on how to assign privileges to user accounts, see\n [Changing permissions for users](/sql/docs/sqlserver/users#changing-permissions) in the Cloud SQL documentation.\n3. Grant the Cloud Storage permissions to the service account associated\n with your destination instance. This account is created after you create the\n destination instance.\n\n 1. Check the email address associated with this service account on the\n Cloud SQL instance detail page. See\n [View instance information](/sql/docs/sqlserver/instance-info#service_account) in the Cloud SQL documentation.\n\n 2. Add the `storage.objects.get`, and `storage.objects.list`\n permissions to the service account. For information on how to manage access\n with Identity and Access Management, see\n [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access)\n in the IAM documentation.\n\nWhat's next?\n------------\n\n- [Create a migration job](/database-migration/docs/sqlserver/create-migration-job)"]]
