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... 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...
"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
"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
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.
"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/
"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.
"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.
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
"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/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
|
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.
|
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.
|
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.
|
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
| |
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
|
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...
|
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...
|
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...
|
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.
|
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...
| |
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,...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |