I need to DIFF two Access databases for schema changes using C#. I have read that the GetOleDbSchemaTable method can give schema information that can be used for this purpose, but the command below yields a large structure with no usable data that I can find. Maybe I have the restrictions on the object set wrong, I don't know. I am having a hard time finding useful documentation on this command.
If someone has a better way to DIFF two .MDB schemas I would appreciate it.
DataTable schemaTable = oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"});
If someone has a better way to DIFF two .MDB schemas I would appreciate it.
DataTable schemaTable = oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"});