Data Compare from Backup - How to create iDatasource or LiveDatabaseSource
brij_singh555
Posts: 3 New member
Hello,
I am creating data compare from backup to database and using RedGate.SQLDataCompare.Engine.DataCompareUserActions.ReplayUserActions() cannot not figure out how to get iDatasource from backup connection as I don't have ServerName, DatabaseName, User and Password for backup file.
Dim connectionPropertiesForBackup = Me.GetConnectionPropertiesForBackup(BackupFilePath, Nothing)
Please help
I am creating data compare from backup to database and using RedGate.SQLDataCompare.Engine.DataCompareUserActions.ReplayUserActions() cannot not figure out how to get iDatasource from backup connection as I don't have ServerName, DatabaseName, User and Password for backup file.
Dim connectionPropertiesForBackup = Me.GetConnectionPropertiesForBackup(BackupFilePath, Nothing)
Please help
Tagged:
Answers
You should follow the BackupComparisonExample.vb example provided with the installation of the SQL Comparison SDK (default location C:\Program Files (x86)\Red Gate\SQL Comparison SDK 12\Samples\Automating SQL Data Compare\VB ) which goes through comparing from a backup to a database for a data comparison.
Kind regards,
Alex
Have you visited our Help Center?