Migration of DB from .ran , how can I do it?


Anita Aug 18 2017, 11:05 AM
I require to perform data analysis with graphical analyzers like lumira, tableau or qlikview.

none of those supports access to .ran format is it possible to migrate .ran to some othe conventional database?
Stephane Grenier | email Aug 18 2017, 04:16 PM
Hi Anita,

Although the software uses an SQL database you cannot just transfer it from database engine to another. In many cases transferring from one engine to another requires manual intervention because there are subtle difference between the different database engine. In other words no matter what database engine you use it's often not as easy as just opening a database file in another software, you often have to take additional steps and perform some kinds of operations to convert from database engine to another.

In other words no this is not possible.

Regards,
Stephan Grenier
Founder
LandlordMax Software Inc.
http://www.LandlordMax.com
http://www.FollowSteph.com
Anita Aug 24 2017, 11:05 PM
Hi Stephane ,

Hmm so there is no way I can see and query my database with landlordmax directly.
What database engine are you using with landlordmax?

Stephane Grenier | email Aug 25 2017, 12:24 AM
Hi Anita,

That's correct, you do not have direct access to the database. That being said the database itself is encrypted and password protected for security reasons, otherwise any security measures in the software would be useless.

To be quite honest you won't find a property management software solution anywhere near our price range that will give you direct database access, for that you're easily going to need to spend many times our offerings, even our highest tiered offering. And even then it will most likely require consulting services to understand the database schema, etc., which means you're costs are going to be a whole other level that we don't offer.

That being said the software uses Apache Derby for the database engine: https://db.apache.org/derby/

Regards,
Stephan Grenier
Founder
LandlordMax Software Inc.
http://www.LandlordMax.com
http://www.FollowSteph.com
isaac | email Aug 31 2017, 10:46 AM
Hey Stephan,

I colleague of mine formatted my computer before backing up the database! Thankfully we were able to recover the landlordmax data but we are not able to restore... it is end month and We are fearing that we have to go back manual billing! Can you help? Something about can't have more than one instance.... is this the derby error?

And yes i agree, its the best so far outside there at this price! I recommended to most upcoming builders and future property managers at a small builders/property managers conference here in Kenya. You are the best!

Please assist me!

Thanks

Isaac
Stephane Grenier | email Aug 31 2017, 06:01 PM
Hi Isaac,

Thank you for the positive comments and referrals about the software, they are truly appreciated.

In regards to your question can you please expand what you mean when you say you were able to recover it? Exactly what does this mean? I ask because it will help in determining if you actually have a proper recovery or only a fraction.

That being said can you also please confirm that you're using the latest version 11.05q. I ask because over time we've added more and more auto-corrections to the database, that is to say that as time passes we add more ability for the software to be able to recover from corrupted databases depending on the type and extent of the corruption. If you're using an older version then I would first recommend upgrading to the latest version.

Regards,
Stephan Grenier
Founder
LandlordMax Software Inc.
http://www.LandlordMax.com
http://www.FollowSteph.com


This topic is closed