REPOST: Re: Ascii-Export

Hi Detlef

On Thu, 24 Jan 2002 13:04:03 +0100, Detlef Jockheck <djockheck_at_gauselmann.de> wrote:

>I've exportet my db with exp into a dump-file, which is a binary file. Is
>it possible to create a "ascii"-dump-file. I want to compare a DB on two
>different servers using the unix "diff"-command.

If you are only interested in comparing the DDL then you could use the free DBATool to dump the DDL of both instances to the disk as SQL files and then diff the files. If you want to diff for data differences your best bet is SQL queries or spooling the table contents to disk in a sorted manner and then diffing those files

The free DBATool can be found at http://www.databee.com/dt_home.htm

Regards
Dale Edgar
Net 2000 Ltd.
Dale_at_DataBee.com

• WAS CANCELLED BY =======: From: dale_at_databee.com (Dale Edgar) Control: cancel <3c5002d6.2631592_at_news.btclick.com> Subject: cmsg cancel <3c5002d6.2631592_at_news.btclick.com> Date: Sun, 27 Jan 2002 22:59:10 GMT Message-ID: <cancel.3c5002d6.2631592_at_news.btclick.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.tools NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.easynews.net!easynews.net!easynet-tele!easynet.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40719258

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 13:53:34 CET