Hello to all on the list. I am in the process of writing an application to update a program I have written that is coming out on the market shortly. The update will be delivered via the Internet. It is broken down into two major parts, i) update the exe file based on version numbers and ii) update the Firebird database structure. It is the second part that got me thinking, I can use a difference script to update the database structure. But I would like to write a program that would compare the structure of the application database and a reference database and update the application database based on the differences. I see that Clever components have a Delphi VCL component that does just this but I wonder how easy or hard would it be to write a program to do just this. The application depends heavily on stored procedures for the business logic. One of the complexities will be the source for stored procedures and triggers is encrypted so that prying eyes cannot easily see the coding logic (I know this is not fool proof but good enough). During the comparison process these can be decrypted and then encrypted again later on. How would I go about writing a program to update a database from a reference database.
1. For domains I could query the rdb$domains table. 2. Similarly tor triggers and stored procedures I could do a similar thing. 3. But what about tables, columns, constraints and domains? 4. Views, UDF's etc. Any ideas as to the best way to go about this? I think this would also be a good project to open source. I am thinking I would write the application in Delphi but once the algorithm is figured out it could be ported to any language that can connect to a Firebird database. Any thoughts are welcome. Thomas Clarke Cyber Sea Incorporated #6 Kingston Terrace Flint Hall St. Michael Barbados BB11070 voice: (246) 234-9692 email: tcla...@cybersea.biz web: http://cybersea.biz [Non-text portions of this message have been removed]