Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 62745 invoked from network); 28 Apr 2006 03:03:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 28 Apr 2006 03:03:22 -0000 Received: (qmail 36703 invoked by uid 500); 28 Apr 2006 03:03:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 36481 invoked by uid 500); 28 Apr 2006 03:03:20 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 36472 invoked by uid 99); 28 Apr 2006 03:03:20 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Apr 2006 20:03:20 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of jta@bristowhill.com designates 66.75.162.134 as permitted sender) Received: from [66.75.162.134] (HELO ms-smtp-02.socal.rr.com) (66.75.162.134) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Apr 2006 20:03:18 -0700 Received: from [192.168.15.53] (cpe-204-210-23-212.san.res.rr.com [204.210.23.212]) by ms-smtp-02.socal.rr.com (8.13.6/8.13.6) with ESMTP id k3S32utA004390 for ; Thu, 27 Apr 2006 20:02:57 -0700 (PDT) Message-ID: <445185D2.4000406@bristowhill.com> Date: Thu, 27 Apr 2006 20:02:42 -0700 From: "Jean T. Anderson" Reply-To: jta@bristowhill.com User-Agent: Mozilla Thunderbird 1.0.7-1.1.fc3 (X11/20050929) X-Accept-Language: en-us, en MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: Porting Derby Database files between machines References: In-Reply-To: X-Enigmail-Version: 0.93.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Geoff Powdrell wrote: > Hi, > I would like to know if the derby database files can be moved between machines. That when you create a derby database that there is no registry settings made or machine specific settings applied to that machine. > > For example : > If I have a database which I connect to via the url 'jdbc:derby:testdb' I have a directory and subdirectory as follows: > > testdb > db.lck > service.properties > log(DIR) > log.crtl > log1.data > logmirror.ctrl > seg0(DIR) > c*.dat files > tmp(DIR) > (empty dir) ... Derby database files are platform-independent and can be copied between machines. This isn't documented yet, but there is a Jira issue for it at http://issues.apache.org/jira/browse/DERBY-711 . In the case you've given, be sure to copy the entire 'testdb' database hierarchy. regards, -jean