{"id":426,"date":"2008-05-04T17:31:16","date_gmt":"2008-05-05T01:31:16","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/2008\/05\/04\/database-scripts-with-powershell\/"},"modified":"2008-05-08T17:10:47","modified_gmt":"2008-05-09T01:10:47","slug":"database-scripts-with-powershell","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2008\/05\/04\/database-scripts-with-powershell\/","title":{"rendered":"Database Scripts with PowerShell"},"content":{"rendered":"<p>&nbsp;Did you know that PrimalScript 2007 Professional and Enterprise can produce database-connected Windows PowerShell scripts? At least, the new service build (566) for these products can! Just open your Database Browser (select it from View > Browser Windows if it isn&#8217;t visible; by default it&#8217;s on the right-hand side of the code editing window, once it&#8217;s made visible), right-click to create a new database connection, and use the GUI to connect to any kind of database. Then, right-click a table to generate a script using the database wizard. You&#8217;ll get complete boilerplate code that maps to YOUR database schema &#8211; so you can see exactly how to write scripts that access YOUR database. This new feature is a FREE addition to current PrimalScript 2007 owners &#8211; log into <a href=\"http:\/\/my.sapien.com\">my.sapien.com<\/a> to access the latest version!&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;Did you know that PrimalScript 2007 Professional and Enterprise can produce database-connected Windows PowerShell scripts? At least, the new service build (566) for these products can! Just open your Database Browser (select it from View > Browser Windows if it isn&#8217;t visible; by default it&#8217;s on the right-hand side of the code editing window, once [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[21,25],"tags":[164,161,162,163,166,28,38,165],"class_list":["post-426","post","type-post","status-publish","format-standard","hentry","category-software-news","category-windows-powershell","tag-access","tag-ado","tag-adonet","tag-database","tag-example","tag-powershell","tag-sql","tag-sql-server"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=426"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/426\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}