Vista - Implementing SMO in Powershell

Hello,

I am fairly new to Powershell and certainly not to familiar with SMO, so
really need some help with this problem I’ve encountered.

I’m essentially trying to script the creation of a SQL Server 2005 database
with the applicable entities using SMO. I have successfully created a
database using SMO, but not too sure on how to script the creation of new
entities and add them to a particular database. I have searched high and low
but can’t find any relevant information on the subject.

I have found a useful add-on called PowerSMO but this can only be used for
test purposes whereas I will be implementing my work into production.

I guess I’ll have to use something like
‘Microsoft.SqlServer.Management.Smo.Table’ but I’m not entirely sure of the
syntax or how to implement this object.

If anyone can answer my question or point me in the right direction (any
direction) I’d really appreciate it.

Thanks,

Try

http://www.databasejournal.com/featu...le.php/3691566


Shay
http://scriptolog.blogspot.com

I got this to work. Obviously need to add more columns as required

$null =
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")
$null =
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum")
$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
$Server = new-object Microsoft.SqlServer.Management.Smo.Server("RSSQL1")
$db = $server.Databases["Test"]

$table = New-Object Microsoft.SqlServer.Management.Smo.Table($db, "NewTable")


$dt1 = [Microsoft.SqlServer.Management.Smo.Datatype]::Nchar(50)
$col1 = New-Object Microsoft.SqlServer.Management.Smo.Column($table, "Name",
$dt1)
$col1.Collation = "Latin1_General_CI_AS"
$col1.Nullable = $false

$table.Columns.Add($col1)
$table.Create()
--
Richard Siddaway
Please note that all scripts are supplied "as is" and with no warranty
Blog: http://richardsiddaway.spaces.live.com/
PowerShell User Group: http://www.get-psuguk.org.uk


"Shay Levi" wrote:

Thanks Shay and Rich for you quick replies!

Shay...
Thanks for the link but i'll already used that info to create my database.
Its about the only useful information out there on SMO in Powershell.

Rich...
Many Thanks and a huge thumbs up! The code snippet you've written works
great and given me a lot to play with

"RichS" wrote: