There is a situation that I encounter & I wonder how others handle it
It is fairly common (almost a given), that a new client will have some
or all of his data available in offline MS-Access databases.
It is usually necessary to manipulate this data (validate, normalize,
etc) to convert it into a usable online database (storing it in a more
robust RDBMS).
I have found that CF is an excellent tool for this.
I normally just upload the MS-Access mdb file to the hosting service.
Then I write CF programs that convert the data from MS-Access to, say
SQL-Server, or Oracle.
No problem, as long as the host service is running on a windows
platform -- MS-Access is usually supported.
But what happens if the Host uses a non-windows platform?
How do you read a MS-Access database on, say a Linux Box.
I guess you could capture the Access database into SQL-Server,
offline, if you had:
1) a windows machine
2) MSDE or SQL-Server
3) MS-Office
This extra step gives you a mirror of the client's MS-Access db on
SQL-Server -- you still need to manipulate it for validation,
normalization, conversion to online, etc.
What do you do if you need to go to some other (not SQL-Server) RDBMS,
that doesn't have the ability to capture Access databases?
The problem gets compounded if the client requests periodic creation of
an offline copy of the online database
-- for offline analysis, etc.
Is this an issue that any of you run into with any frequency?
How do you handle it?
(Of course the easy out is just host on windows platforms that support
Ms-Access -- but that is totall the wrong reason to make a hosting
decision).
TIA
Dick
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
