When I attempt to create an instance of the BackupConnection using the default ctor I get the following error message
SQL Backup Reader may not be called from user code
I also tried using RegisterForDataCompare and opening the BackupConnection and that returns the exception
No filenames specified.
I need to do a schema and data compare between two SQL Server 2008 database backups. If I detect a schema or data difference I need to output the tables in the target database to a Sql CE sdf.
I have the code working to output the database schema I just need to know how to read all records from each table in the backup using the SDK.
I think I can also accomplish what I need if I can compare a sql backup to an empty folder. Then I could read the data I need from the table differences object. But every time I try that type of compare there are no table differences.
Thanks in advance.