I needed to quickly print the text associated with several stored procedures across multiple database servers to individual files. I used what is below.<\/p>\n
\r\nimport java.sql.*;\r\nimport com.microsoft.sqlserver.jdbc.*;\r\nimport java.io.*;\r\n\r\npublic class sqlProcedures {\r\n public static void main(String[] args) {\r\n String[] hosts = {\"host1\",\"host2\",\"host3\"};\r\n for (int i = 0; i < hosts.length; i++) {\r\n String connString = \"jdbc:sqlserver:\/\/\" + hosts[i] + \":1433;\";\r\n try {\r\n Connection con = DriverManager.getConnection(connString + \"databaseName=dbaDB;integratedSecurity=true;\");\r\n PreparedStatement stm = con.prepareCall(\"select name,id from sysobjects where name like 'dbasp%' order by 1\");\r\n ResultSet rst = stm.executeQuery();\r\n \r\n PreparedStatement stm2 = con.prepareCall(\"select text from syscomments where id = ?\");\r\n while (rst.next()) {\r\n BufferedWriter out = new BufferedWriter(new FileWriter(hosts[i] + \"_\" + rst.getString(1) + \".sql\"));\r\n stm2.setInt(1,rst.getInt(2)); \r\n ResultSet rst2 = stm2.executeQuery();\r\n while (rst2.next()) {\r\n out.write(rst2.getString(1));\r\n }\r\n out.close();\r\n }\r\n }\r\n catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"I needed to quickly print the text associated with several stored procedures across multiple database servers to individual files. I used what is below. import java.sql.*; import com.microsoft.sqlserver.jdbc.*; import java.io.*; public class sqlProcedures { public static void main(String[] args) {…<\/p>\n