In the previous step we have created an instance of SQL server service inside a free AWS account. We well now create a new database and a table inside it.
Our SQL server is manageable in the same way we would do with a local or LAN SQL server. So let's simply launch Microsoft SQL Management Studio (2014 in my case). As usual, it starts asking for an engine to connect to
Here we are going to put our AWS connection parameters. To find them, we just need to scroll in the AWS console, chasing the Endpoint url
and simply copy/paste it into the connection dialog. In this walkthrough we use the SQL server authentication method, with user and password chosen when we created the SQL server instance in AWS (sa/sapassword in my case)
Then push Connect and we'll magically log into our AWS SQL server.
Let's now create a new database, that we'll call simply db1
Press OK and we get our database ready to work
To be able to play with data, we now need at least one table. Let's create Table1 with the following scheme (id to be set as identity)
Conclusion
With this post, we have now built a fully functioning data repository that behaves as Microsoft SQL server and sits in Amazon Web Services. In the next steps we'll see how to use F# and Visual Studio Community (both free) to manipulate the data in the repository.