title: Automating the creation of a database in SQL Server hosted in Amazon RDS
body: <p>I have been doing some research with SQL Server hosted in Amazon RDS. I am planning on having an application that requires multi tenancy solution - one database per customer with a core database for login etc.</p>
  
  <p>So Im playing with RDS/SQL Server but there are come problems I need to overcome. Firstly how do automate the creation of a database? I RDS I cannot just restore from a bak file and I want to create database schema from template. Does anybody have any experience with this and if so can you guide me with some tips?   </p>
  
  <p>Thanks,</p>
  
  <p>kseudo</p>