This has happened to me more than once, I'm wondering how everyone else
handles it.
An application is needed, the database is designed, the application is
built debugged, and rolled out.
Time passes, things change, and the original application no longer meets
the needs of the growing company. Someone is hired (possibly even the same
developer who did the original application) to modify the application. The
database table structure has to be re-worked.
I doubt that this situation is unique to projects I have worked on. The
question is, how do you go about migrating data from the old structure to
the new structure? Are their third party tools for this purpose? Or do
ya'll tend to write your own migration code (and in what language?)?
In some cases I have been able to use the SQL Server DTS to transfer data.
In other cases I have written ColdFusion code for this purpose.
As an example from one project I'm currently working on:
The application was built around a bunch of different companies, and
everything in the app is based on the companyID.
This was the company table: (CompanyID, CompanyName, address, city,
state, zip, url)
However, 2 years down the line (today), this has become a bit
problematic. Now they want to modify the application so that a single
company can have multiple locations, and everything is based around the
location. So, now we are splitting up the company table into two tables:
Company (companyID, companyname, url)
CompanyLocation (companylocationID, companyID, address, city, state, zip)
How would you migrate the company information from the old structure to
the other, while still preserving the relevant relationships between data?
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
Due out June 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
I've been vindicated, I've been loved and hated
I've been pulled aside and told that I was overrated
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
