[FX.php List] Back on the trail of automating database management

[Steve Winter]

Hi all,

I've floated versions of this concept up in the past, but I'm back in  
need of a way to automate the creation of a new table in 50+ instances  
of a database solution which I develop and manage for a client...

What I want to be able to do is to create a new table, complete with  
field definitions through a script called via FX....

This seems like something of a tall order, and to date has proved  
impossible... I looked at importing a table from a 'master' database,  
but FM won't allow the file or the table to be passed as parameters  
(or even set in globals) for the script...

Recently I was looking at the XML import function and that looks very  
promising because I can tell the script to look for an XML file on my  
server called 'newTable.xml' (for example) and then modify that...  
everything along that line works really well except that the table  
ends up called 'XML import from http'. NOT very user-friendly...

So, does anyone have any clue as to how I set the table name through  
and XML import...? or any other ideas on how I can go about making  
structural changes to databases using scripts...? (the desire to do  
this grows the more this solution is implemented, the more features  
are added, and the more I work with MySQL where you can define  
everything about the database through php ;-)

Thanks for any thoughts...

Cheers
Steve


Steve Winter
steve at bluecrocodile.co.nz
m: +44 77 7852 4776
3 Calshot Court, Channel Way
Ocean Village, Southampton SO14 3GR

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20090619/ec18ee22/attachment.html