Copies a database table including definition

copy-table.ps1

$SourceServer = "MYSOURCE";
$SourceDB = "MySourceDB";
$DestDB = "MyDestDB";
$TableName = "MyTable";

# Get the table definition from the source
$tablescript = Get-DbaDbTable -ServerInstance $SourceServer -Database $SourceDB -Table $TableName | Export-DbaScript -Passthru;

# Run the script to create the table in the destination
Invoke-DbaQuery -Query $tablescript -ServerInstance $SourceServer -Database $DestDB;

# Copy the data
Copy-DbaDbTableData -ServerInstance $SourceServer -Database $SourceDB -DestinationDatabase $DestDB -Table $TableName -DestinationTable $TableName;