A2K - how to compare tables

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.

Re: A2K - how to compare tables

On Mon, 14 Jan 2008 01:28:46 -0000, "Deano"
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.
>

Re: A2K - how to compare tables

"Tom van Stiphout" wrote in message
news:0nhlo35uk3usrkm7d0ehrk7g3e3dp2di00@4ax.com...
> On Mon, 14 Jan 2008 01:28:46 -0000, "Deano"
> 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.

Re: A2K - how to compare tables

"Deano" wrote in
news:5uvs5uF1jf9luU1@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.

Re: A2K - how to compare tables

On Mon, 14 Jan 2008 04:03:27 GMT, lyle fairfield
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" wrote in
>news:5uvs5uF1jf9luU1@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.

Re: A2K - how to compare tables

"Tom van Stiphout" wrote in message
news:1bolo3d1s8kiklhaom1hjhhin1kuk6npbe@4ax.com...
> On Mon, 14 Jan 2008 04:03:27 GMT, lyle fairfield
> 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.

Re: A2K - how to compare tables

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/AccXP_MAJStructure.zip
(auto-update structure)


Best regards

Bob



"Deano" a écrit dans le message de
news:5v0a3cF1k8nctU1@mid.individual.net...
>
> "Tom van Stiphout" wrote in message
> news:1bolo3d1s8kiklhaom1hjhhin1kuk6npbe@4ax.com...
>> On Mon, 14 Jan 2008 04:03:27 GMT, lyle fairfield
>> 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.
>
>

Re: A2K - how to compare tables

On Jan 14, 10:02 am, "Logipro" wrote:

> You can try my tool

You might want to remove this from your repertoire of useful English
phrases.