Hi, The only utility I know about that does this kind of thing is mysqldiff which can be found at:
http://freshmeat.net/projects/mysqldiff/ I haven't used it myself but it comes quite highly rated on freshmeat.net A quote from it's description: "mysqldiff is a Perl script which compares the data structures (i.e. table definitions) of two MySQL databases and returns the differences as a sequence of MySQL commands suitable for piping into mysql which will transform the structure of the first database to be identical to that of the second (c.f. diff and patch). Database structures can be compared whether they are files containing table definitions or existing databases, local or remote." Hope it's what you're looking for.. Cheers, Andrew -----Original Message----- From: Pointer [mailto:[EMAIL PROTECTED] Sent: Saturday 20 March 2004 10:28 To: [EMAIL PROTECTED] Subject: Batch table structure update tool Hi I'm looking for a tool (program, library), which given a file describing the structure of the tables in a database, could update the structure of those tables, i.e. create new table, add fields and change field size. Such a tool (especially as a dll library) would be very useful because is would simplify the proces of deployment the new version of an application. Each version would have a description of its tables and would update the structure of the clients database in order to fulfill the requirements of the new version. I'm looking for a solution, which is as non-interactive as possible, just because each activity made by user is a threat that he/she would do something wrong :). Thank You &John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
