Zurück
-
Titel
How to compare 2 snpashots. -
Beschreibung
How to compare two database snapshots. -
Lösung
$TDT = New-Object -ComObject 'Toad.ToadAutoObject'try {# Set Database Compare Parameters$TDT.CompareDatabases.ObjectTypes.IncludeAll()$TDT.CompareDatabases.SourceSnapshotFilename = "C:\Source.ddxml"$Target = $TDT.CompareDatabases.Targets.Add()$Target.SnapshotFilename = "C:\Target.ddxml"$Target.DifferenceDetails = "C:\DiffDetails.txt"$Target.DifferenceSummary = "C:\DiffSummary.htm"$Target.SchemaSnapshot = "C:\Snapshot.json"$Target.SyncScript = "C:\SyncScript.sql"$TDT.CompareDatabases.Execute()} finally {$TDT.Quit()} -
Weitere Informationen
DDXML files are created when snapshot is created in Toad for Oracle or in Toad DevOps Toolkit