473,795 Members | 2,834 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

'diff' for MSAccess?

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
10 4299
On Mon, 13 Aug 2007 19:47:44 -0000, "robert.wat ers"
<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

"Steve" <so***@private. emailaddresssch reef in bericht news:13******** *****@corp.supe rnews.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
"Steve" <so***@private. emailaddresswro te in message
news:13******** *****@corp.supe rnews.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
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.DefaultValu e, 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
"Keith Wilby" <he**@there.com wrote:
>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
"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message
news:80******** *************** *********@4ax.c om...
"Keith Wilby" <he**@there.com wrote:
>>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
"Keith Wilby" <he**@there.com wrote in message
news:46******** **@glkas0286.gr eenlnk.net...
"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message
news:80******** *************** *********@4ax.c om...
>>
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
On Thu, 16 Aug 2007 15:08:05 +0100, "Keith Wilby" <he**@there.com >
wrote:
>"Keith Wilby" <he**@there.com wrote in message
news:46******* ***@glkas0286.g reenlnk.net...
>"Tony Toews [MVP]" <tt****@teluspl anet.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
confrontationa l. 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
"Keith Wilby" <he**@there.com wrote:
>>>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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2519
by: Charley | last post by:
I've got a diff file that I think is a patch for a bunch of file in a directory. How do I apply this file? I thought it was #patch myfile.diff But that does nothing. I must be missing something. The diff file contains diff's for a nuch of files, not just a single file. Do I need a
15
11559
by: (Pete Cresswell) | last post by:
I've got a .BAT file that I use for executing various MS Access apps that I wrote way back in the days of 2.0. It's evolved over time, but it still contains a number of possible paths to MSACCESS.EXE, tries them all, takes the first one it finds, and dies if none is found. Seems to me like at some time or another I was able to clone this .BAT file and implement it with no path. Something about MSACCESS being a registered application.
9
6520
by: Ching-Lung | last post by:
Hi all, I try to create a tool to check the delta (diff) of 2 binaries and create the delta binary. I use binary formatter (serialization) to create the delta binary. It works fine but the delta binary is pretty huge in size. I have 1 byte file and 2 bytes file, the delta should be 1 byte but somehow it turns out to be 249 bytes using binary formatter. I guess serialization has some other things added to the delta file.
6
6456
by: Igor Shevchenko | last post by:
Hi! Suppose I have "pg_dump -s" of two pg installs, one is "dev", another is "production". Their schemas don't differ too much, and I want to get a "diff -u"-like schema diff so I can quickly add missing/remove old tables/sequences/etc to one or another (manually). Is there some quick tool for doing this ? There was a thread about it sometime in aug, 2002, but it ended without producing anything useful.
4
4957
by: Andreas Kasparek | last post by:
Hola! I'm preparing my master thesis about a XML Merge Tool implementation and was wondering if there is any open standard for XML diff regarding topics like: - is a diff result computed on the ordered or unordered xml node tree of the compared documents? - what identifiers/criteria should be used by default to match elements of the same type in different documents? - should a diff tool consider move operations or only insert/delete
0
1579
by: MLH | last post by:
I've been unable to determine the correct setting to force a copy of msaccess.exe to be written to target disk during runtime installation process. It may be that the runtime installation determines if msaccess.exe exists somewhere on the target drive and is being "smart" choosing not to write a redundant copy of it. But I'm not as "smart" and I want a copy of msaccess.exe to be written to c:\program files\MyRuntimeApp\ during
2
1787
by: reidarT | last post by:
I am making an installation program for an Access application. The application is run on both Office 2000, 2002, 2003 and soon 2007 versions of Office, When I install the application I need a shortcut from the users desktop and I need C:\programfiles\office\office9\msaccess path\application.mdb /wrkgrp path\lockfile.mdw C:\programfiles\office\office10\msaccess path\application.mdb /wrkgrp path\lockfile.mdw...
1
2254
by: rolandsk | last post by:
I need help to schedule a MsAccess procedure I want the procedure to run in backgrund and not the MsAccess file to be open during the time when the procedure runs. The procedure in MsAccess picks data from an oracle database and then create excelfiles. It works good while using the scheduler in MsAccess, but when I do that the MsAccess opens first and I dont want that to happen. I would like to have a bat-file(procedure.bat) scheduled to run...
0
2026
by: bbrewder | last post by:
I am struggling with some MSAccess automation issues. Basically, we have a .Net application that uses MSAccess for reporting (legacy code). We are able to launch MSAccess fine and even work with the MSAccess COM objects to run our reports (using GetObject(<MDB Path>) - see http://support.microsoft.com/default.aspx?scid=kb;en-us;317113&Product=vbNET for info on how to do this). The problem that we are running into is that if our Access...
6
3318
by: Aaron Gray | last post by:
Hi, I am working on an HTML WYSISYG Wiki and need to display a diff page like WikiPedia does if two people edit a file at the same time to give the second user the diff. Basically with additions in red and deletions in red strike though. There seem to be several in Perl and Python and many diff programs which all seem to be line based and work on text written in PHP.
0
9673
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9522
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10216
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10002
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6783
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5565
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3728
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2921
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.