Backup database structure

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null

$s = new-object ('Microsoft.SqlServer.Management.Smo.Server') "localhost"

$dbs=$s.Databases

$dbs["x1"].Script() | out-File D:\i8Solutions\bu\x1l.sql

$dbs["x2"].Script() | out-File D:\i8Solutions\bu\x2.sql

$dbs["x3"].Script() | out-File D:\i8Solutions\bu\x3.sql

$dbs["x4"].Script() | out-File D:\i8Solutions\bu\x4.sql

Till next time