| Subject | Re: How to update table structure with SQL? |
|---|---|
| Author | neighbour.kerry |
| Post date | 2009-06-23T04:04:44Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
The problem is I do not have the customer's database. I have no idea what version they have either, since Firebird does not contain version information. I also use a few databases here - production, testing, etc. I cannot generate this difference script against all these databases.
The idea is run a script to update ANY database to the current version, no matter what the customer has.
I can do it if I know a certain object exists - ie can I check if a table or column exists in SQL?
Could I do something in a Procedure perhaps?
>Still not possible, but it sounds like something to look at. If I can see what script they generate, it might be useful.
> > > the standard approach offered by many admin tools is a database
> > structure comparison tool where the result is a script which updates
> > your target database.
> > > These tools exist for all major databases.
The problem is I do not have the customer's database. I have no idea what version they have either, since Firebird does not contain version information. I also use a few databases here - production, testing, etc. I cannot generate this difference script against all these databases.
The idea is run a script to update ANY database to the current version, no matter what the customer has.
I can do it if I know a certain object exists - ie can I check if a table or column exists in SQL?
Could I do something in a Procedure perhaps?