- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
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.
Sorry you feel frustrated - let me point you to some documentation re SQL on EC2
SQL Server on EC2 Prescriptive Guidance Quick Start for SQL on EC2 with Always On Replication
Contenus pertinents
- demandé il y a un an
- demandé il y a 3 mois
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a un an
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