alevyinroc

begin {
    $SqlInstance = Connect-DbaInstance -SqlInstance "MyServer";
}
process {
    $SqlInstance = "MyServer";
    $SourceDb = "MySourceDb";
    $TargetDb = "MyTargetTb";
    $TableList = @("Table1","Table2","Table3","Table4");
    foreach ($Table in $TableList) {
        Start-ThreadJob -ThrottleLimit 2 -ArgumentList $SqlInstance, $SourceDb, $TargetDb, $Table -ScriptBlock {

alevyinroc

process {
    $SqlInstance = "MyServer";
    $SourceDb = "MySourceDb";
    $TargetDb = "MyTargetTb";
    $TableList = @("Table1","Table2","Table3","Table4");
    foreach ($Table in $TableList) {
        Start-ThreadJob -ThrottleLimit 4 -ArgumentList $SqlInstance, $SourceDb, $TargetDb, $Table -ScriptBlock {
            param($SqlInstance,
                $Source
                $Destination

alevyinroc

Invoke-DbaQuery -SqlInstance $DstInstance -Database $DBName -file $DstUserScriptPath;
Write-Output "Users in $DstInstance.$DBName after correcting"
Get-DbaDbUser -sqlinstance $DstInstance -Database $DBName | format-table -autosize -Property SqlInstance, Database, Name, Login;
Write-Output "Orphan users in $DstInstance.$DBName after correcting";
Get-DbaDbOrphanUser -sqlinstance $DstInstance -Database $DBName | format-table -autosize -property SqlInstance, DatabaseName, User;

alevyinroc

$RestoreResult = Restore-DbaDatabase -SqlInstance $DstInstance -Database $DBName -Path $Sql17Backup.FullName -WithReplace;
Write-Output "Users in $DstInstance.$DBName before correcting";
Get-DbaDbUser -sqlinstance $DstInstance -Database $DBName | format-table -autosize -Property SqlInstance, Database, Name, Login;
Write-Output "Orphan users in $DstInstance.$DBName before correcting";
Get-DbaDbOrphanUser -sqlinstance $DstInstance -Database $DBName | format-table -autosize -property SqlInstance, DatabaseName, User;

alevyinroc

import-module dbatools;
$SrcInstance = "flexo\sql17";
$DstInstance = "flexo\sql19";
$UserPassword = 'P@$$w0rd' | ConvertTo-SecureString -AsPlainText -Force;
$DBName = "UserPermTest";
$DstUserScriptPath = "C:\sql\Backup\Sql19Users.sql";

# Backup the databases
$Sql17Backup = Backup-DbaDatabase -SqlInstance $SrcInstance -Database $DBName -Path 'C:\sql\Backup\FLEXO$SQL17';
$Sql19Backup = Backup-DbaDatabase -SqlInstance $DstInstance -Database $DBName -Path 'C:\sql\Backup\FLEXO$SQL19';

alevyinroc

import-module dbatools;
$SrcInstance = "flexo\sql17";
$DstInstance = "flexo\sql19";
$UserPassword = 'P@$$w0rd' | ConvertTo-SecureString -AsPlainText -Force;
$DBName = "UserPermTest";
$DstUserScriptPath = "C:\sql\Backup\Sql19Users.sql";
# Create database & users on each
Remove-DbaDatabase -SqlInstance $SrcInstance, $DstInstance -Database $DBName -Confirm:$false | Out-Null;
New-DbaDatabase -SqlInstance $SrcInstance, $DstInstance -Name $DBName -Confirm:$false | Out-Null;

alevyinroc

create table #StringTemp3
(
    TempMyString testing.dbo.MyStringType not null
);

alevyinroc

use testing;
go
create table #StringTemp2
(
    TempMyString MyStringType not null
);

alevyinroc

use tempdb;
go
-- Get the full name of the table
select *
from tempdb.sys.tables
GO
-- Now get the definition
sp_help #StringTemp_________________________________________________________________________________________________________00000000081A
go
drop table #StringTemp;

alevyinroc

insert into TestMyString
    (ThisIsMyString)
values
    ('Hello there');
go
select *
into #StringTemp
from TestMyString;
go
select *