Jose Manuel Jurado Diaz has a script for us:
This week, I’ve been working on a service request case where we need to export multiple databases using SqlPackage. Following, I would like to share my lesson learned to export simultaneous several databases, saving the export files to the F:\sql folder and the logs of the operations to the F:\sql\log folder.
Few recommendations when performing these exports:
Click through for those recommendations and the script. The cynic in me would add a third tip: make sure your databases are small, or else SqlPackage won’t work so well.