Hi
I use this scenario.
In database I have one table for Version. I put every
version in that table.If I deploy new version I have patch script (sql file with
all database modifications - if u use IBExpert u can set metadatachange log
file) and I run this patches.
For me works!
Regards,
Paul
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ionut Ichim
Sent: Sunday, November 05, 2006 6:43 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Create or update a table
Yes ... application will become complex and database structure too,if I'll update one user's application i have to update his databases structure too.
Thanks !
-----
Original Message ----
From: paul.mercea <[EMAIL PROTECTED]>
To: For users and developers of the Firebird .NET providers <[email protected]>
Sent: Sunday, November 5, 2006 5:32:24 PM
Subject: Re: [Firebird-net-provider] Create or update a table
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ionut Ichim
Sent: Saturday, November 04, 2006 11:47 PM
To: [email protected]
Subject: [Firebird-net-provider] Create or update a table
From: paul.mercea <[EMAIL PROTECTED]>
To: For users and developers of the Firebird .NET providers <[email protected]>
Sent: Sunday, November 5, 2006 5:32:24 PM
Subject: Re: [Firebird-net-provider] Create or update a table
Hi
Your intention is to have one version database and
'syncronize' this structure to other databases?
Regards,
Paul
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ionut Ichim
Sent: Saturday, November 04, 2006 11:47 PM
To: [email protected]
Subject: [Firebird-net-provider] Create or update a table
I
have a mask database, and some databases (Database2,Database3...),how can
i easly alter databases structure according with the mask database (Database1),
adding missing fields,etc.....
My idea is to use "For Each In" loops for tables and fields, it is a good idea or is something much easy,for example with stored procedure works fine "create or update procedure ..."
Database1 Database2 Database3
Filed1 Field1 Field1
Field2 Field2 Field2
Field3 Field3
Field4
Many thanks !!!
My idea is to use "For Each In" loops for tables and fields, it is a good idea or is something much easy,for example with stored procedure works fine "create or update procedure ..."
Database1 Database2 Database3
Filed1 Field1 Field1
Field2 Field2 Field2
Field3 Field3
Field4
Many thanks !!!
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
