Re: DB Setup - Dump file versus SQL Loader

On 8 Giu, 08:37, AnGanesh <angan..._at_gmail.com> wrote:
> Dear All,
>
> I am working for a product based company. For DB setup for our
> product, we are currently using the dump file to generate all the
> required tables and initial data. As part of initial data setup, we
> have both static/lookup data loading and test data loading as well
> (nearly 130 tables have data setup).
>
> During development, we are facing great challenge in the dump file
> generation.... to even make small changes to data and test the same,
> we have to go through the complete process of dump file preparation
> and checking in the same. To avoid this one of the suggestion is to
> move away from dump file and have scripts for tables/views/sp
> creation
> and load initial data using sql loader. Concern with this approach
> is
> my installation process becomes bulkier (will take more time to
> create
> tables and then the sqlloder lot of log files). Number of log files
> to skim through to see whether installation is successful or not etc.
>
> Any suggestions or sharing your experience on this will be of great
> help !!!
>
> Thanks
> Ganesh

If you want, you can try this visual tool which also makes and runs dump files:

DataTime Universal (downloadable)
http://cam70.sta.uniroma1.it/DataTimeUniversal/

DataTime Documentation
http://cam70.sta.uniroma1.it/DataTimeDocumentation/

http://groups.google.it/group/DataTime Received on Tue Jun 12 2007 - 15:17:42 CDT