Sample SSM document code to downgrade Standalone SQL Enterprise to other Editions(Standard,Developer,Web) .
This file is used to Install SQL Server. Modify/Create similar Configuration file for the version of SQL Server
This powershell script needs to be used as part of SSM document that will do SQL Server downgrade
This is the content of SSM Document that can be used to create SSM document in your AWS Account to automate the SQL downgrade
1.Amazon EC2 windows Instance with SQL Server Enterprise Edition Installed 2.SQL Server Management Studio on SQL EC2 instance 3.S3 bucket for SQL Standard installation Media , Cumulative Update and Configuration 4.File to install SQL Server 5.EC2 instances to access S3 bucket to download the installation Media 6.System manager agent installed on EC2 instance
- Take Full backups of system and user databases of existing SQL Server Enterprise Edition
- Stop SQL Server Services
- Backup Copy master and msdb physical database files to Backup folder
- Uninstall Enterprise Edition software
- Install Standard/Developer edition
- Install Cumulative Update if provided in S3 location
- Attach SQL Server user databases from Enterprise Edition to Standard/Developer edition
- Stop SQL Server Services
- Replace new master and msdb database files with the files we backup earlier.
- Start SQL Server Services