Remove From My Forums

Best approach for two MS Access mdb comparison

Question
0

Sign in to vote
Hello Sir,

Could you please suggest me the best approach for two mdb files comparison. Please see the assumptions below

Assumptions :

1. Both mdb files with underlying tables have almost same schema or coulmns with some minor changes here and there.

2. Each mdb file consist of approx 35-40 tables and each table have approx 100 columns and 500 rows approx.

3. Comparison should display the discrepancies between mdb tables.

In this scenario should I import the mdb in SQL Server or Oracle first and then do the comparison. Will that improve performance instead of taking data from mdb and then comparing ?

Please suggest. Any ideas are welcome.

Thank You
- Moved by Just Karl Wednesday, June 17, 2015 3:02 PM Looking for the proper forum.
Wednesday, June 17, 2015 1:25 PM

Answers

0

Sign in to vote
Hello,

The SQL Server forums are over here:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

Karl
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
My Blog: Unlock PowerShell
My Book: Windows PowerShell 2.0 Bible
My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})
- Proposed as answer by Mike Laughlin Thursday, June 18, 2015 2:20 AM
- Marked as answer by Just Karl Friday, June 26, 2015 8:43 PM
Wednesday, June 17, 2015 3:02 PM
0

Sign in to vote
Might also try here.

http://answers.microsoft.com/en-us/office/forum/access?sort=lastreplydate&dir=desc&tab=Threads&status=&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=All&tm=1434588029926

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.
- Proposed as answer by Mike Laughlin Thursday, June 18, 2015 2:20 AM
- Marked as answer by Just Karl Friday, June 26, 2015 8:43 PM
Thursday, June 18, 2015 12:43 AM

All replies

0

Sign in to vote

Hello,

This forum is for discussions and questions regarding profiles and Microsoft's recognition system on the MSDN and TechNet sites. It is not for products/technologies.

As it's off-topic here, I am moving the question to the Where is the forum for... forum.

Karl
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
My Blog: Unlock PowerShell
My Book: Windows PowerShell 2.0 Bible
My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})

Wednesday, June 17, 2015 3:02 PM
0

Sign in to vote
Hello,

The SQL Server forums are over here:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

Karl
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
My Blog: Unlock PowerShell
My Book: Windows PowerShell 2.0 Bible
My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})
- Proposed as answer by Mike Laughlin Thursday, June 18, 2015 2:20 AM
- Marked as answer by Just Karl Friday, June 26, 2015 8:43 PM
Wednesday, June 17, 2015 3:02 PM
0

Sign in to vote
Might also try here.

http://answers.microsoft.com/en-us/office/forum/access?sort=lastreplydate&dir=desc&tab=Threads&status=&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=All&tm=1434588029926

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.
- Proposed as answer by Mike Laughlin Thursday, June 18, 2015 2:20 AM
- Marked as answer by Just Karl Friday, June 26, 2015 8:43 PM
Thursday, June 18, 2015 12:43 AM

Answered by:

Best approach for two MS Access mdb comparison

Question

Answers

All replies