Migrating from Access to Webservice - Is it possible/reasonable?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray Price - 09 Sep 2005 13:04 GMT

I'm starting an initial proof of concept for tracking maintenance work in a
datacenter. At some point we will have an Oracle database upon which to base
our Infopath forms. In the near term, I'm thinking that the shortest path to
getting something usable (for 5 - 10 users) is to base my forms off of MS
Access. Once the Oracle database is available, is it feasible to migrate the
MS Access based forms to a web service sitting in front of the Oracle DB?

My other option is to use Sharepoint as the Forms repository and then
migrate from there.

Or, I guess I can just rebuild the whole shootin-match.

Thanks.

Reply to this Message

Franck Dauché - 09 Sep 2005 14:49 GMT

Hi Ray,

Yes it is. To make sure that you don't have to modify your IP form when
that happens, you can build a Web Service now to link to your Access DB.
That way, when you switch to Oracle, a simple Web Service update will do the
trick.

Franck Dauché

> I'm starting an initial proof of concept for tracking maintenance work in a
> datacenter. At some point we will have an Oracle database upon which to base
[quoted text clipped - 9 lines]
>
> Thanks.

Reply to this Message