Pillowcage

It’s brilliant on its own, but really, the things you find that are somehow related to it are somewhat surprising.

Nick Cage pillow case horse head

Advertisements

Migrating SQL Server 2012 to Amazon RDS

I just want to quickly reiterate what this comment suggested for how to quickly and easily migrate a SQL 2012 database to AWS. Of course I had tried to use the built-in Export wizard in Management Studio, however 2012 conveniently leaves out options for exporting constraints and the like, and restoring from a disk backup isn’t possible with Amazon RDS. But this little tool from CodePlex is exactly what I’ve been looking for. It migrated the entire database in a couple of minutes, scripting all the SQL and bcp commands, then executing without a hitch. Note: it’s built for SQL Azure migrations, but you can just enter your Amazon RDS endpoint in the server box, and it still works.