Database Setup
Goal
- Lets setup Microsoft SQL Server
- Import some sample Databases
- Migrate to AWS RDS
Microsoft SQL Server Setup
- Supported SQL Server Versions Refer Here
- Lets create a Windows EC2 instance in AWS which will simulate on-premises Microsoft SQL Server
- Generate password from the pem file. connect to windows vm using
mstsc -v <public ip/dns> - INstall microsoft sql server 2017 and SQL Server Management studio as discussed in the class (refer video recording)
- For sample data lets use Adventure works Refer Here
Mysql Setup
- Try installing mysql on free linux instance Refer Here
