You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Hari Haran <ha...@habile.in> on 2018/03/01 14:50:02 UTC
Clean Mifos DB
Team,
I want to clean test data from my Mifos DB. Is there any script available
for the same?
--
------------------------------
Regards,
Hariharan.G
Technical Consultant | Habile Technologies
www.habiletechnologies.com | (O): +91 44 4202 0550 | (M): + 91 90030 25156
Skype: hari.mitteam | https://www.facebook.com/HabileTechnologies
<https://www.facebook.com/HabileTechnologies>
------------------------------
DISCLAIMER:
All emails and any files transmitted with them are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received an email in error please notify your system
manager. The message in the email you have received contains confidential
information and is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy the
email. Please notify the sender immediately by email if you have received
an email by mistake and delete the email from your system. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of the
information is strictly prohibited.
Re: Clean Mifos DB
Posted by Sampath Kumar G <sa...@confluxtechnologies.com>.
Hi Hari,
Do you want to remove only the partial data or all the data from the
database?
If only partially data, then as per my knowledge there is no script and
also, if you do so then in future it might cause data integrity issue as
there will be mismatch between portfolio command source and other tables.
If you want to delete all the data, then drop the existing database and
create a empty database with same name of previous database and start the
tomcat. Mifos will migrate the empty table.
On Mar 1, 2018 8:20 PM, "Hari Haran" <ha...@habile.in> wrote:
> Team,
>
> I want to clean test data from my Mifos DB. Is there any script available
> for the same?
>
> --
>
>
> ------------------------------
> Regards,
> Hariharan.G
> Technical Consultant | Habile Technologies
> www.habiletechnologies.com | (O): +91 44 4202 0550 | (M): + 91 90030 25156
> Skype: hari.mitteam | https://www.facebook.com/HabileTechnologies
> <https://www.facebook.com/HabileTechnologies>
>
> ------------------------------
> DISCLAIMER:
> All emails and any files transmitted with them are confidential and
> intended solely for the use of the individual or entity to whom they are
> addressed. If you have received an email in error please notify your system
> manager. The message in the email you have received contains confidential
> information and is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy the
> email. Please notify the sender immediately by email if you have received
> an email by mistake and delete the email from your system. If you are not
> the intended recipient you are notified that disclosing, copying,
> distributing or taking any action in reliance on the contents of the
> information is strictly prohibited.
>
Re: Clean Mifos DB
Posted by Sampath Kumar G <sa...@confluxtechnologies.com>.
Hi Hari,
Do you want to remove only the partial data or all the data from the
database?
If only partially data, then as per my knowledge there is no script and
also, if you do so then in future it might cause data integrity issue as
there will be mismatch between portfolio command source and other tables.
If you want to delete all the data, then drop the existing database and
create a empty database with same name of previous database and start the
tomcat. Mifos will migrate the empty table.
On Mar 1, 2018 8:20 PM, "Hari Haran" <ha...@habile.in> wrote:
> Team,
>
> I want to clean test data from my Mifos DB. Is there any script available
> for the same?
>
> --
>
>
> ------------------------------
> Regards,
> Hariharan.G
> Technical Consultant | Habile Technologies
> www.habiletechnologies.com | (O): +91 44 4202 0550 | (M): + 91 90030 25156
> Skype: hari.mitteam | https://www.facebook.com/HabileTechnologies
> <https://www.facebook.com/HabileTechnologies>
>
> ------------------------------
> DISCLAIMER:
> All emails and any files transmitted with them are confidential and
> intended solely for the use of the individual or entity to whom they are
> addressed. If you have received an email in error please notify your system
> manager. The message in the email you have received contains confidential
> information and is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy the
> email. Please notify the sender immediately by email if you have received
> an email by mistake and delete the email from your system. If you are not
> the intended recipient you are notified that disclosing, copying,
> distributing or taking any action in reliance on the contents of the
> information is strictly prohibited.
>