Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using DMS to migrate AWS RDS for SQL Server to Azure SQL #71183

Closed
bh3r1th opened this issue Feb 24, 2021 · 8 comments
Closed

Using DMS to migrate AWS RDS for SQL Server to Azure SQL #71183

bh3r1th opened this issue Feb 24, 2021 · 8 comments

Comments

@bh3r1th
Copy link

bh3r1th commented Feb 24, 2021

As per the details in https://docs.microsoft.com/en-us/azure/dms/tutorial-rds-sql-server-azure-sql-and-managed-instance-online, we can select AWS RDS for SQL Server as the source server for DMS.
But, I'm not finding that in my DMS deployment. You can see that in the screenshot I attached.

So, can we use Azure DMS for migrating AWS RDS for SQL Server to Azure SQL or not?

DMS


Document Details

Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

@NavtejSaini-MSFT
Copy link
Contributor

@nunepalli After reviewing the document we found that source has been used as SQL Server for RDS SQL server as well.
Please can you check the same and let us know the result. Also we hope you are using DMS 3.3 or later.
image

@bh3r1th
Copy link
Author

bh3r1th commented Feb 25, 2021

@NavtejSaini-MSFT
I'm using DMA v5.2.4764.4

I'll test whether choosing source server type as "SQL Server" will work for migrating from AWS RDS for SQL Server or not.

Meanwhile, please update the details in https://docs.microsoft.com/en-us/azure/dms/tutorial-rds-sql-server-azure-sql-and-managed-instance-online
DMS screenshots are misleading.

@NavtejSaini-MSFT
Copy link
Contributor

@nunepalli Review with SQL Server, if successful we will assign the issue for enhancement to our doc author.

@bh3r1th
Copy link
Author

bh3r1th commented Feb 28, 2021

@NavtejSaini-MSFT
I'm able to migrate database from AWS RDS for SQL Server to Azure SQL by choosing "SQL Server" as the source server type in DMS project.

@NavtejSaini-MSFT
Copy link
Contributor

@nunepalli We are glad this is resolved for you. Please convey which screenshots are not correct. If you can give an example, please convey that as well.

@bh3r1th
Copy link
Author

bh3r1th commented Mar 1, 2021

@NavtejSaini-MSFT
These 2 screenshots are showing that we can select AWS RDS for SQL Server in DMS
dms-create-and-run-activity1
dms-create-project4

@NavtejSaini-MSFT
Copy link
Contributor

@nunepalli Thank you for this.
@pochiraju Please check the screenshots above and please help us change the same.

@rothja
Copy link
Contributor

rothja commented Sep 2, 2021

It looks like the original tutorial has been removed as it redirects to the landing page now. Because the screenshots are no longer an issue (as the article was removed), I am closing this issue. If this is incorrect, please let me know and we will address the issue in the documentation. Thank you! #please-close

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

6 participants