Hi
We want to move the stored procedures from one environment to other
environments like Test to QA , QA to Pord we are encountering problem.
The table names are completely qualified means like testschema.tablename in
Test environment qaschema.tablename in QA and proschema.tablename.in Prod in
the stored procedures
When we want to move the SQL stored procedures from one environment to other
we are facing problem because of the qualifier and we have change
qualifier/code every time to make it environment fit. There is a possibility
of human errors while doing that hence we want to avoid it.
What are the best ways to make the Stored Procedures Qualifier independent
or edit free while moving them from one environment to other?
Any kind of suggestion is appreciated.
Thank You.
Kish
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
