Announcement

Collapse
No announcement yet.

Include the DataBase creation in the deployment

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Include the DataBase creation in the deployment

    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

  • #2
    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/1...-in-phpmyadmin
    sqlserver: http://stackoverflow.com/questions/1...nt-studio-2008
    oracle: http://stackoverflow.com/questions/9...ent-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.

    Comment

    Working...
    X