Have you considered just buying Red Gate's tools that do this? They're a couple hundred bucks and are going to be infinitely more mature than a home grown tool...
Thanks, Brian Desmond [email protected] w - 312.625.1438 | c - 312.731.3132 -----Original Message----- From: Joseph L. Casale [mailto:[email protected]] Sent: Monday, April 02, 2012 11:39 AM To: NT System Admin Issues Subject: Powershell ODBC and SQL scripts 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 ~ 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
