> If you want to access the same database as the application, you need
> more than just a hosting service -- you need a developer to completely
[quoted text clipped - 32 lines]
>
> - Show quoted text -
I'm the "lucky guy" who has to initially port the application to the
web.
The issue is that the client wishes to use the same physical files
between the two situations (so that nightly physical file backups from
the web can be verified within the old desktop application) in the
early stages of transition to a SOA.
And no, in their "wisdom", they do not want to send the data back from
the web to the company using a webservice approach for verification,
at least not initially.
Otherwise we would just port the existing database structure to Oracle
or MsSql or MySql and write to that from the very start and not deal
with the issue of finding a PSQL hosting entity (which was my original
response to the client).
HTH. Thanks!
BtrieveBill - 21 Aug 2008 13:51 GMT
>> If you want to access the same database as the application, you need
>> more than just a hosting service -- you need a developer to completely
[quoted text clipped - 47 lines]
>
> HTH. Thanks!
Ouch. Given that directive, the "best" solution would be to put in an
INTERNAL web server in front of the firewall, with a single hole poked
through it for PSQL access (TCP Port 1583 between the two computers).
You can then do all of your web development locally on the web server
there, first.
The advantage here is that initial costs are low, especially during
application development. You can leverage easy access to the production
data, and you can easily build a test database area on the same
Pervasive database for your initial development efforts for testing
database updates and such. Obviously, the dev process will take some
time, so it will be much easier with the DB in house.
Once the new app dev project is finished (OK, so programs are never
finished, just abandoned), then you can migrate it to an off-site
hosting facility if you really need to. You probably won't find one
that supports native PSQL access, so you'll either need a co-lo facility
or one that at least gives you a dedicated (probably virtual) machine
onto which you can install PSQL.
Personally, my own recommendation would be to simply add the
Internet/Intranet license for your web users to the database engine and
keep everything in-house. The cost of the extra bandwidth will be far
less than any co-lo-fac, although attaining a given SLA might be more
costly if they need guaranteed uptime.
BB