Preferred approach to application installation

Database
Enthusiast

Preferred approach to application installation

Hi all,

I have an application, for which I must create an installation script. This installation script must:

1. Drop all database objects which are part of my application (if they exist)

2. Create all database objects which are part of my installation.

I have a .sql file per database object - e.g. 1 file per table, 1 file per view.

Could anyone tell me what the best tool for creating my installation script would be?

Many thanks,

Andrew.

2 REPLIES
Enthusiast

Re: Preferred approach to application installation

I'd suggest looking at using ant to execute these. There's a nice article on here somewhere that suggests how you would use ant to automate database tasks. It would allow you to define multiple steps and establish dependencies between the steps. It provides for variable replacement so you can parameterize parts of the scripts if needed.
Teradata Employee

Re: Preferred approach to application installation


The following is a link to an Article on the SQL Ant Wizard:

http://developer.teradata.com/tools/articles/sql-ant-wizard