{"id":9693,"date":"2009-06-16T11:39:00","date_gmt":"1999-11-29T20:00:00","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=9693"},"modified":"2009-06-16T11:39:00","modified_gmt":"1999-11-29T20:00:00","slug":"iis-database-manager-release-candidate","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=9693","title":{"rendered":"IIS Database Manager Release Candidate"},"content":{"rendered":"<p><a title=\"This\" href=\"http:\/\/www.iis.net\/extensions\/DatabaseManager\">This<\/a> is going to be a pretty popular addition to IIS 7.X for application developers.\u00a0 The idea is that the database manager scans for database connections in your web.config file and allows you to perform basic administrative tasks via a web console instead of logging in via SQL Management Studio.\u00a0 No ports need to be opened for administration.\u00a0 That\u2019s a tidy solution for remotely hosted websites.\u00a0 However, I\u2019d still recommend revealing as little as possible to the net; you\u2019re better off logging into the hosted server via RDP and using the management studio console.\u00a0 But if you want, you can use this solution.\u00a0 It\u2019ll definitely be a player for internal deployments.<\/p>\n<ul>\n<li>Add, rename, drop, and edit tables  <\/li>\n<li>View and manage primary keys, indexes and foreign keys  <\/li>\n<li>Data editing  <\/li>\n<li>Establish connections to multiple databases  <\/li>\n<li>Create and execute queries  <\/li>\n<li>Create, alter and delete stored procedures  <\/li>\n<li>Create, alter and delete views  <\/li>\n<li>Manage stored procedures  <\/li>\n<li>Manage both local and remote database from your machine  <\/li>\n<li>IIS 7.0 Manager provides remote management capabilities with a clean firewall-friendly option for managing a remote SQL Server  <\/li>\n<li>Exposes a public extensibility platform that enables the development of providers to support other databases  <\/li>\n<li>Compatible with SQL 2008 and 2005 <\/li>\n<\/ul>\n<p>It\u2019s a Release Candidate (not for production yet).\u00a0 MS are promising some documentation soon.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is going to be a pretty popular addition to IIS 7.X for application developers.\u00a0 The idea is that the database manager scans for database connections in your web.config file and allows you to perform basic administrative tasks via a web console instead of logging in via SQL Management Studio.\u00a0 No ports need to be &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=9693\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;IIS Database Manager Release Candidate&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[21],"tags":[],"class_list":["post-9693","post","type-post","status-publish","format-standard","hentry","category-iis"],"aioseo_notices":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/9693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9693"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/9693\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}