{"action":"created","comment":{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/comments/88893519","pull_request_review_id":9450939,"id":88893519,"diff_hunk":"@@ -0,0 +1,61 @@\n+Trace-VstsEnteringInvocation $MyInvocation\n+Import-VstsLocStrings \"$PSScriptRoot\\Task.json\"\n+\n+$taskType = Get-VstsInput -Name \"TaskType\" -Require\n+$dacpacFile = Get-VstsInput -Name \"dacpacFile\"\n+$sqlFile = Get-VstsInput -Name \"sqlFile\" \n+$inlineSql = Get-VstsInput -Name \"inlineSql\"\n+$targetMethod = Get-VstsInput -Name \"targetMethod\"\n+$databaseName = Get-VstsInput -Name \"databaseName\" -Require\n+$authscheme = Get-VstsInput -Name \"authscheme\" -Require\n+$sqlUsername = Get-VstsInput -Name \"sqlUsername\"\n+$sqlPassword = Get-VstsInput -Name \"sqlPassword\"\n+$connectionString = Get-VstsInput -Name \"connectionString\"\n+$publishProfile = Get-VstsInput -Name \"publishProfile\"\n+$additionalArguments = Get-VstsInput -Name \"additionalArguments\"\n+$additionalArgumentsSql = Get-VstsInput -Name \"additionalArgumentsSql\"\n+\n+Import-Module $PSScriptRoot\\ps_modules\\TaskModuleSqlUtility\n+\n+Try\n+{\n+    $connectionString = Escape-SpecialChars -str $connectionString\n+    $sqlPassword = Escape-SpecialChars -str $sqlPassword\n+    $additionalArguments = Escape-SpecialChars -str $additionalArguments","path":"Tasks/SqlDacpacDeploymentOnMachineGroup/Main.ps1","position":24,"original_position":24,"commit_id":"ccafd0a86d964b0edb0001d4e67690f6df914588","original_commit_id":"ccafd0a86d964b0edb0001d4e67690f6df914588","user":{"login":"mvvsubbu","id":11993108,"avatar_url":"https://avatars.githubusercontent.com/u/11993108?v=3","gravatar_id":"","url":"https://api.github.com/users/mvvsubbu","html_url":"https://github.com/mvvsubbu","followers_url":"https://api.github.com/users/mvvsubbu/followers","following_url":"https://api.github.com/users/mvvsubbu/following{/other_user}","gists_url":"https://api.github.com/users/mvvsubbu/gists{/gist_id}","starred_url":"https://api.github.com/users/mvvsubbu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mvvsubbu/subscriptions","organizations_url":"https://api.github.com/users/mvvsubbu/orgs","repos_url":"https://api.github.com/users/mvvsubbu/repos","events_url":"https://api.github.com/users/mvvsubbu/events{/privacy}","received_events_url":"https://api.github.com/users/mvvsubbu/received_events","type":"User","site_admin":false},"body":"this is not necessary anymore","created_at":"2016-11-21T13:30:24Z","updated_at":"2016-11-21T13:30:24Z","html_url":"https://github.com/Microsoft/vsts-tasks/pull/3115#discussion_r88893519","pull_request_url":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/3115","_links":{"self":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/comments/88893519"},"html":{"href":"https://github.com/Microsoft/vsts-tasks/pull/3115#discussion_r88893519"},"pull_request":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/3115"}}},"pull_request":{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/3115","id":94366124,"html_url":"https://github.com/Microsoft/vsts-tasks/pull/3115","diff_url":"https://github.com/Microsoft/vsts-tasks/pull/3115.diff","patch_url":"https://github.com/Microsoft/vsts-tasks/pull/3115.patch","issue_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/3115","number":3115,"state":"open","locked":false,"title":"Users/ajya/added task sql dacpac deployment on mgm109","user":{"login":"Ajay-MS","id":16772764,"avatar_url":"https://avatars.githubusercontent.com/u/16772764?v=3","gravatar_id":"","url":"https://api.github.com/users/Ajay-MS","html_url":"https://github.com/Ajay-MS","followers_url":"https://api.github.com/users/Ajay-MS/followers","following_url":"https://api.github.com/users/Ajay-MS/following{/other_user}","gists_url":"https://api.github.com/users/Ajay-MS/gists{/gist_id}","starred_url":"https://api.github.com/users/Ajay-MS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ajay-MS/subscriptions","organizations_url":"https://api.github.com/users/Ajay-MS/orgs","repos_url":"https://api.github.com/users/Ajay-MS/repos","events_url":"https://api.github.com/users/Ajay-MS/events{/privacy}","received_events_url":"https://api.github.com/users/Ajay-MS/received_events","type":"User","site_admin":false},"body":"","created_at":"2016-11-18T13:58:40Z","updated_at":"2016-11-21T13:30:24Z","closed_at":null,"merged_at":null,"merge_commit_sha":"c7c796ffc751024f340e305d6e9702e59a6171c6","assignee":{"login":"kmkumaran","id":11780076,"avatar_url":"https://avatars.githubusercontent.com/u/11780076?v=3","gravatar_id":"","url":"https://api.github.com/users/kmkumaran","html_url":"https://github.com/kmkumaran","followers_url":"https://api.github.com/users/kmkumaran/followers","following_url":"https://api.github.com/users/kmkumaran/following{/other_user}","gists_url":"https://api.github.com/users/kmkumaran/gists{/gist_id}","starred_url":"https://api.github.com/users/kmkumaran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmkumaran/subscriptions","organizations_url":"https://api.github.com/users/kmkumaran/orgs","repos_url":"https://api.github.com/users/kmkumaran/repos","events_url":"https://api.github.com/users/kmkumaran/events{/privacy}","received_events_url":"https://api.github.com/users/kmkumaran/received_events","type":"User","site_admin":false},"assignees":[{"login":"kmkumaran","id":11780076,"avatar_url":"https://avatars.githubusercontent.com/u/11780076?v=3","gravatar_id":"","url":"https://api.github.com/users/kmkumaran","html_url":"https://github.com/kmkumaran","followers_url":"https://api.github.com/users/kmkumaran/followers","following_url":"https://api.github.com/users/kmkumaran/following{/other_user}","gists_url":"https://api.github.com/users/kmkumaran/gists{/gist_id}","starred_url":"https://api.github.com/users/kmkumaran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmkumaran/subscriptions","organizations_url":"https://api.github.com/users/kmkumaran/orgs","repos_url":"https://api.github.com/users/kmkumaran/repos","events_url":"https://api.github.com/users/kmkumaran/events{/privacy}","received_events_url":"https://api.github.com/users/kmkumaran/received_events","type":"User","site_admin":false},{"login":"mvvsubbu","id":11993108,"avatar_url":"https://avatars.githubusercontent.com/u/11993108?v=3","gravatar_id":"","url":"https://api.github.com/users/mvvsubbu","html_url":"https://github.com/mvvsubbu","followers_url":"https://api.github.com/users/mvvsubbu/followers","following_url":"https://api.github.com/users/mvvsubbu/following{/other_user}","gists_url":"https://api.github.com/users/mvvsubbu/gists{/gist_id}","starred_url":"https://api.github.com/users/mvvsubbu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mvvsubbu/subscriptions","organizations_url":"https://api.github.com/users/mvvsubbu/orgs","repos_url":"https://api.github.com/users/mvvsubbu/repos","events_url":"https://api.github.com/users/mvvsubbu/events{/privacy}","received_events_url":"https://api.github.com/users/mvvsubbu/received_events","type":"User","site_admin":false},{"login":"KrishnaAdityaB","id":14232392,"avatar_url":"https://avatars.githubusercontent.com/u/14232392?v=3","gravatar_id":"","url":"https://api.github.com/users/KrishnaAdityaB","html_url":"https://github.com/KrishnaAdityaB","followers_url":"https://api.github.com/users/KrishnaAdityaB/followers","following_url":"https://api.github.com/users/KrishnaAdityaB/following{/other_user}","gists_url":"https://api.github.com/users/KrishnaAdityaB/gists{/gist_id}","starred_url":"https://api.github.com/users/KrishnaAdityaB/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KrishnaAdityaB/subscriptions","organizations_url":"https://api.github.com/users/KrishnaAdityaB/orgs","repos_url":"https://api.github.com/users/KrishnaAdityaB/repos","events_url":"https://api.github.com/users/KrishnaAdityaB/events{/privacy}","received_events_url":"https://api.github.com/users/KrishnaAdityaB/received_events","type":"User","site_admin":false}],"milestone":null,"commits_url":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/3115/commits","review_comments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/3115/comments","review_comment_url":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/comments{/number}","comments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/3115/comments","statuses_url":"https://api.github.com/repos/Microsoft/vsts-tasks/statuses/ccafd0a86d964b0edb0001d4e67690f6df914588","head":{"label":"Microsoft:users/ajya/addedTaskSqlDacpacDeploymentOnMGM109","ref":"users/ajya/addedTaskSqlDacpacDeploymentOnMGM109","sha":"ccafd0a86d964b0edb0001d4e67690f6df914588","user":{"login":"Microsoft","id":6154722,"avatar_url":"https://avatars.githubusercontent.com/u/6154722?v=3","gravatar_id":"","url":"https://api.github.com/users/Microsoft","html_url":"https://github.com/Microsoft","followers_url":"https://api.github.com/users/Microsoft/followers","following_url":"https://api.github.com/users/Microsoft/following{/other_user}","gists_url":"https://api.github.com/users/Microsoft/gists{/gist_id}","starred_url":"https://api.github.com/users/Microsoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Microsoft/subscriptions","organizations_url":"https://api.github.com/users/Microsoft/orgs","repos_url":"https://api.github.com/users/Microsoft/repos","events_url":"https://api.github.com/users/Microsoft/events{/privacy}","received_events_url":"https://api.github.com/users/Microsoft/received_events","type":"Organization","site_admin":false},"repo":{"id":27631673,"name":"vsts-tasks","full_name":"Microsoft/vsts-tasks","owner":{"login":"Microsoft","id":6154722,"avatar_url":"https://avatars.githubusercontent.com/u/6154722?v=3","gravatar_id":"","url":"https://api.github.com/users/Microsoft","html_url":"https://github.com/Microsoft","followers_url":"https://api.github.com/users/Microsoft/followers","following_url":"https://api.github.com/users/Microsoft/following{/other_user}","gists_url":"https://api.github.com/users/Microsoft/gists{/gist_id}","starred_url":"https://api.github.com/users/Microsoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Microsoft/subscriptions","organizations_url":"https://api.github.com/users/Microsoft/orgs","repos_url":"https://api.github.com/users/Microsoft/repos","events_url":"https://api.github.com/users/Microsoft/events{/privacy}","received_events_url":"https://api.github.com/users/Microsoft/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Microsoft/vsts-tasks","description":"Build and Release Tasks for Visual Studio Team Services and Team Foundation Server","fork":false,"url":"https://api.github.com/repos/Microsoft/vsts-tasks","forks_url":"https://api.github.com/repos/Microsoft/vsts-tasks/forks","keys_url":"https://api.github.com/repos/Microsoft/vsts-tasks/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Microsoft/vsts-tasks/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Microsoft/vsts-tasks/teams","hooks_url":"https://api.github.com/repos/Microsoft/vsts-tasks/hooks","issue_events_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/events{/number}","events_url":"https://api.github.com/repos/Microsoft/vsts-tasks/events","assignees_url":"https://api.github.com/repos/Microsoft/vsts-tasks/assignees{/user}","branches_url":"https://api.github.com/repos/Microsoft/vsts-tasks/branches{/branch}","tags_url":"https://api.github.com/repos/Microsoft/vsts-tasks/tags","blobs_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/refs{/sha}","trees_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Microsoft/vsts-tasks/statuses/{sha}","languages_url":"https://api.github.com/repos/Microsoft/vsts-tasks/languages","stargazers_url":"https://api.github.com/repos/Microsoft/vsts-tasks/stargazers","contributors_url":"https://api.github.com/repos/Microsoft/vsts-tasks/contributors","subscribers_url":"https://api.github.com/repos/Microsoft/vsts-tasks/subscribers","subscription_url":"https://api.github.com/repos/Microsoft/vsts-tasks/subscription","commits_url":"https://api.github.com/repos/Microsoft/vsts-tasks/commits{/sha}","git_commits_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/commits{/sha}","comments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/comments{/number}","issue_comment_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/comments{/number}","contents_url":"https://api.github.com/repos/Microsoft/vsts-tasks/contents/{+path}","compare_url":"https://api.github.com/repos/Microsoft/vsts-tasks/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Microsoft/vsts-tasks/merges","archive_url":"https://api.github.com/repos/Microsoft/vsts-tasks/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Microsoft/vsts-tasks/downloads","issues_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues{/number}","pulls_url":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls{/number}","milestones_url":"https://api.github.com/repos/Microsoft/vsts-tasks/milestones{/number}","notifications_url":"https://api.github.com/repos/Microsoft/vsts-tasks/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Microsoft/vsts-tasks/labels{/name}","releases_url":"https://api.github.com/repos/Microsoft/vsts-tasks/releases{/id}","deployments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/deployments","created_at":"2014-12-06T11:11:46Z","updated_at":"2016-11-17T08:44:48Z","pushed_at":"2016-11-21T13:16:04Z","git_url":"git://github.com/Microsoft/vsts-tasks.git","ssh_url":"git@github.com:Microsoft/vsts-tasks.git","clone_url":"https://github.com/Microsoft/vsts-tasks.git","svn_url":"https://github.com/Microsoft/vsts-tasks","homepage":"https://aka.ms/tfbuild","size":24823,"stargazers_count":459,"watchers_count":459,"language":"TypeScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":413,"mirror_url":null,"open_issues_count":108,"forks":413,"open_issues":108,"watchers":459,"default_branch":"master"}},"base":{"label":"Microsoft:releases/m109","ref":"releases/m109","sha":"3906de4e7834729d62b2380a38fc826d6edec470","user":{"login":"Microsoft","id":6154722,"avatar_url":"https://avatars.githubusercontent.com/u/6154722?v=3","gravatar_id":"","url":"https://api.github.com/users/Microsoft","html_url":"https://github.com/Microsoft","followers_url":"https://api.github.com/users/Microsoft/followers","following_url":"https://api.github.com/users/Microsoft/following{/other_user}","gists_url":"https://api.github.com/users/Microsoft/gists{/gist_id}","starred_url":"https://api.github.com/users/Microsoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Microsoft/subscriptions","organizations_url":"https://api.github.com/users/Microsoft/orgs","repos_url":"https://api.github.com/users/Microsoft/repos","events_url":"https://api.github.com/users/Microsoft/events{/privacy}","received_events_url":"https://api.github.com/users/Microsoft/received_events","type":"Organization","site_admin":false},"repo":{"id":27631673,"name":"vsts-tasks","full_name":"Microsoft/vsts-tasks","owner":{"login":"Microsoft","id":6154722,"avatar_url":"https://avatars.githubusercontent.com/u/6154722?v=3","gravatar_id":"","url":"https://api.github.com/users/Microsoft","html_url":"https://github.com/Microsoft","followers_url":"https://api.github.com/users/Microsoft/followers","following_url":"https://api.github.com/users/Microsoft/following{/other_user}","gists_url":"https://api.github.com/users/Microsoft/gists{/gist_id}","starred_url":"https://api.github.com/users/Microsoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Microsoft/subscriptions","organizations_url":"https://api.github.com/users/Microsoft/orgs","repos_url":"https://api.github.com/users/Microsoft/repos","events_url":"https://api.github.com/users/Microsoft/events{/privacy}","received_events_url":"https://api.github.com/users/Microsoft/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Microsoft/vsts-tasks","description":"Build and Release Tasks for Visual Studio Team Services and Team Foundation Server","fork":false,"url":"https://api.github.com/repos/Microsoft/vsts-tasks","forks_url":"https://api.github.com/repos/Microsoft/vsts-tasks/forks","keys_url":"https://api.github.com/repos/Microsoft/vsts-tasks/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Microsoft/vsts-tasks/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Microsoft/vsts-tasks/teams","hooks_url":"https://api.github.com/repos/Microsoft/vsts-tasks/hooks","issue_events_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/events{/number}","events_url":"https://api.github.com/repos/Microsoft/vsts-tasks/events","assignees_url":"https://api.github.com/repos/Microsoft/vsts-tasks/assignees{/user}","branches_url":"https://api.github.com/repos/Microsoft/vsts-tasks/branches{/branch}","tags_url":"https://api.github.com/repos/Microsoft/vsts-tasks/tags","blobs_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/refs{/sha}","trees_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Microsoft/vsts-tasks/statuses/{sha}","languages_url":"https://api.github.com/repos/Microsoft/vsts-tasks/languages","stargazers_url":"https://api.github.com/repos/Microsoft/vsts-tasks/stargazers","contributors_url":"https://api.github.com/repos/Microsoft/vsts-tasks/contributors","subscribers_url":"https://api.github.com/repos/Microsoft/vsts-tasks/subscribers","subscription_url":"https://api.github.com/repos/Microsoft/vsts-tasks/subscription","commits_url":"https://api.github.com/repos/Microsoft/vsts-tasks/commits{/sha}","git_commits_url":"https://api.github.com/repos/Microsoft/vsts-tasks/git/commits{/sha}","comments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/comments{/number}","issue_comment_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/comments{/number}","contents_url":"https://api.github.com/repos/Microsoft/vsts-tasks/contents/{+path}","compare_url":"https://api.github.com/repos/Microsoft/vsts-tasks/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Microsoft/vsts-tasks/merges","archive_url":"https://api.github.com/repos/Microsoft/vsts-tasks/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Microsoft/vsts-tasks/downloads","issues_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues{/number}","pulls_url":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls{/number}","milestones_url":"https://api.github.com/repos/Microsoft/vsts-tasks/milestones{/number}","notifications_url":"https://api.github.com/repos/Microsoft/vsts-tasks/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Microsoft/vsts-tasks/labels{/name}","releases_url":"https://api.github.com/repos/Microsoft/vsts-tasks/releases{/id}","deployments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/deployments","created_at":"2014-12-06T11:11:46Z","updated_at":"2016-11-17T08:44:48Z","pushed_at":"2016-11-21T13:16:04Z","git_url":"git://github.com/Microsoft/vsts-tasks.git","ssh_url":"git@github.com:Microsoft/vsts-tasks.git","clone_url":"https://github.com/Microsoft/vsts-tasks.git","svn_url":"https://github.com/Microsoft/vsts-tasks","homepage":"https://aka.ms/tfbuild","size":24823,"stargazers_count":459,"watchers_count":459,"language":"TypeScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":413,"mirror_url":null,"open_issues_count":108,"forks":413,"open_issues":108,"watchers":459,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/3115"},"html":{"href":"https://github.com/Microsoft/vsts-tasks/pull/3115"},"issue":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/3115"},"comments":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/3115/comments"},"review_comments":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/3115/comments"},"review_comment":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/pulls/3115/commits"},"statuses":{"href":"https://api.github.com/repos/Microsoft/vsts-tasks/statuses/ccafd0a86d964b0edb0001d4e67690f6df914588"}}}}
{"actor":{"display_login":"mvvsubbu"}}