> I'm required to write a small bolt-on application (web based), so I was> intending to create a separate 'database', where I could store my> application's stored procedures/views/etc, so that it would be independant> from our ERP system.

After reading the "Getting Started" docs I would suggest you store your
application stored procedures/views/etc in a different schema in the
SAME database as the ERP system (if the vendor will allow it). This
will improve performance and is easier to design and make secure. You
should however have a test and development environment FAR away from
the production environment. It is normally quite easy to create a copy
of a database for these purposes. Again this is all in the "Getting
Started" section of the documentation.
Received on Thu Aug 17 2006 - 04:42:29 CDT