Hello:
Is there a way to deploy the applications with the database included?.What I mean is, I’ve created a closed product with scriptcase, and i would like it to be installed in my customers environtment without the need of creating all the Database manually. is there a way to include it in the deployment package so when the applications gets deployed and the connections is customized the database gets created?.
Regards
That is not build in by standard, but you can fairly easily make a creation script from your databases (specially if it is oracle or mysql or even sqlite). Since you still need the database connection name and the setup on the sql server and so on you’ll still have hand work to do.
See for example:
Mysql: http://stackoverflow.com/questions/11739014/how-to-generate-a-create-table-script-for-an-existing-table-in-phpmyadmin
sqlserver: http://stackoverflow.com/questions/11319334/show-create-commands-for-table-in-sql-management-studio-2008
oracle: http://stackoverflow.com/questions/937398/how-to-get-oracle-create-table-statement-in-sqlplus
sqlite: http://www.sqlite.org/cli.html
etc… jist search for: show create table and you will find enough script to handle that. All you then need to do is run the script and catch any errors.
Of course there is an order in the table creation if you use referential integrity, then it gets tricky. You’d have to create the table and set the foreign keys only after all tables are created.