Hey All,
I am trying to create utility to check data inconsistency in ASP.net 2.0 C# means I want to compare two databases in two different sources i.e MS Access and SQL Server.
I want to create application where I should provide two data connection strings one for Acess and one for SQL server and then I want to compare for ex: if I am comparing master DB and somebody has added table "xyz" in MS Acess master DB, then I want to generate a report which says that "tables does not match. table xyz has been added to MS Acess master database.
Can anyone suggest any approach or refere me to similar kind of article or application?
Thanks
I am trying to create utility to check data inconsistency in ASP.net 2.0 C# means I want to compare two databases in two different sources i.e MS Access and SQL Server.
I want to create application where I should provide two data connection strings one for Acess and one for SQL server and then I want to compare for ex: if I am comparing master DB and somebody has added table "xyz" in MS Acess master DB, then I want to generate a report which says that "tables does not match. table xyz has been added to MS Acess master database.
Can anyone suggest any approach or refere me to similar kind of article or application?
Thanks