New application and new database

  • (2 Pages)
  • +
  • 1
  • 2

22 Replies - 1907 Views - Last Post: 20 May 2016 - 12:36 PM Rate Topic: -----

#1 Zed McJack   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 17-March 16

New application and new database

Posted 17 March 2016 - 10:25 AM

Hi guys,

I have an old proven application I made in Visual FoxPro 8(Database is Fox's DBFs). It works nicely but the time has come to move on and build new application (Ill go for C#) that will allow me to work with more than one codepage(Fox's limitation). Some of the DBs I tried (mySQL) have UTF8 compliance and store data as I need.

The problematic part is the need to move from desktop only app to combined desktop and mobile app. My clients would prefer that apps remain desktop, and to only add mobile access layer to it, but I dont think its possible. From what I read Ill need to move DB to net and have both platforms access data there.
Cellica offers something similar to what I need but I dont like their approach where you have synchronization through theirs two apps, one on desktop and one on mobile.

I am open to all ideas, so speak up.

thanks

Z.

Is This A Good Question/Topic? 0
  • +

Replies To: New application and new database

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15268
  • View blog
  • Posts: 61,206
  • Joined: 12-June 08

Re: New application and new database

Posted 17 March 2016 - 10:27 AM

Quote

From what I read Ill need to move DB to net and have both platforms access data there.

This doesn't make sense. .NET is a framework and not a database.

What you can do is move your data to a MSSQL server and have both the desktop and mobile app interact with the data contained inside. The .NET app would use the general namespaces while the mobile app can use a webservice hosted on your end.
Was This Post Helpful? 0
  • +
  • -

#3 Zed McJack   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 17-March 16

Re: New application and new database

Posted 17 March 2016 - 10:44 AM

I thought net stands as short for internet, but my English probably sucks, sorry.
I think your advice is in the same direction, right?
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15268
  • View blog
  • Posts: 61,206
  • Joined: 12-June 08

Re: New application and new database

Posted 17 March 2016 - 10:47 AM

Maybe I misunderstood and took 'net' and c# as the '.NET framework'.

Then yes.. have a database server - MSSQL server for instance - and both a desktop app and mobile app (via a webservice ) can connect to it.
Was This Post Helpful? 0
  • +
  • -

#5 Zed McJack   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 17-March 16

Re: New application and new database

Posted 17 March 2016 - 10:51 AM

Thanks for suggestion, it is an option, but Id like to know is there any other option?
Was This Post Helpful? 0
  • +
  • -

#6 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15268
  • View blog
  • Posts: 61,206
  • Joined: 12-June 08

Re: New application and new database

Posted 17 March 2016 - 11:05 AM

I am confused - what other option do you think is out there?
Was This Post Helpful? 0
  • +
  • -

#7 Zed McJack   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 17-March 16

Re: New application and new database

Posted 17 March 2016 - 11:16 AM

As I said Cellica has an option where they use their applications on desktop and mobile to synchronize databases.
If they can do it why someone else couldnt do the same?
I mean if I buy their app I could leave the Fox app as is, and only make an mobile app, but as I stated in the first post I have requirement to support more codepages(beside other reqs) so Id go for total rewrite.
Was This Post Helpful? 0
  • +
  • -

#8 Curtis Rutland   User is offline

  • (╯□)╯︵ (~ .o.)~
  • member icon


Reputation: 5106
  • View blog
  • Posts: 9,283
  • Joined: 08-June 10

Re: New application and new database

Posted 17 March 2016 - 11:18 AM

Why should you do the same? Do you need a local database for your mobile app that would have to be synced with the server, or is your mobile app going to be internet-connected? If so, there's no need to do that, because you can expose a RESTful API into your DB, and not need a local one for your app. You can use the same database.

Unless you do need a local database. If each user needs their own database, then you'll have to come up with some way of synchronizing their data from their desktop to their app.

But if you can use a central DB server, you only have to manage a DB, and web services.
Was This Post Helpful? 0
  • +
  • -

#9 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15268
  • View blog
  • Posts: 61,206
  • Joined: 12-June 08

Re: New application and new database

Posted 17 March 2016 - 11:19 AM

That seems to be doing the same thing.. single server two connection options.
Was This Post Helpful? 0
  • +
  • -

#10 Zed McJack   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 17-March 16

Re: New application and new database

Posted 17 March 2016 - 11:34 AM

Let me explain a bit more my app.

It is a lawyers application that does all the things law office needs, except when lawyer goes out of the office they can only guess their schedule, fin data, etc, without having access to desktop app. With mobile part they can synchronize data before leaving office and have all of it with them. And its not one man shop so they wouldnt need to have data of other lawyers.

Logically web application is the solution, but they insist on using desktop version, not web.
Was This Post Helpful? 0
  • +
  • -

#11 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15268
  • View blog
  • Posts: 61,206
  • Joined: 12-June 08

Re: New application and new database

Posted 17 March 2016 - 11:48 AM

What is their current calendar like? Office, Citrix, etc all have phone sync.
Was This Post Helpful? 0
  • +
  • -

#12 Zed McJack   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 17-March 16

Re: New application and new database

Posted 17 March 2016 - 11:57 AM

Calendaring is within the Fox as is the rest, I do export schedule to Gmail calendar but its too much work for them to use.
Was This Post Helpful? 0
  • +
  • -

#13 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15268
  • View blog
  • Posts: 61,206
  • Joined: 12-June 08

Re: New application and new database

Posted 17 March 2016 - 12:08 PM

So you have a custom calendar solution in FoxPro for a legal office.. not in any of the Outlook, google, or other small business sets that would provide this as well as a host of other benefits?

I would advocate you rethink your plan of porting some old calendar app to: a new app, a mobile app, and a new database server. It is a perfect time to make a bid for that transition.
Was This Post Helpful? 0
  • +
  • -

#14 Zed McJack   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 17-March 16

Re: New application and new database

Posted 17 March 2016 - 12:17 PM

I might be unaware of it but how I can integrate Google calendaring in my office app? I mean its all intertwined the date/time, venue, customer, lawyer all can change in a single moment. Google will move the event from one account to another and change the underlying data in the app?
Was This Post Helpful? 0
  • +
  • -

#15 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15268
  • View blog
  • Posts: 61,206
  • Joined: 12-June 08

Re: New application and new database

Posted 17 March 2016 - 12:26 PM

I haven no idea what your app does or tracks outside of calendar dates, but you can certainly review the Gmail for business/outlook for business/etc products out there.
Was This Post Helpful? 0
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2