So, you've got an Azure SQL Database and have been doing some work in it/on it and then find out it is a CTP and you need to move the data and schema to another database.

Which isn't bad but there aren't any good tools for scripting an Azure SQL database, mostly because Azure SQL doesn't support using the DMO, which is what most people use.

So, I wrote my own.

It's not perfect, it's missing a few things (doesn't handle triggers, for instance) but it should be good enough to get you started.

It's simple enough. Download and run the code (or Install the app), enter the connection string to the server and a file name to store the script and click on Backup. The utility will walk the database, scripting tables, constraints, indices, views, stored procedures and functions.

Each object is wrapped in an IF EXISTS so you should be able to run it multiple times.

If there's something missing and you want to add it, add it and send me the code and I'll incorporate it.

If there's something missing and you don't know how to add it, leave feedback and I'll see if I can incorporate it.

Keep watching both this space and CloudQuotes. I've got some exciting new projects that will be pushing some boundaries, including a handler for AzureStorage apps.

Josef Finsel
AzureDBA