Script whole database in one script / filter databases

Sep 7, 2011 at 6:38 AM

Hi all,

I have been playing around a bit with this nice little program (SQL 2008R2/Windows 7 x64) and I am very glad with it.

I wonder about two things:

- is it possible to script a whole database in one script? Just like you would do when generating a script in Management Studio? I know there are other ways to combine all the table scripts etc. to one large script but it would be a nice option

- I would like to be able to use the -ScriptAllDatabase option but it would be nice if you could filter on let's say the first few characters of the database name? Is this possible?

Thanks in advance!

Cheers,
Erik