I have to make a ps script that is portable for use with MSSQL and Oracle backends to apply regular schema updates then reload stored procs.
Starting with SQL half first, there is plenty of sample code for running individual statements against an SQL server but that means rewriting the script each time. Anyone know a ps method using the DbCommand Class to play a script into the database? Thanks! jlc ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
