From derby-user-return-10345-apmail-db-derby-user-archive=db.apache.org@db.apache.org Fri Jan 09 10:56:40 2009 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 65905 invoked from network); 9 Jan 2009 10:56:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Jan 2009 10:56:40 -0000 Received: (qmail 84068 invoked by uid 500); 9 Jan 2009 10:56:39 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 84046 invoked by uid 500); 9 Jan 2009 10:56:39 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 84037 invoked by uid 99); 9 Jan 2009 10:56:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Jan 2009 02:56:39 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jamianb@gmail.com designates 74.125.46.29 as permitted sender) Received: from [74.125.46.29] (HELO yw-out-2324.google.com) (74.125.46.29) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Jan 2009 10:56:31 +0000 Received: by yw-out-2324.google.com with SMTP id 2so3276078ywt.85 for ; Fri, 09 Jan 2009 02:56:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=XvJOHDIYFoNU/O/bYylPipYeOaAUE/wcNtmOWRu/5Xk=; b=PlG4Ex8iCcxCv9vGV740ORXpr2oRHppRHmdPOhfnaeg9P+S5y+76rNQ8/oJKSf1O2E e+AOj8H4AC0tgn5l/6t8hsYTeciqHDGGKaRKaca5mJiUazQ/f9NwiIHuEJi9yZ3OiTem T7UsNVNaJo0EZaQMymZTBb+D8zoD4SZZKFsHA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=ecfEK9m1I8kW9mCBC9S5ebmR3sH2SUjYzyBV7KTXWHSfz4Aqht/O00gqOlUclVlUQr yEmzduXEwtfxgNd9SLFPpBaLkazJyGWa7f02Ggh6f6cweGabe8+OTVLsYjnAojdt92vA /4YmTg2qcUTp1pQNK/5B1zmh1zq46ysS8rzRo= Received: by 10.150.186.21 with SMTP id j21mr3897379ybf.75.1231498570547; Fri, 09 Jan 2009 02:56:10 -0800 (PST) Received: by 10.151.135.13 with HTTP; Fri, 9 Jan 2009 02:56:10 -0800 (PST) Message-ID: <2bbc8f530901090256n75a45c41v6d8a4f3166a89065@mail.gmail.com> Date: Fri, 9 Jan 2009 21:56:10 +1100 From: "Damian Carey" To: "Derby Discussion" Subject: Re: Derby SQL diff tool suggestions In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <2bbc8f530901081631y39f3ffb2v732b03678961594b@mail.gmail.com> <2bbc8f530901081727p4054ca18xc80b2cbb5e2c1f96@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org On Fri, Jan 9, 2009 at 8:00 PM, Thomas Kellerer wrote: > Damian Carey wrote on 09.01.2009 02:27: >> >> SQL Workbench looks like an excellent tool going forward! >> I've been trying it out and got it going in minutes. >> >> Just for now, however, I'm looking for a Derby SQL diff tool. > > But WbSchemaDiff /can/ be used on two Derby databases? > > I don't understand why you think it can't diff a derby database. > > Or are you looking for a tool that outputs the diff directly as a SQL > script? > Thomas Thomas, Firstly, I'm sure you know more about databases than I will ever know. So I may well be misunderstanding my options and your offerings. The "diff" tool I'm searching for takes two schemas (say "MySchemaVersion 7" and "MySchemaVersion8") and outputs the SQL diff. So the diff is an SQL script that may be as simple as .. ALTER TABLE mytable ADD COLUMN mynewcol character varying(10000), ALTER COLUMN myoldcol TYPE bigint; COMMIT; I can then apply this diff to an existing Version 7 schema, and I will have a Version 8 database. >From what I understand SqlWorkbench can do this for Postgres and Oracle, but not for Derby(?). I would be delighted to find out that SqlWorkbench can create diffs for Derby :-()) ! Thanks for your interest, -Damian