Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Schema - Access Databases

Status
Not open for further replies.

JerryLan

Programmer
Jan 26, 2005
27
US
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"});
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top