Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 36E5D200BCE for ; Fri, 18 Nov 2016 06:49:10 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 35959160B0F; Fri, 18 Nov 2016 05:49:10 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 7F18A160B0B for ; Fri, 18 Nov 2016 06:49:09 +0100 (CET) Received: (qmail 63622 invoked by uid 500); 18 Nov 2016 05:49:08 -0000 Mailing-List: contact dev-help@fineract.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@fineract.incubator.apache.org Delivered-To: mailing list dev@fineract.incubator.apache.org Received: (qmail 63606 invoked by uid 99); 18 Nov 2016 05:49:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Nov 2016 05:49:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 7C38F180BBA for ; Fri, 18 Nov 2016 05:49:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.78 X-Spam-Level: * X-Spam-Status: No, score=1.78 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=confluxtechnologies-com.20150623.gappssmtp.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id novk6i5bps-q for ; Fri, 18 Nov 2016 05:49:05 +0000 (UTC) Received: from mail-qt0-f181.google.com (mail-qt0-f181.google.com [209.85.216.181]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 418F35FCB4 for ; Fri, 18 Nov 2016 05:49:04 +0000 (UTC) Received: by mail-qt0-f181.google.com with SMTP id c47so150351955qtc.2 for ; Thu, 17 Nov 2016 21:49:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=confluxtechnologies-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=NXCcP/TD8rzePBBY+gwJYQht85OeVGZbcEf6xl6IYfg=; b=i7znU9kdHxt6wKzGAmUb68gRcLINhRDFqDmmuj9cBQB21llYIJV7MBpepNKnxjyg2P t2OvAYoWNhW3hbRJAknOeGFVU0LmSf2dHYLHsjqICZJbk9WSAqA1e6E4x1PQF3Yf1Tu7 Bmpp/keNYgC2qInrKAISoA0ZASLya+vQKcjeEErXql2XOaxuQIDLHaXogLqqiCrAknv/ bFH2/dZuMrQS23u72GOoeMZIMDbL0hKQI4XtV03Qfn2lDHsxb31luyLShdX4JmSfI9W6 qv519yG4gSCsECcgbg+Mtr3gl2Kg9aS7sCNlG8AGd/XsTHvo06ti3pPPa+Zc2ZXeQC8x zIIg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=NXCcP/TD8rzePBBY+gwJYQht85OeVGZbcEf6xl6IYfg=; b=JrSBvcPsfJVUA2d2mxz2iNhJtyd/8gcfvOVvpgHSv8LnsQhZFxZBCPfJsMKHyAIEbG OT2sNeUgzsO8WUiOjYtOh4XaBCBRdRT4RrzqzoAW8ye/fJEb4zUmT5sLT0wiX9PJv5iP Rvzneu3KyS0+mwrdsHdmBvT6FHZig3t7toRL/qtdXyXkWqyCepf83E8JEn8eCWPGizH+ fvH62BJr+xBosSPcI1K68YGpCLMq8T/zFw6YYkZX35Ae92U3tRHe0r5RM1RJ+VrX7cbd ONjn1HXRKsJSvIrUlx6yHCae6cjHw/g6s6NYRCUb4wHZH8Khj/O3aIn9rL7effUavZ+2 8IgQ== X-Gm-Message-State: AKaTC03LX1PVBE+g4ywA+XfWuR5svfnYXqEgEWsDi73ttlSVJ/S72DuKoYc3i7qeFzF96A9cY2pCroFYm1u1rA== X-Received: by 10.237.33.173 with SMTP id l42mr5063092qtc.271.1479448140964; Thu, 17 Nov 2016 21:49:00 -0800 (PST) MIME-Version: 1.0 Received: by 10.237.52.3 with HTTP; Thu, 17 Nov 2016 21:49:00 -0800 (PST) X-Originating-IP: [106.51.138.101] In-Reply-To: References: From: Shreyaank Byadagi Date: Fri, 18 Nov 2016 11:19:00 +0530 Message-ID: Subject: Re: [Mifos-developer] Mifos upgrade (Multi tenant env) and how to handle schema changes (if any) To: Mifos software development Cc: "dev (dev@fineract.incubator.apache.org)" Content-Type: multipart/alternative; boundary=001a113e46fee7f95005418cdc4c archived-at: Fri, 18 Nov 2016 05:49:10 -0000 --001a113e46fee7f95005418cdc4c Content-Type: text/plain; charset=UTF-8 Hello Thynn, Yes the migration scripts are added upon restarting the tomcat server and changes will be applied to all the tenants. New releases will have new schema migration script(s) if there is a change in the DB schema. You can view this link for upgrading: https://mifosforge.jira.com/wiki/display/docs/Up-gradation+of+Mifos+X+on+windows Regards Shreyaank Sent with Mailtrack On Thu, Nov 17, 2016 at 7:17 AM, Thynn Win wrote: > Hi all, > > We are planning to upgrade from 16.03.03 to 16.09.01 (windows env). We > would like to know if the upgrade scripts are run at the re-start of tomcat > server and will the data structure changes be applied to all tenant > databases? Suppose we have 5 tenants using the same application server but > a different database server for their tenant databases. We understand the > application will be upgraded with new war files but would like to know - > > 1) whether the data structure (dll statements) changes will be applied to > all tenants also > > 2) how to find out which release has database changes and which not. This > way, we can pay attention to which release has structure changes and also > verify them after the upgrade. > > For instance: We see that 16.08.01 has a feature for capturing client > address and we assume it will have some database structure changes. > > If you could provide us advise or directions on how the upgrade generally > work in multi-tenant environment and how we can verify the changes, we > would appreciate it. > > Thank you, > Thynn > > > > ------------------------------------------------------------ > ------------------ > > Mifos-developer mailing list > mifos-developer@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > -- Thanks and Regards Shreyaank E-mail:shreyaank@confluxtechnologies.com --001a113e46fee7f95005418cdc4c--