I am working an existing database (PostgreSQL) that has many other applications depending on it. This raises a couple questions:

1. During testing, I would like to use a handmade SQL script to create the database structure and use the usual sample data mechanism to populate it. How can I achieve this?

2. I am using a number of stored procedures (In PL/PGSQL), any ideas on how these should be maintained? I'm thinking that this should be a separate project in the same place as the DDL. But then how to integration these into the build process?

Any thoughts/comments/suggestions would be appreciated.

Thanks,

A.

--
Adam Sherman
Technologist
+1 (613) 797-6819 | http://www.sherman.ca/ | sip:[EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to