Facebook Twitter Instagram
    TecAdmin
    • Home
    • Ubuntu 20.04
      • Upgrade Ubuntu
      • Install Java
      • Install Node.js
      • Install Docker
      • Install LAMP Stack
    • Tutorials
      • AWS
      • Shell Scripting
      • Docker
      • Git
      • MongoDB
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    Home»AWS»How to Migrate SQL Server Database to Amazon RDS Instanace

    How to Migrate SQL Server Database to Amazon RDS Instanace

    RahulBy 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.

    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
    Previous ArticleHow to Install Git 1.9 on Fedora 27/26, CentOS/RHEL 7/6
    Next Article Top 4 Alternatives of phpMyAdmin

    Related Posts

    How to Backup SQL Server Database

    Updated:June 28, 20212 Mins Read

    How To Restore SQL Server Database

    Updated:July 12, 20213 Mins Read

    How to Rename a SQL Server Database

    Updated:June 21, 20213 Mins Read

    (Fixed) Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)

    Updated:June 23, 20211 Min Read

    How to Remove CloudFront Cache

    Updated:April 3, 20212 Mins Read

    How To Delete Application Versions from AWS Beanstalk

    2 Mins Read

    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

    Recent Posts
    • How to Install JAVA on Ubuntu 22.04
    • Switching Display Manager in Ubuntu – GDM, LightDM & SDDM
    • Changing the Login Screen Background in Ubuntu 22.04 & 20.04
    • How To Install PHP (8.1, 7.4 or 5.6) on Ubuntu 22.04
    • (Resolved) Please install all available updates for your release before upgrading
    Facebook Twitter Instagram Pinterest
    © 2022 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

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