Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at:Home»AWS»How to Migrate SQL Server Database to Amazon RDS Instanace

    How to Migrate SQL Server Database to Amazon RDS Instanace

    By RahulFebruary 3, 20142 Mins Read

    Amazon SQL Server RDS Instance doesn’t support to restore data from .bak files. So using this article I am writing to how to migrate your SQL server database to Amazon RDS instanace with easy steps. If you looks on AWS migration steps its too complicated, But windows Azure migration wizard tools provide an easier way to migrate data between local SQL Server to AWS RDS instance.

    Advertisement

    Step 1. Download SQLAzureMW Tool

    1.1. At the very first we need to download SQLAzureMW using below url and extract on your system at any location.

    Download SQLAzureMW tool

    1.2. Use SQL Server Management Studio to connection to your local sql server and AWS RDS instanace and make sure you have proper connectivity to both server.

    Step 2. Start Migration

    2.1. Start Migration

    Double click on SQLAzureMW.exe file from downloaded SQLAzureMW tool, and it will open screen like below. Select option Database and click Next.

    mssql-to-rds-1

    2.2. Source database tasks

    Enter source SQL Server database connection details and click Connect.

    mssql-to-rds-2

    Select datababase to be migrate on AWS RDS from the list of databases and click Next.

    mssql-to-rds-3

    Select “Script all database objects” option to migrate complete database or you can use second option to migrate selected objects only and click Next.

    mssql-to-rds-4

    Review the list of selected objects to be migrate and click Next.

    mssql-to-rds-5

    In this step wizard will create a script for all your sql server objects, Use Save button to save the script on your local hard drive and click Next to go to next step.

    mssql-to-rds-6

    2.3. Destination database tasks

    At this stage you have successfully created script of your database. Now input your RDS SQL Server connection details as below and click on Connect.
    mssql-to-rds-7

    Select target database to which you need to migrate your data, If you do not have already created database, create new using Create Database button. Finally click Next.

    mssql-to-rds-8

    At this step you will see that all data has been migrated to RDS SQL Server instance. Save the output showing on screen using Save button and check for errors if any.

    mssql-to-rds-9

    Step 3. Verify Data

    Now use your local SQL Server Management Studio and verify all your data migrated successfully or not. In case you get any errors, fix it manually.

    amazon Amazon RDS AWS RDS MSSQL to RDS RDS
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    Create AWS Cognito User with AWSCLI

    How to Create User Manually in AWS Cognito (CLI)

    How to Backup SQL Server Database

    How to Backup SQL Server Database

    How to Restore SQL Server database

    How To Restore SQL Server Database

    View 7 Comments

    7 Comments

    1. Alex on May 14, 2018 12:42 pm

      The program isn’t available on codeplex anymore. Do you have a local copy that you can share?

      Reply
    2. ajai on October 26, 2017 10:41 am

      The program isn’t available on codeplex anymore. Do you have a local copy that you can share?

      Reply
    3. Vivek on October 14, 2017 11:26 pm

      The program isn’t available on codeplex anymore. Do you have a local copy that you can share?

      Reply
    4. ganesh on June 4, 2016 7:55 am

      Relay helpful me , Thanks

      Reply
    5. Felipe Lima on February 4, 2016 5:13 pm

      Thanks man! Helped me a lot 🙂

      Reply
    6. Kevin on May 23, 2014 12:15 pm

      Hi Rahul,
      Thanks for this helpful tutorial. Could you tell me if the source database keeps running after AND during migration ?
      We need to copy our database for tests purpose of the production db.
      Does it work with this Tools ?
      Thanks in advance,
      Regards,
      Kevin.

      Reply
    7. yadav on May 9, 2014 1:24 pm

      The migration techniques are well explained , especially you have included very important step . verification of the data after migration. nice rahul !

      Reply

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • Error: EACCES: permission denied, scandir (Resolved)
    • How To Install Python 3.11 on Ubuntu 22.04 / 20.04
    • How to Install Python 3.11 on Amazon Linux 2
    • An Introduction to the “./configure” Command: Compiling Source Code in Linux
    • How to Install PHP 8.x on Pop!_OS
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.