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

'diff' for MSAccess?

P: n/a
Does anyone know of a utility that would allow you to compare two
(similar) databases?
I have two projects that started out with the same codebase and sort
of started to branch off from each other. I now need to merge many of
the changes from one into the other, and find myself needing to
compare the structures of all of the tables in each database; they are
basically the same, but there may be new fields in one, and the
default value or data type for a field may have changed in another,
etc.
Is this possible?

If not, does anyone know of a utility that will dump table structures
to file? Having a .sql file for each db would be very helpful...

Aug 13 '07 #1
Share this Question
Share on Google+
10 Replies


P: n/a
On Mon, 13 Aug 2007 19:47:44 -0000, "robert.waters"
<ro***********@gmail.comwrote:

Take a look at this utility:
http://www.fmsinc.com/Products/detective/index.html

Unfortunately the company is taking its time revving all their
products to A2007.

-Tom.

>Does anyone know of a utility that would allow you to compare two
(similar) databases?
I have two projects that started out with the same codebase and sort
of started to branch off from each other. I now need to merge many of
the changes from one into the other, and find myself needing to
compare the structures of all of the tables in each database; they are
basically the same, but there may be new fields in one, and the
default value or data type for a field may have changed in another,
etc.
Is this possible?

If not, does anyone know of a utility that will dump table structures
to file? Having a .sql file for each db would be very helpful...
Aug 14 '07 #2

P: n/a

"Steve" <so***@private.emailaddressschreef in bericht news:13*************@corp.supernews.com...
>I can help you ----
You stupid selfdestructive idiot !!
A few more of these posts please !!
After that we are going to complain to your new ISP daily.
ab***@supernews.com

I guess you have finally been kicked out by Earthlink??

Arno R
Aug 14 '07 #3

P: n/a
"Steve" <so***@private.emailaddresswrote in message
news:13*************@corp.supernews.com...
My fee is very reasonable. My fee is very reasonable.
My fee is very reasonable.
My fee is very reasonable.
Shut up you demented parrot.

http://home.tiscali.nl/arracom/whoissteve.html

Aug 14 '07 #4

P: n/a
robert.waters wrote:
Does anyone know of a utility that would allow you to compare two
(similar) databases?
I have two projects that started out with the same codebase and sort
of started to branch off from each other. I now need to merge many of
the changes from one into the other, and find myself needing to
compare the structures of all of the tables in each database; they are
basically the same, but there may be new fields in one, and the
default value or data type for a field may have changed in another,
etc.
Is this possible?

If not, does anyone know of a utility that will dump table structures
to file? Having a .sql file for each db would be very helpful...
This will list your tables and some properties.
Sub ListStru()
Dim tdf As TableDef
Dim fld As Field
Dim dbs As Database
Set dbs = CurrentDb

Debug.Print "Table", "Name", "Default", "Type", "Size"

For Each tdf In dbs.TableDefs
For Each fld In tdf.Fields
Debug.Print tdf.name, fld.name, fld.DefaultValue, fld.Type,
fld.Size
Next
Next
MsgBox "Done"
End Sub

You could run this but instead of debug.printing, store the values in a
temp table on each mdb, then import both temp tables to a new databse
and run some SQL queries to compare.

Aug 14 '07 #5

P: n/a
"Keith Wilby" <he**@there.comwrote:
>Shut up you demented parrot.
Please don't make fun of anyone. Just state your case but no more.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Aug 15 '07 #6

P: n/a
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:80********************************@4ax.com...
"Keith Wilby" <he**@there.comwrote:
>>Shut up you demented parrot.

Please don't make fun of anyone. Just state your case but no more.
It wasn't intended to "make fun" and I don't know how you read that into it.
I'm *tired* of reading that phrase over and over and it *should not* be
iterated on this forum, *that* is my case.

Aug 16 '07 #7

P: n/a
"Keith Wilby" <he**@there.comwrote in message
news:46**********@glkas0286.greenlnk.net...
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:80********************************@4ax.com...
>>
Please don't make fun of anyone. Just state your case but no more.

It wasn't intended to "make fun" and I don't know how you read that into
it. I'm *tired* of reading that phrase over and over and it *should not*
be iterated on this forum, *that* is my case.
OK Tony, someone has pointed out that my response to you looks
confrontational. That was not my intent at all, please don't take it as
such, I am just so very tired of having that phrase on my screen. Perhaps
I'll just KF him and have done with it.

Keith.

Aug 16 '07 #8

P: n/a
On Thu, 16 Aug 2007 15:08:05 +0100, "Keith Wilby" <he**@there.com>
wrote:
>"Keith Wilby" <he**@there.comwrote in message
news:46**********@glkas0286.greenlnk.net...
>"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:80********************************@4ax.com.. .
>>>
Please don't make fun of anyone. Just state your case but no more.

It wasn't intended to "make fun" and I don't know how you read that into
it. I'm *tired* of reading that phrase over and over and it *should not*
be iterated on this forum, *that* is my case.

OK Tony, someone has pointed out that my response to you looks
confrontational. That was not my intent at all, please don't take it as
such, I am just so very tired of having that phrase on my screen. Perhaps
I'll just KF him and have done with it.

Keith.
I think almost everyone here agrees that PC Datasheet's solicit ions
in the newsgroups are inappropriate. History has, however, clearly
shown that there is no point whatever in attempting to communicate
with him. Reason, criticism, and pleading are all a waste. The best
that can be hoped for is to warn newcomers about his track record.
That way we consume a minimum of bandwidth and minimally irritate the
many people that come here for what these newsgroups were intended -
the free exchange of information and help for MS Access.

My 2 centavos,
Arch
Aug 17 '07 #9

P: n/a
"Keith Wilby" <he**@there.comwrote:
>>>Shut up you demented parrot.

Please don't make fun of anyone. Just state your case but no more.

It wasn't intended to "make fun" and I don't know how you read that into it.
<smile Interesting how there are different reactions to the same posting.
>I'm *tired* of reading that phrase over and over and it *should not* be
iterated on this forum, *that* is my case.
Agreed.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Aug 17 '07 #10

P: n/a
"Keith Wilby" <he**@there.comwrote:
>It wasn't intended to "make fun" and I don't know how you read that into
it. I'm *tired* of reading that phrase over and over and it *should not*
be iterated on this forum, *that* is my case.

OK Tony, someone has pointed out that my response to you looks
confrontational. That was not my intent at all, please don't take it as
such,
Not a problem.

I never took your posting as being such.

I've had a number of far more confrontational postings directed my way. Yours would
be somewhat like a humming bird farting in a hurricane. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Aug 17 '07 #11

This discussion thread is closed

Replies have been disabled for this discussion.