Competition: What’s your favorite Redgate tool? Enter now.

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
Tagged:

Answers

  • 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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.