Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud

<!DOCTYPE html> <html lang="en" class="sub-site-nav alicloud-header alicloud-footer"> <head> <meta charset="UTF-8"> <title>Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud - Alibaba Cloud Community</title> <link rel="shortcut icon" href="https://img.alicdn.com/tfs/TB1ugg7M9zqK1RjSZPxXXc4tVXa-32-32.png" /> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="keywords" content="Python,Database,Best practices,Cloud migration,Database Backup,database migration,Tutorials,ApsaraDB RDS for SQL Server,SQL Server 2017" /> <meta name="description" content="This article uses SQL Server 2017 as an example to illustrate the configuration steps for the entire migration process."> <meta name="csrf-param" content="yunqi_csrf"/> <meta name="csrf-token" content="RU7F3BKH72"/> <meta name="data-spm" content="a2c65"> <meta name="aplus-rhost-v" content="sg.mmstat.com"> <meta name="aplus-rhost-g" content="sg.mmstat.com"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/??alicloud-components/alicloud-ui3/0.0.7/acUI.css,alicloud-components/acApp/0.0.3/app.css,alicloud-components/i18n/0.0.29/css/en-us/index.css,alicloud-components/iconfont/0.0.7/product-icon.css"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/css/detail.css"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/css/nav.css"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/fonts/iconfont.css"> <link rel="stylesheet" type="text/css" href="https://g.alicdn.com/ali-mod/b-alicloud-v3-bottom/0.0.19/index.css"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/fonts/iconfont.css"> <meta property="og:url" content="https://www.alibabacloud.com/blog/best-practices-for-migrating-sql-server-instance-level-databases-to-the-cloud_601726"> <meta property="og:site_name" content="Alibaba Cloud Community"> <meta property="og:title" content="Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud"> <meta property="og:description" content="This article uses SQL Server 2017 as an example to illustrate the configuration steps for the entire migration process."> <meta property="og:image" content="https://yqintl.alicdn.com/a282b512a7b16e2e7dcfdb3e92c85038274e48c4.png"> <meta property="og:image:type" content="image/png"> <meta property="twitter:creator" content="Alibaba Cloud Community"> <meta property="twitter:card" content="summary_large_image"> <meta property="twitter:title" content="Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud"> <meta property="twitter:description" content="This article uses SQL Server 2017 as an example to illustrate the configuration steps for the entire migration process."> <meta property="twitter:image:src" content="https://yqintl.alicdn.com/a282b512a7b16e2e7dcfdb3e92c85038274e48c4.png"> <script src="//g.alicdn.com/??alicloud-components/kloud/0.0.31/vendor/requirejs/require.js,alicloud-components/kloud/0.0.1/scripts/vendor/jquery/jquery.min.js,alicloud-components/common/scripts/layout.js,alicloud-components/alicloud-ui3/0.0.7/acUI.js"></script> <script src="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/js/layout.js"></script> </head> <body data-spm="11461447"><script type="text/javascript"> (function (d) { var t=d.createElement("script");t.type="text/javascript";t.async=true;t.id="tb-beacon-aplus"; t.setAttribute("exparams","category=&userid=&aplus&yunid=&yunpk=&channel=&cps="); t.src="//g.alicdn.com/alilog/mlog/aplus_v2.js"; d.getElementsByTagName("head")[0].appendChild(t); })(document); </script> <div class="blog-nav"> <div class="container"> <div class="row"> <h1> Community </h1> <main class="blog-nav-center"> <a href="https://www.alibabacloud.com/blog/" class="bg"> Blog </a> <a href="https://resource.alibabacloud.com/event/index"> Events </a> <a href="https://resource.alibabacloud.com/webinar/index.htm"> Webinars </a> <a href="https://community.alibabacloud.com/tags/type_blog-tagid_28404/"> Tutorials </a> <a href="https://www.alibabacloud.com/forum"> Forum </a> </main> <ul class="blog-nav-right"> <li class="search"><input type="text" placeholder="Search" id="search"> <i class="search-btn k-iconfont icon-sousuo1"></i> <div class="close-box"><img data-original="https://img.alicdn.com/tfs/TB1BIBBsbPpK1RjSZFFXXa5PpXa-24-24.png" data-toggle="lazy-loading" class="off" /><img data-original="https://img.alicdn.com/tfs/TB1vrJ2shnaK1RjSZFBXXcW7VXa-24-24.png" data-toggle="lazy-loading" class="on" /></div> </li> </ul> <div class="blog-nav-right-m"> <i class="k-iconfont icon-sousuo1 show-search"></i> <i class="show-more"></i> </div> </div> <div class="blog-nav-main-m"> <ol> <li><a href="https://community.alibabacloud.com">Blog</a></li> <li> <a href="https://resource.alibabacloud.com/event/index"> Events </a> </li> <li> <a href="https://resource.alibabacloud.com/webinar/index.htm"> Webinars </a> </li> <li> <a href="https://www.alibabacloud.com/getting-started/projects"> Tutorials </a> </li> <li> <a href="https://www.alibabacloud.com/forum"> Forum </a> </li> </ol> <div class="btn-box"> <a href="https://account.alibabacloud.com/register/register.htm?from_type=yqclub&oauth_callback=https%3A%2F%2Fwww.alibabacloud.com%2Fblog%2Fbest-practices-for-migrating-sql-server-instance-level-databases-to-the-cloud_601726%3Fdo%3Dlogin" class="free" style="display: block;"> Create Account </a> <a href="https://account.alibabacloud.com/login/login.htm?from_type=yqclub&oauth_callback=https%3A%2F%2Fwww.alibabacloud.com%2Fblog%2Fbest-practices-for-migrating-sql-server-instance-level-databases-to-the-cloud_601726%3Fdo%3Dlogin" class="login" style="display: block;"> Log In </a> </div> </div> <div class="container blog-nav-search-m"> <div class="blog-nav-search-m-top"> <input type="text" placeholder="Search" class="int-search"> <button> <i class="k-iconfont icon-sousuo1"></i> </button> <span> × </span> </div> </div> </div> </div> <div class="wrap container"> <div class="wrap-top"> <a href="https://community.alibabacloud.com">Community</a> <i class="icon icon-more"></i> <a href="https://www.alibabacloud.com/blog/">Blog</a> <i class="icon icon-more"></i> Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud </div> <div class="wrap-main"> <div class="col-md-8"> <div class="wrap-main-left"> <h1> Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud </h1> <aside> <main> <a href="https://community.alibabacloud.com/users/5190830865598772">ApsaraDB</a> <span>November 5, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt=""> 490 </span> <a href="#comment"> <i class="icon icon-pinglun"></i><b class="comments-num">0</b> </a> </main> <div> </div> </aside> <div class="wrap-main-left-abstract"> This article uses SQL Server 2017 as an example to illustrate the configuration steps for the entire migration process. </div> <div class="wrap-main-left-article markdown-body"> <p><em>By Yuanyi</em></p> <p><a href="https://www.alibabacloud.com/product/apsaradb-for-rds-sql-server?spm=a3c0i.23458820.6791778070.126.69447d3fMhXp2X" target="_blank">ApsaraDB RDS for SQL Server</a> offers an instance-level database migration solution, supporting the migration of <strong>data of multiple databases or all databases</strong> from a self-managed SQL Server instance to an ApsaraDB RDS for SQL Server instance. You just need to back up all databases of the self-managed SQL Server, upload the full backup files to the same folder in an Object Storage Service (OSS) Bucket, and then execute the required migration script. </p> <p>The backup migration method supports various versions of SQL Server. This article uses SQL Server 2017 as an example to illustrate the configuration steps for the entire migration process. For detailed feature descriptions, please refer to the official documentation: <a href="https://www.alibabacloud.com/help/rds/apsaradb-rds-for-sql-server/migrate-data-from-a-self-managed-sql-server-instance-to-an-apsaradb-rds-for-sql-server-instance" target="_blank">https://www.alibabacloud.com/help/rds/apsaradb-rds-for-sql-server/migrate-data-from-a-self-managed-sql-server-instance-to-an-apsaradb-rds-for-sql-server-instance</a></p> <h2>Prerequisites</h2> <p>• The RDS instance has sufficient storage space. </p> <p>• The OSS service is activated. </p> <p>• If you use a RAM user, the following requirements need to be met:</p> <p>o The RAM user has the AliyunOSSFullAccess and AliyunRDSFullAccess permissions. For information on granting permissions to a RAM user, please refer to <a href="https://www.alibabacloud.com/help/en/ram/use-cases/use-ram-to-manage-oss-permissions#task-ohn-ypx-ydb" target="_blank">Use RAM to manage OSS permissions</a> and <a href="https://www.alibabacloud.com/help/en/ram/use-cases/use-ram-to-manage-apsaradb-rds-permissions#task-zqh-gqx-ydb" target="_blank">Use RAM to manage ApsaraDB RDS permissions</a>. </p> <p>o The Alibaba Cloud account (primary account) has authorized the service account of ApsaraDB RDS to access your OSS bucket. </p> <p>• Only full backup files can be used for the data migration.</p> <h2>Preparation</h2> <p>1. Install Python 2.7.18 or Python 3.11.7.</p> <p>Python installation package: <a href="https://alicloud-common.oss-ap-southeast-1.aliyuncs.com/2024/blog/python-3.11.7-amd64.zip" target="_blank">📎python-3.11.7-amd64.zip</a></p> <p>2. Verify whether Python is installed and check the version. </p> <p>o On the Windows operating system, run c:Python27python.exe -V to check the Python version. If the output is Python 2.7.18, it indicates a successful installation. If the system prompts that the preceding command is not an internal or external command, add the Python installation path and the pip command directory to the Path environment variable.</p> <p><img src="https://yqintl.alicdn.com/212555c5f49069a7da4faed5cc0d714535f1ff01.png" alt="1" title="1"><br><img src="https://yqintl.alicdn.com/cb160a96f91bd5d9874b31713d354ac1a3ec62ae.png" alt="2" title="2"></p> <p>The link for installing pip: <a href="https://www.jianshu.com/p/2559b55a9309" target="_blank">https://www.jianshu.com/p/2559b55a9309</a></p> <h2>Install the SDK dependency package:</h2> <p>• Use the source code.</p> <pre><code># Clone OpenAPI git clone https://github.com/aliyun/aliyun-openapi-python-sdk.git # Install the core library of Alibaba Cloud SDK cd aliyun-python-sdk-core python setup.py install # Install the ApsaraDB RDS SDK cd aliyun-python-sdk-rds python setup.py install # Clone the Alibaba Cloud OSS SDK git clone https://github.com/aliyun/aliyun-oss-python-sdk.git cd aliyun-oss-python-sdk # Install the Alibaba Cloud OSS2 SDK python setup.py install</code></pre> <p>The source code package is as follows:</p> <p><a href="https://alicloud-common.oss-ap-southeast-1.aliyuncs.com/2024/blog/aliyun-openapi-python-sdk-master.zip" target="_blank">📎aliyun-openapi-python-sdk-master.zip</a></p> <p><a href="https://alicloud-common.oss-ap-southeast-1.aliyuncs.com/2024/blog/aliyun-oss-python-sdk-master.zip" target="_blank">📎aliyun-oss-python-sdk-master.zip</a></p> <h2>Step 1: Back up All Databases of the Self-managed SQL Server</h2> <p><strong>Note:</strong></p> <p>• For data consistency purposes, we recommend that you do not write data to these databases during the full backup. Please schedule this task in advance to avoid impacting your business operations. </p> <p>• If you do not use the backup script to perform the backup, the backup file must be named in the format of database name_backup type_backup time.bak, for example, Testdb_FULL_20180518153544.bak. Otherwise, it will result in a backup error. </p> <p>1. Download the backup script file. </p> <p><a href="https://alicloud-common.oss-ap-southeast-1.aliyuncs.com/2024/blog/RDSBackupSpecifiedDatabasesToLocal.sql" target="_blank">📎RDSBackupSpecifiedDatabasesToLocal.sql</a></p> <p>2. Double-click the backup script file and open it by using Microsoft SQL Server Management Studio (SSMS).</p> <p>3. Configure the following parameters according to your business needs.</p> <table> <tr> <td><strong>Configuration Item</strong></td> <td><strong>Description</strong></td> </tr> <tr> <td>@backup_databases_list</td> <td>The name of the database that you want to back up. If you specify multiple databases, separate the names of the databases with semicolons (;) or commas (,).</td> </tr> <tr> <td>@backup_type</td> <td>The backup type. Valid values:<br><br>● FULL: full backup.<br>● DIFF: differential backup.<br>● LOG: log backup.</td> </tr> <tr> <td>@backup_folder</td> <td>The local directory that is used to store the backup files. If the specified directory does not exist, the system automatically creates one.</td> </tr> <tr> <td>@is_run</td> <td>Specify whether to perform a backup. Valid values:<br><br>● 1: performs a backup.<br>● 0: only performs a check, not the backup.</td> </tr> </table> <p>In this example, set the value to FULL. </p> <p><img src="https://yqintl.alicdn.com/ddc13afc75d533578891bd240e69214ffc7fefa6.png" alt="3" title="3"></p> <p>4. Run the backup script, and databases will be backed up to the specified directory. </p> <p><img src="https://yqintl.alicdn.com/a4b90bad238dc20c02fde7ed044cf79e5b0bc504.png" alt="4" title="4"></p> <h2>Step 2: Upload the Backup File to the OSS Bucket</h2> <p>The link for the OSS upload tool: <a href="https://gosspublic.alicdn.com/ossutil/1.7.19/ossutil-v1.7.19-windows-amd64.zip" target="_blank">https://gosspublic.alicdn.com/ossutil/1.7.19/ossutil-v1.7.19-windows-amd64.zip</a></p> <p><img src="https://img.alicdn.com/imgextra/i3/O1CN01I5eBvC28wDwqrN5Nb_!!6000000007996-0-tps-2529-1272.jpg" alt="5" title="5"></p> <h2>Step 3: Run the Migration Script to Migrate the Database to RDS</h2> <p>Download the SQL Server migration script.</p> <p><a href="https://alicloud-common.oss-ap-southeast-1.aliyuncs.com/2024/blog/RDSSQLCreateMigrateTasksBatchly.py" target="_blank">📎RDSSQLCreateMigrateTasksBatchly.py</a></p> <p>After decompressing, run the following command to view the parameter information needed by this script.</p> <pre><code>python ./RDSSQLCreateMigrateTasksBatchly.py -h</code></pre> <p>The result is as follows:</p> <p><img src="https://yqintl.alicdn.com/dabbed0ecf93d3c240d0850100df5408437577aa.png" alt="6" title="6"></p> <table> <thead><tr> <th>Parameter</th> <th>Description</th> </tr></thead> <tbody> <tr> <td>access_key_id</td> <td>The AccessKey ID of the Alibaba Cloud account to which the target RDS instance belongs.</td> </tr> <tr> <td>access_key_secret</td> <td>The AccessKey Secret of the Alibaba Cloud account to which the target RDS instance belongs.</td> </tr> <tr> <td>rds_instance_id</td> <td>The ID of the target RDS instance.</td> </tr> <tr> <td>oss_endpoint</td> <td>The Endpoint address of the OSS bucket that stores the backup files. For information on obtaining the Endpoint address, please refer to the <a href="https://www.alibabacloud.com/help/en/oss/user-guide/bucket-overview" target="_blank">Bucket overview</a>.</td> </tr> <tr> <td>oss_bucket</td> <td>The name of the OSS bucket that stores the backup files.</td> </tr> <tr> <td>directory</td> <td>The directory in the OSS bucket that stores the backup files. If the backup files are stored in the root directory, please enter a forward slash (/).</td> </tr> </tbody> </table> <pre><code>RDSSQLCreateMigrateTasksBatchly.py -k <access_key_id> -s <access_key_secret> -i <rds_instance_id> -e <oss_endpoint> -b <oss_bucket> -d <directory></code></pre> <p>Example:</p> <p><img src="https://yqintl.alicdn.com/bb30c020b1cf54af432ae0b49121162a71337c3f.png" alt="7" title="7"></p> <p>Run the migration script to complete the migration task. </p> <p>View the progress of the migration task in the RDS console. </p> <p>Access the RDS Instances page, select the region in which the RDS instance resides in the top navigation bar, and then click the target instance ID. </p> <p><img src="https://img.alicdn.com/imgextra/i3/O1CN01NGDxLe21Sj878UopN_!!6000000006984-0-tps-2545-1279.jpg" alt="8" title="8"><br><img src="https://img.alicdn.com/imgextra/i3/O1CN01Ry2teT1tWpkt1DlEi_!!6000000005910-0-tps-2551-1278.jpg" alt="9" title="9"></p> <h2>Compare the Migrated Data:</h2> <p><img src="https://yqintl.alicdn.com/3e5cf5f7bee3bb9cfaf5cd0689085f491ade5bcf.png" alt="10" title="10"><br><img src="https://yqintl.alicdn.com/93e9c5161b57f78904fdd5ff9a80270192746832.png" alt="11" title="11"></p> </div> <div class="wrap-main-left-bar"> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_14/">Python</a></span> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_2159/">Database</a></span> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_24683/">Best practices</a></span> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_25421/">Cloud migration</a></span> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_27265/">Database Backup</a></span> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_28038/">database migration</a></span> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_28404/">Tutorials</a></span> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_28503/">ApsaraDB RDS for SQL Server</a></span> <span><a href="https://community.alibabacloud.com/tags/type_blog-tagid_38212/">SQL Server 2017</a></span> </div> <div class="wrap-main-left-action"> <main> <a href="#comment"> <i class="icon icon-pinglun"></i> 0 </a> <span class="action-zan" data-islogin="false" data-id="601726" data-already="false" rel="nofollow"> <i class="icon icon-zan"></i> <b>1</b> </span> <span class="action-love" data-islogin="false" data-id="601726" data-already="false" rel="nofollow"> <i class="icon icon-love"></i> <b>0</b> </span> </main> <div> <b>Share on</b> <a href="javascript:;" class="sharer" data-sharer="linkedin" data-url="" title="Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud"> <i class="icon icon-linkedin1"></i> </a> <a href="javascript:;" class="sharer" data-sharer="facebook" data-url="" title="Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud"> <i class="icon icon-lianshu1"></i> </a> <a href="javascript:;" class="sharer" data-sharer="twitter" data-url="" title="Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud"> <i class="icon icon-twitter1"></i> </a> </div> </div> <div class="wrap-main-left-read"> <main> <h2> Read previous post: </h2> <p> <a href="/blog/infographic-highlights-%7C-database-new-features-in-september-2024_601712"> [Infographic] Highlights | Database New Features in September 2024 </a> </p> </main> <main> <h2> Read next post: </h2> <p> <a href="/blog/data-encryption-without-business-changes-enough-with-this-tool_601730"> Data Encryption without Business Changes? Enough with this Tool </a> </p> </main> </div> <div class="wrap-main-right-user wrap-main-right-user-mobile"> <dl> <dt> <a href="https://community.alibabacloud.com/users/5190830865598772"> <img src="https://yqintl.alicdn.com/f11fe492c9b2d4c8b997228dc25313d6.jpeg?x-oss-process=image/resize,m_fixed,h_64,w_64" alt=""> </a> </dt> <dd> <h1> <a href="https://community.alibabacloud.com/users/5190830865598772"> ApsaraDB </a> </h1> <p> 445 posts | 94 followers </p> <a href="#" class="follow-btn" data-islogin="false" data-uid="5190830865598772" data-isfollowed="false" id="follow-btn" rel="nofollow">Follow</a> </dd> </dl> </div> <h3> You may also like </h3> <ul class="wrap-main-left-list"> <li> <span></span> <a href="/blog/sql-server-best-practices-migrating-multiple-instance-level-databases-to-apsaradb-rds-for-sql-server_594483"> SQL Server Best Practices: Migrating Multiple Instance-level Databases to ApsaraDB RDS for SQL Server </a> <p> Cherish Wang - February 20, 2019 </p> </li> <li> <span></span> <a href="/blog/how-to-migrate-sql-server-to-new-server_596477"> How to Migrate Sql Server to New Server? </a> <p> Alibaba Clouder - August 6, 2020 </p> </li> <li> <span></span> <a href="/blog/blogs-of-the-week-ep--14-2024_601744"> Blogs of the Week – Ep. 14, 2024 </a> <p> Alibaba Cloud Community - November 8, 2024 </p> </li> <li> <span></span> <a href="/blog/a-guide-to-migrating-to-an-sql-server-online_595890"> A Guide to Migrating to an SQL Server Online </a> <p> Alibaba Clouder - February 25, 2020 </p> </li> <li> <span></span> <a href="/blog/sql-server-best-practices-migrating-to-apsaradb-rds-for-sql-server-using-sdk_594482"> SQL Server Best Practices: Migrating to ApsaraDB RDS for SQL Server Using SDK </a> <p> Cherish Wang - February 20, 2019 </p> </li> <li> <span></span> <a href="/blog/rds-best-practices-%E2%80%94-fast-and-stable-migration-to-rds_281187"> RDS Best Practices — Fast and Stable Migration to RDS </a> <p> Alibaba Clouder - December 13, 2017 </p> </li> </ul> <h3 id="comment"> Comments </h3> <div class="wrap-main-left-comments"> <span class="hidden" id="pageCount" data-pageCount="0"></span> </div> <div class="page parent-page"></div> <div class="write-comments"> <textarea name="" id="" cols="30" rows="10" placeholder="Write your comment..."></textarea> <div class="write-comments-btn"> <button class="btn btn-primary add-parent-comment">Post</button> </div> </div> </div> <div class="wrap-main-iconBox"> <a href="javascript:;" class="bg sharer" data-sharer="linkedin" data-url="https://www.alibabacloud.com/blog/best-practices-for-migrating-sql-server-instance-level-databases-to-the-cloud_601726" title="Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud"> <i class="icon icon-linkedin1"></i> </a> <a href="javascript:;" class="sharer" data-sharer="facebook" data-url="https://www.alibabacloud.com/blog/best-practices-for-migrating-sql-server-instance-level-databases-to-the-cloud_601726" title="Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud"> <i class="icon icon-lianshu1"></i> </a> <a href="javascript:;" class="sharer" data-sharer="twitter" data-url="https://www.alibabacloud.com/blog/best-practices-for-migrating-sql-server-instance-level-databases-to-the-cloud_601726" title="Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud"> <i class="icon icon-twitter1"></i> </a> </div> </div> <div class="wrap-main-right col-md-4"> <div class="wrap-main-right-user wrap-main-right-user-pc"> <dl> <dt> <a href="https://community.alibabacloud.com/users/5190830865598772"> <img src="https://yqintl.alicdn.com/f11fe492c9b2d4c8b997228dc25313d6.jpeg?x-oss-process=image/resize,m_fixed,h_64,w_64" alt=""> </a> </dt> <dd> <h1> <a href="https://community.alibabacloud.com/users/5190830865598772"> ApsaraDB </a> </h1> <p> 445 posts | <span class="followers-num">94</span> followers </p> <a href="#" class="follow-btn" data-islogin="false" data-uid="5190830865598772" data-isfollowed="false" id="follow-btn" rel="nofollow">Follow</a> </dd> </dl> </div> <div class="wrap-main-right-box"> <h1> Related Products </h1> <ul> <li> <h2> <a href="https://community.alibabacloud.com/go/1/331"> <img src="https://yqintl.alicdn.com/img_742dc7c4dc900571949476dccdd88bd2.png" alt=""> Best Practices </a> </h2> <p> Follow our step-by-step best practices guides to build your own business case. </p> <a href="https://community.alibabacloud.com/go/1/331" class="btn btn-default"> Learn More </a> </li> <li> <h2> <a href="https://community.alibabacloud.com/go/1/321"> <img src="https://yqintl.alicdn.com/img_357c79c86098f3ef154114e736a826b4.png" alt=""> Database Migration Solution </a> </h2> <p> Migrating to fully managed cloud databases brings a host of benefits including scalability, reliability, and cost efficiency. </p> <a href="https://community.alibabacloud.com/go/1/321" class="btn btn-default"> Learn More </a> </li> <li> <h2> <a href="https://community.alibabacloud.com/go/1/388"> <img src="https://yqintl.alicdn.com/img_ed8cac63cfda4db70312cabe9f3d3c41.png" alt=""> Oracle Database Migration Solution </a> </h2> <p> Migrate your legacy Oracle databases to Alibaba Cloud to save on long-term costs and take advantage of improved scalability, reliability, robust security, high performance, and cloud-native features. </p> <a href="https://community.alibabacloud.com/go/1/388" class="btn btn-default"> Learn More </a> </li> <li> <h2> <a href="https://community.alibabacloud.com/go/1/348"> <img src="https://yqintl.alicdn.com/img_40006055dc1e0ef47579048c5f7dd6df.png" alt=""> ADAM(Advanced Database & Application Migration) </a> </h2> <p> An easy transformation for heterogeneous database. </p> <a href="https://community.alibabacloud.com/go/1/348" class="btn btn-default"> Learn More </a> </li> </ul> </div> <div class="wrap-main-right-list"> <div> <p> <b> More Posts </b> <span> by ApsaraDB </span> </p> <main> <span> <a href="https://community.alibabacloud.com/users/5190830865598772/article">See All</a> </span> <i class="icon icon-more"></i> </main> </div> <ul> <li> <a href="/blog/how-does-mysql-implement-concurrency-control-part-ii_601785">How Does MySQL Implement Concurrency Control? (Part II)</a> </li> <li> <a href="/blog/how-does-mysql-implement-concurrency-control-part-i_601784">How Does MySQL Implement Concurrency Control? (Part I)</a> </li> <li> <a href="/blog/sevenfold-performance-improvement-%7C-alibaba-cloud-analyticdb-spark-vectorization-capability-analysis_601761">Sevenfold Performance Improvement | Alibaba Cloud AnalyticDB Spark Vectorization Capability Analysis</a> </li> <li> <a href="/blog/implement-scheduled-elastic-scaling-of-serverless-apsaradb-rds-for-sql-server-by-calling-api_601756">Implement Scheduled Elastic Scaling of Serverless ApsaraDB RDS for SQL Server By Calling API</a> </li> <li> <a href="/blog/polardb-x-disaster-recovery-capabilities-cross-az-cross-region-and-cross-cloud_601754">PolarDB-X Disaster Recovery Capabilities: Cross-AZ, Cross-Region, and Cross-Cloud</a> </li> <li> <a href="/blog/polardb-x-tpc-h-column-oriented-storage-execution-plan_601742">PolarDB-X TPC-H Column-Oriented Storage Execution Plan</a> </li> <li> <a href="/blog/core-technology-of-polardb-x-storage-engine-%7C-lizard-b%2Btree-optimization_601740">Core Technology of PolarDB-X Storage Engine | Lizard B+tree Optimization</a> </li> <li> <a href="/blog/data-encryption-without-business-changes-enough-with-this-tool_601730">Data Encryption without Business Changes? Enough with this Tool</a> </li> <li> <a href="/blog/infographic-highlights-%7C-database-new-features-in-september-2024_601712">[Infographic] Highlights | Database New Features in September 2024</a> </li> </ul> </div> </div> </div> </div> <script type="text/javascript" nonce="F24ZZH6N54"> window.localconfigs = { 'aid': 601726 }; </script> <script type="text/javascript" nonce="F24ZZH6N54"> window.configs = { "csrf-param": "yunqi_csrf", "csrf-token": "RU7F3BKH72", "islogin": false, "registerurl": "https://account.alibabacloud.com/register/register.htm?from_type=yqclub&oauth_callback=https%3A%2F%2Fwww.alibabacloud.com%2Fblog%2Fbest-practices-for-migrating-sql-server-instance-level-databases-to-the-cloud_601726%3Fdo%3Dlogin", "loginurl": "https://account.alibabacloud.com/login/login.htm?from_type=yqclub&oauth_callback=https%3A%2F%2Fwww.alibabacloud.com%2Fblog%2Fbest-practices-for-migrating-sql-server-instance-level-databases-to-the-cloud_601726%3Fdo%3Dlogin", "isNeedNickname": false, "baseurl": "/blog" }; </script> <script src="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/js/detail.js"></script> <script src="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/js/nav.js"></script> <script type="text/javascript" nonce="F24ZZH6N54"> (function (i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function () { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m) })(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga'); ga('create', 'UA-86123020-1', 'auto'); ga('send', 'pageview'); </script> </body> </html>

CINXE.COM

Best Practices for Migrating SQL Server Instance-Level Databases to the Cloud - Alibaba Cloud Community