Generate data seeding script using PowerShell and SSMS

You can use the SMO scripter class. This will allow you to script the table creates as well as INSERT statements for the data within the tables.

In my example I'm directly targeting TempDB and defining an array of table names I want to script out rather than scripting out every table.

Scripter has a lot of options available, so I've only done a handful in this example - the important one for this task is Options.ScriptData. Without it you'll just get the schema scripts that you're already getting.

The EnumScript method at the end does the actual work of generating the scripts, outputting, and appending the script to the file designated in the options.

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null ## target file$outfile = 'f:\scriptOutput.sql' ## target server$s = new-object ('Microsoft.SqlServer.Management.Smo.Server') "localhost"  ## target database$db = $s.databases['tempdb'] ## array of tables that we want to check$tables = @('Client','mytable','tablesHolding')## new Scripter object$tableScripter = new-object ('Microsoft.SqlServer.Management.Smo.Scripter')($s) ##define options for the scripter$tableScripter.Options.AppendToFile = $True$tableScripter.Options.AllowSystemObjects = $False$tableScripter.Options.ClusteredIndexes = $True$tableScripter.Options.Indexes = $True$tableScripter.Options.ScriptData = $True$tableScripter.Options.ToFileOnly = $True$tableScripter.Options.filename = $outfile## build out the script for each table we defined earlierforeach ($table in $tables) {    $tableScripter.enumscript(@($db.tables[$table])) #enumscript expects an array. this is ugly, but it gives it what it wants.}