October 2007 - Posts

• Scripting Tables, Views and Data using SMO (part 3)

  Below is the final code that I used to script off my Tables, Views and the data using sp_generate_inserts from Vyas . This is something that I have needed to do, and I found that using SMO for this is a great tool. Mind you, that the data file that gets Read More... Posted Thursday, October 18, 2007 10:34 AM by dbaduck | 2 Comments

• Using a typeof() in Powershell for SMO server.SetDefaultInitFields

  In trying to squeeze performance out of the SMO stuff that I have been learning and doing for SQL Server I came across the method on the Server object called SetDefaultInitFields . In my previous posts on Powershell or .NET and SMO, when you start scripting Read More... Posted Tuesday, October 16, 2007 11:07 AM by dbaduck | 0 Comments Filed under: SMO Powershell

• Table scripting with SMO (Part 2 with Powershell)

  In my previous post I illustrated scripting tables out with SMO in .NET. I have tested a new version this time in Powershell. I used the model with args, but you can just put it in the script as well. This also goes and scripts out your Views as well, Read More... Posted Monday, October 15, 2007 9:32 AM by dbaduck | 3 Comments

• Table scripting with SMO (PART 1)

  Thanks to Allen White and his talk at PASS , I have been inspired in my plight to create a complete build script of the database that I am in charge of for a dev project at work. So I wanted to start by scripting the tables that exist in my database. Read More... Posted Wednesday, October 03, 2007 6:59 AM by dbaduck | 6 Comments Filed under: SMO