By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

A2K - how to compare tables

P: n/a
Got a bit of a major task coming up - I need to migrate data from one
version of my mdb to another. Normally I manually track what's changed but
there have been so many alterations it's been impossible to keep up.

What I would like is some sort of tool to analyse two mdbs and give me a
nice report showing the objects in each (mine will only have tables) and
then the differences between any tables e.g new/missing field, field type
change, or the max number of characters has changed, a change of validation
rule etc.

Anything professional out there that someone could recommend? I'm quite
willing to pay for something good.
Jan 14 '08 #1
Share this Question
Share on Google+
7 Replies


P: n/a
On Mon, 14 Jan 2008 01:28:46 -0000, "Deano" <de***@mailinator.com>
wrote:

fmsinc.com has such a tool.
-Tom.

>Got a bit of a major task coming up - I need to migrate data from one
version of my mdb to another. Normally I manually track what's changed but
there have been so many alterations it's been impossible to keep up.

What I would like is some sort of tool to analyse two mdbs and give me a
nice report showing the objects in each (mine will only have tables) and
then the differences between any tables e.g new/missing field, field type
change, or the max number of characters has changed, a change of validation
rule etc.

Anything professional out there that someone could recommend? I'm quite
willing to pay for something good.
Jan 14 '08 #2

P: n/a

"Tom van Stiphout" <no*************@cox.netwrote in message
news:0n********************************@4ax.com...
On Mon, 14 Jan 2008 01:28:46 -0000, "Deano" <de***@mailinator.com>
wrote:

fmsinc.com has such a tool.
-Tom.

Thanks that's one of two I have seen already, would be great to know if
anyone else here has experience of using them.
Jan 14 '08 #3

P: n/a
"Deano" <de***@mailinator.comwrote in
news:5u*************@mid.individual.net:
Got a bit of a major task coming up - I need to migrate data from one
version of my mdb to another. Normally I manually track what's
changed but there have been so many alterations it's been impossible
to keep up.

What I would like is some sort of tool to analyse two mdbs and give me
a nice report showing the objects in each (mine will only have tables)
and then the differences between any tables e.g new/missing field,
field type change, or the max number of characters has changed, a
change of validation rule etc.

Anything professional out there that someone could recommend? I'm
quite willing to pay for something good.
I can never understand why anyone would pay for something that is
completely available for free using ADO's OpenSchema method. Fifteen
minutes study will provide one with all the information one needs. The
bonus is that one learns something. I know learning is anathema to almost
evryone under fifty but seeking it has been ingrained in me and it won't go
away. I'm very sorry.

--
lyle fairfield

In ancient times Ulysses had to outwit the sirens, who had the power to
charm by their song all sailors who heard them, so that the mariners were
compelled to cast themselves into the sea to their destruction.
Today, he would have to deal with (free) Aim-Mail.

Jan 14 '08 #4

P: n/a
On Mon, 14 Jan 2008 04:03:27 GMT, lyle fairfield <ly******@yahoo.ca>
wrote:

Some of the features of the product I quoted are way beyond "15
minutes of study". I have great respect for people who write their own
tools, in fact I consider that part of being a seasoned developer. But
some tools can better be bought than reinvented.

-Tom.
>"Deano" <de***@mailinator.comwrote in
news:5u*************@mid.individual.net:
>Got a bit of a major task coming up - I need to migrate data from one
version of my mdb to another. Normally I manually track what's
changed but there have been so many alterations it's been impossible
to keep up.

What I would like is some sort of tool to analyse two mdbs and give me
a nice report showing the objects in each (mine will only have tables)
and then the differences between any tables e.g new/missing field,
field type change, or the max number of characters has changed, a
change of validation rule etc.

Anything professional out there that someone could recommend? I'm
quite willing to pay for something good.

I can never understand why anyone would pay for something that is
completely available for free using ADO's OpenSchema method. Fifteen
minutes study will provide one with all the information one needs. The
bonus is that one learns something. I know learning is anathema to almost
evryone under fifty but seeking it has been ingrained in me and it won't go
away. I'm very sorry.
Jan 14 '08 #5

P: n/a

"Tom van Stiphout" <no*************@cox.netwrote in message
news:1b********************************@4ax.com...
On Mon, 14 Jan 2008 04:03:27 GMT, lyle fairfield <ly******@yahoo.ca>
wrote:

Some of the features of the product I quoted are way beyond "15
minutes of study". I have great respect for people who write their own
tools, in fact I consider that part of being a seasoned developer. But
some tools can better be bought than reinvented.

-Tom.
Agreed. I write my own tools as well (though they are nothing special) but
when time is limited it doesn't seem sensible to reinvent the wheel. For me
it to replicate what seems to be on offer would be like starting another
major project.
Jan 14 '08 #6

P: n/a
Hi Deano,

You can try my tool : http://www.logicielappui.com/tips/AccXP_MDBDiff.zip
(sorry in french only)
it was compare tables and fields between 2 MDB.

Otherwise : http://www.logicielappui.com/tips/Ac...JStructure.zip
(auto-update structure)
Best regards

Bob

"Deano" <de***@mailinator.coma écrit dans le message de
news:5v*************@mid.individual.net...
>
"Tom van Stiphout" <no*************@cox.netwrote in message
news:1b********************************@4ax.com...
>On Mon, 14 Jan 2008 04:03:27 GMT, lyle fairfield <ly******@yahoo.ca>
wrote:

Some of the features of the product I quoted are way beyond "15
minutes of study". I have great respect for people who write their own
tools, in fact I consider that part of being a seasoned developer. But
some tools can better be bought than reinvented.

-Tom.

Agreed. I write my own tools as well (though they are nothing special)
but
when time is limited it doesn't seem sensible to reinvent the wheel. For
me
it to replicate what seems to be on offer would be like starting another
major project.

Jan 14 '08 #7

P: n/a
On Jan 14, 10:02 am, "Logipro" <nomanl...@nowhere.comwrote:
You can try my tool
You might want to remove this from your repertoire of useful English
phrases.
Jan 14 '08 #8

This discussion thread is closed

Replies have been disabled for this discussion.