k, thanks .....

----- Original Message ----
From: paul.mercea <[EMAIL PROTECTED]>
To: For users and developers of the Firebird .NET providers <[email protected]>
Sent: Monday, November 6, 2006 8:59:45 AM
Subject: Re: [Firebird-net-provider] Create or update a table

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

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 !!!

-------------------------------------------------------------------------
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


-------------------------------------------------------------------------
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


-------------------------------------------------------------------------
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

Reply via email to