Menu
▾
▴
Re: [Mifos-users] Data Migration Approach-- a question
|
From: Nayan A. <nay...@gm...> - 2010-04-15 02:20:43
|
Thanks Krishnan,
1) My understanding for a tool is that it will be generic enough...such that
given (access to) FIMO database for a particular version(s) and MIFOS for
some version(s), it is capable to then migrate data. Perhaps the included
.sql is a sample outcome from the tool. Is that right? Can you please
clarify...
Ans: For time being outcome is insert script, once it is completed it will
have connection with MySQL and directly migrate the data.
script is just for my working convenience!
2) Hopefully, the data in the .sql was scrubbed and does not have any
business-sensitive information...this list may not be the best place for it.
Ans : :)
Thanks
Nayan GA
"beyond profit"
On Wed, Apr 14, 2010 at 10:35 PM, Krishnan M <km...@ya...> wrote:
> Hi Nayan,
>
> This is a good initiative...just a couple of quick thoughts and
> questions...i have glanced at the attached zip files, but will go back and
> look at it in more detail later.
>
> 1) My understanding for a tool is that it will be generic enough...such
> that given (access to) FIMO database for a particular version(s) and MIFOS
> for some version(s), it is capable to then migrate data. Perhaps the
> included .sql is a sample outcome from the tool. Is that right? Can you
> please clarify...
>
> 2) Hopefully, the data in the .sql was scrubbed and does not have any
> business-sensitive information...this list may not be the best place for it.
>
> thanks again until later...
>
> regards,
> krishnan mani
>
> --- On *Wed, 14/4/10, Nayan Ambali <nay...@gm...>* wrote:
>
>
> From: Nayan Ambali <nay...@gm...>
>
> Subject: Re: [Mifos-users] Data Migration Approach-- a question
> To: "A good place to start for users or folks new to Mifos." <
> mif...@li...>
> Cc: "Niranjan Sheelavant" <nir...@ni...>, "vishwasbabu" <
> vis...@gm...>, "Ashok" <ash...@gm...>
> Date: Wednesday, 14 April, 2010, 7:06 AM
>
>
> HI All,
>
> I am working on MS Access based tool for FIMO to MIFOS migration.
> It is in WIP( Work In Progress state)
> but can migrate Employees, Centers , Groups , Members and Loan Disbursed to
> client
>
>
> Need to do loan re-payed, dues etc with some know issues and some
> enhancements
> Hopefully this will be done by this week.
>
> I would appreciate if you guys look into the tool let me know your feedback
>
> MG_Script.zip is sample O/p scripts
>
> Thanks
> Nayan GA
> "beyond profit"
>
>
>
> On Wed, Apr 7, 2010 at 2:29 AM, Emily Tucker <
> ET...@gr...<http://in.mc951.mail.yahoo.com/mc/compose?to=...@gr...>
> > wrote:
>
>> Hi Folks,
>>
>>
>>
>> Partha and Chandan, at SunGard, are working with us to develop a data
>> migration tool for Mifos. Below is a quick high level overview on their
>> approach, and then a question.
>>
>
>
> High level overview (I’m not technical, so apologies to SunGard if I miss
> some technical nuances):
>
> SunGard is developing a simplified data model into which data from other
> systems (legacy systems, excel spreadsheets, etc) can be migrated. They
> will then build migration scripts that will port data from this interim
> database into Mifos (these scripts will be replaced by APIs once Mifos has
> those available). The idea is that the work to migrate data from the
> interim database into Mifos only has to be done once. The work from the
> MFIs data sources into the interim database will need to happen every time
> (unless we’re doing multiple migrations from the same legacy system)—but it
> will be a much easier task since the interim database will be much simpler
> than the Mifos database.
>
>
>
> Approach:
> SunGard is assuming that they will do a *complete* migration of all data
> from the interim database into Mifos—including things that would be quite
> easy to manually type into Mifos—ie, offices, users, products, etc.
> Basically all configuration items would be stored in the interim database
> and migrated over.
>
>
>
> My Question:
> What do people think of this approach? I had always assumed that we (the
> deployment team working at the customer site) would first configure Mifos
> and manually enter entities like offices and that the migration would be
> limited only to the entities that can’t be handled by manual entry (ie,
> centers, groups, clients and accounts). Not sure why I assumed that—I
> suppose because I didn’t see the need to build migration scripts for items
> that can easily be manually entered. Besides the general concern, I have
> two specific questions:
>
>
>
> (*) Will this approach make it difficult to accommodate changes at the MFI
> during the data migration process. Ie, if the MFI adds a new user during
> the migration process—they can’t add it directly into Mifos—they need to
> communicate back to the data migration team to make a new entry, right?
> Will this cause a lot of churn?
>
> (*) How will this approach handle doing a staged roll-out, where they’re
> migrating a few branches at a time?
>
>
>
> Partha: Any comments on this?
>
>
>
> Ryan: especially interested in your take. J
>
>
>
> Emily
>
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Mifos-users mailing list
> Mif...@li...<http://in.mc951.mail.yahoo.com/mc/compose?to=...@li...>
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
>
>
> --
> Regards
> Nayan G. A.
> 9901154134
>
>
> -----Inline Attachment Follows-----
>
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
>
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
>
> -----Inline Attachment Follows-----
>
>
> _______________________________________________
> Mifos-users mailing list
> Mif...@li...<http://in.mc951.mail.yahoo.com/mc/compose?to=...@li...>
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
> Send free SMS to your Friends on Mobile from your Yahoo! Messenger.
> Download Now! http://messenger.yahoo.com/download.php
>
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Mifos-users mailing list
> Mif...@li...
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
--
Regards
Nayan G. A.
9901154134
|
