create datasource on fly

[Urban1977]

Hi

I have a coldfusion application which I am using mySQL 5 database with. When I have a new client that wants to use the applicaton is there a way for me to create a new database / datasource on the fly using coldfusion and then copy files to a new folder on the web server.

like an auto install routine?

I have seen this done with php installers.

[JR__Bob__Dobbs-qSBHQ2]

You can add a data source programmatically using the administrator API.
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=basiconfig_37.html

[Dan_Bracuk]

Once you've done what Bob told you, you can run create table queries to build the database.

From a maintenance perspective, it would be simpler to have one db with a client table in their somewhere.