Does 'Self-managed' EC2 w/SQL Server support use of linked servers? Does it support over SSIS and use of Powershell? Are MS drivers such as accessdatabaseengine supported?

0

I am trying to discover which way our team should go when moving to AWS using SQL Server. We want to do this slowly while testing everything as much as possible. The migration from what we can tell should go smoothly as far as data being pushed goes. We are curious to see if we start at the Self-Managed EC2 level we will be able to seamlessly transition all our SSIS packages over and also SQL Agent Jobs? We do a lot of ETL work including working with MS Office products to create files, etc. So there are driver concerns, etc. I am just trying to see if anyone has done this or if anyone is knowledgeable and can point me in the right direction? Thanks.

asked a year ago203 views
2 Answers
0

A self-managed EC2 SQL Server will offer the same options you have today, this is commonly referred to as rehost or lift and shift. You can use AWS Application Migration Service to copy your entire SQL Server including the operating system - You will want to confirm how you wish to license your SQL server/Windows (Either through BYOL or licence included).

You may want to consider a migration to Amazon RDS for SQL Server to remove the overhead of managing the operating system and maintenance like backups and patching - this is commonly referred to as replatform. You would though need to confirm RDS supports the options you need. The best page to check is here. SQL Agent jobs using T-SQL are supported.

Additionally there is RDS Custom for SQL Server where you can get access to the underlying operating system to perform any customization which isn't supported by standard RDS for SQL Server. There are though some limitations to RDS Custom for SQL Server you should be aware of.

AWS
EXPERT
Peter_G
answered a year ago
  • So, at first being in development, I would want to do the 'lift and shift' or self managed option/Tier. I just really need to confirm that everything and every option and application that we use now will be supported and when I say supported I guess I mean 'will everything work the way it does now'? Again, things like SQL Agent Jobs, SSIS packages, Powershell, WinSCP, linked servers, db mail. integration services catalog, SSRS, and Power BI.... and the all the db connections, etc.? Is there a 'free' AWS offering that allows for Windows Authentication to where I can do a mock-up of what we have to see if the self-managed is what people say it is? I can set up a light version of what we do with minimal data to test everything?

  • I suggest using AD Connector for testing. You will need to establish connectivity (VPN being suitable for testing) from your AWS vpc to on premises where your current directory is located for ad connector to work. This will likely be needed for any lift and shift migration.

    You can establish a separate Active Directory using the AWS Directory Service but this is not free - See pricing here

0

Why is there so little documentation on migrating to the self-service option of SQL Server? I want to create a database, restore with a .bak file, have Windows Authentication, test SSIS deployment and SQL Agent jobs. all i find are articles about custom or fully manages versions of RDS. it's like AWS is just wanting to sell you (obviously and i understand...) instead of helping me figure things out first. Pretty frustrated at this point.

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions