Recipe #01 - Let's cook!

In [ ]:

    

$path = "D:\Presentations\PASS Marathon Portuguese 2020\Export-DbaDatabase\temp"
$dbatools1 = "localhost,1433"
$secureString = ConvertTo-SecureString "dbatools.IO" -AsPlainText -Force
$cred = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList "sqladmin", $secureString


    

In [ ]:

    

#Perform export (not currently supported on Core)
#You may note that linked servers, credentials and central management server are excluded from the export. 
#This is because they aren’t currently supported for various Windows-centric reasons.

$splatExportInstance = @{
    SqlInstance = $dbatools1
    SqlCredential = $cred
    Path = $path
    Exclude = @("LinkedServers", "Credentials", "CentralManagementServer", "BackupDevices", "Endpoints", "Databases", "ReplicationSettings", "PolicyManagement")
    ExcludePassword = $true
}
Export-DbaInstance @splatExportInstance


    

In [ ]:

    

# View output
Invoke-Item $path


    

In [ ]:

    

# 1. Save the results to a temp folder
# 2. Remove the suffix "-datetime" 
Get-ChildItem -Path $path | ForEach-Object {Rename-Item -Path $_.FullName -NewName $_.Name.Substring(0, $_.Name.LastIndexOf('-')) -Force}

# 3. Copy and overwrite the files within your GIT folder. (This way you will keep the history)
Copy-Item -Path "$path\*" -Destination $(Split-Path -Path $path -Parent) -Recurse -Force