How can we help you today? How can we help you today?

Data Compare from Backup - How to create iDatasource or LiveDatabaseSource

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
brij_singh555
0

Comments

1 comment

Sort by
  • Alex B
    Hi @brij_singh555

    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
    Alex B
    0

Add comment

Please sign in to leave a comment.