Subject | Re: [firebird-support] Re: How to update table structure with SQL? |
---|---|
Author | Adrian Wreyford |
Post date | 2009-06-23T11:20:13Z |
I've been following all your posts.
A small suggestion.
Write an app once off that connects to the customer DB (many different versions exist out there), then extract the metadata, and ask the customer to supply you with such extracted metadata by email etc.
Decide on your current baseline DB.
Use one of the tools, to compare to current DB, and then generate a script for each one of these customers.
Also remember to include a versioning table in your new version of the DB.
Now send each customer their own script to update their DB's to the current version.
This is a lot of work, but once only.
Now keep all your changes versioned, and it will be one script for all!
Just a thought.
Adrian
[Non-text portions of this message have been removed]
A small suggestion.
Write an app once off that connects to the customer DB (many different versions exist out there), then extract the metadata, and ask the customer to supply you with such extracted metadata by email etc.
Decide on your current baseline DB.
Use one of the tools, to compare to current DB, and then generate a script for each one of these customers.
Also remember to include a versioning table in your new version of the DB.
Now send each customer their own script to update their DB's to the current version.
This is a lot of work, but once only.
Now keep all your changes versioned, and it will be one script for all!
Just a thought.
Adrian
[Non-text portions of this message have been removed]