Hi!
I'm using mysql-win32 v. 3.22.26a as the main data source for an
internet map server.
The information in the databases are primarily updated through a bunch
of Delphi interfaces - and this works fine.
I have one table, though, that i'm having trouble finding a suitable
update method for...
The table is app. 25.000 records, and when it is to be updated, all the
data will have to be replaced.
The data originally comes from a local MS Access database.
What i have been doing up to now is to take down the map server, move
the table to a different name, then importing the data from MS Access
using ODBC. After this I alter the table manually by setting indexes,
"not-nulling" different fields etc.
Now - I'll be leaving this project pretty soon, and the update
procedure will be taken over by someone else. I'm trying to make it as
easy as possible to update the database, but I'm not sure that the
above procedure is the best in this case. I would like it a bit more
automated, I guess.
Does anyone have any ideas, advices etc. that could help me find the
best way to update this table?
Best Regards /Anders
--
Anders Engström
GIS-Centrum, Lund
0709-62 07 73
=============================
Your mind's like an umbrella.
It doesn't work unless you open it.
/Frank Zappa
