{"action":"created","comment":{"url":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/comments/43807993","id":43807993,"diff_hunk":"@@ -0,0 +1,25 @@\n+-- Copyright (c) Microsoft. All rights reserved.\r\n+-- Licensed under the MIT license. See LICENSE file in the project root for full license information.\r\n+\r\n+---------------------------------------------------------------------------------------------------\r\n+-- Script to upgrade Global Shard Map from version 1.2 to 1.3\r\n+-- Fix for https://github.com/Azure/elastic-db-tools/issues/77\r\n+-- Only the Global Shard Map is affected\r\n+---------------------------------------------------------------------------------------------------\r\n+\r\n+update __ShardManagement.ShardedDatabaseSchemaInfosGlobal\r\n+set SchemaInfo = \r\n+\treplace(\r\n+\t\treplace(\r\n+\t\t\treplace(\r\n+\t\t\t\treplace(\r\n+\t\t\t\t\tcast(SchemaInfo as nvarchar(max)), \r\n+\t\t\t\t\t'<_referenceTableSet i:type=\"ArrayOfReferenceTableInfo\">', \r\n+\t\t\t\t\t'<ReferenceTableSet i:type=\"ArrayOfReferenceTableInfo\">'),\r\n+\t\t\t\t'</_referenceTableSet>',\r\n+\t\t\t\t'</ReferenceTableSet>'),\r\n+\t\t'<_shardedTableSet i:type=\"ArrayOfShardedTableInfo\">', \r\n+\t\t'<ShardedTableSet i:type=\"ArrayOfShardedTableInfo\">'),\r\n+\t'</_shardedTableSet>',\r\n+\t'</ShardedTableSet>')\r\n+go\r","path":"Src/ElasticScale.Client/ShardManagement/Scripts/UpgradeShardMapManagerGlobalFrom1.2To1.3.sql","position":25,"original_position":25,"commit_id":"264d29ec60ed9ef53402f728827238db8692868c","original_commit_id":"264d29ec60ed9ef53402f728827238db8692868c","user":{"login":"apurvans","id":13990178,"avatar_url":"https://avatars.githubusercontent.com/u/13990178?v=3","gravatar_id":"","url":"https://api.github.com/users/apurvans","html_url":"https://github.com/apurvans","followers_url":"https://api.github.com/users/apurvans/followers","following_url":"https://api.github.com/users/apurvans/following{/other_user}","gists_url":"https://api.github.com/users/apurvans/gists{/gist_id}","starred_url":"https://api.github.com/users/apurvans/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apurvans/subscriptions","organizations_url":"https://api.github.com/users/apurvans/orgs","repos_url":"https://api.github.com/users/apurvans/repos","events_url":"https://api.github.com/users/apurvans/events{/privacy}","received_events_url":"https://api.github.com/users/apurvans/received_events","type":"User","site_admin":false},"body":"Update persisted version information at the end of script -\r\n-- update version as 1.3\r\nupdate\r\n\t__ShardManagement.ShardMapManagerGlobal \r\nset \r\n\tStoreVersionMinor = 3\r\nwhere\r\n\tStoreVersionMajor = 1 and StoreVersionMinor = 2","created_at":"2015-11-03T21:16:43Z","updated_at":"2015-11-03T21:16:43Z","html_url":"https://github.com/Azure/elastic-db-tools/pull/79#discussion_r43807993","pull_request_url":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/79","_links":{"self":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/comments/43807993"},"html":{"href":"https://github.com/Azure/elastic-db-tools/pull/79#discussion_r43807993"},"pull_request":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/79"}}},"pull_request":{"url":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/79","id":49602394,"html_url":"https://github.com/Azure/elastic-db-tools/pull/79","diff_url":"https://github.com/Azure/elastic-db-tools/pull/79.diff","patch_url":"https://github.com/Azure/elastic-db-tools/pull/79.patch","issue_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/79","number":79,"state":"open","locked":false,"title":"Fix schema info serialization","user":{"login":"jaredmoo","id":3248887,"avatar_url":"https://avatars.githubusercontent.com/u/3248887?v=3","gravatar_id":"","url":"https://api.github.com/users/jaredmoo","html_url":"https://github.com/jaredmoo","followers_url":"https://api.github.com/users/jaredmoo/followers","following_url":"https://api.github.com/users/jaredmoo/following{/other_user}","gists_url":"https://api.github.com/users/jaredmoo/gists{/gist_id}","starred_url":"https://api.github.com/users/jaredmoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jaredmoo/subscriptions","organizations_url":"https://api.github.com/users/jaredmoo/orgs","repos_url":"https://api.github.com/users/jaredmoo/repos","events_url":"https://api.github.com/users/jaredmoo/events{/privacy}","received_events_url":"https://api.github.com/users/jaredmoo/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-11-03T19:47:58Z","updated_at":"2015-11-03T21:16:43Z","closed_at":null,"merged_at":null,"merge_commit_sha":"3aa4389d3210143e27c41c312053618ff7d15bd1","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/79/commits","review_comments_url":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/79/comments","review_comment_url":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/comments{/number}","comments_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/79/comments","statuses_url":"https://api.github.com/repos/Azure/elastic-db-tools/statuses/264d29ec60ed9ef53402f728827238db8692868c","head":{"label":"jaredmoo:FixSchemaInfoSerialization","ref":"FixSchemaInfoSerialization","sha":"264d29ec60ed9ef53402f728827238db8692868c","user":{"login":"jaredmoo","id":3248887,"avatar_url":"https://avatars.githubusercontent.com/u/3248887?v=3","gravatar_id":"","url":"https://api.github.com/users/jaredmoo","html_url":"https://github.com/jaredmoo","followers_url":"https://api.github.com/users/jaredmoo/followers","following_url":"https://api.github.com/users/jaredmoo/following{/other_user}","gists_url":"https://api.github.com/users/jaredmoo/gists{/gist_id}","starred_url":"https://api.github.com/users/jaredmoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jaredmoo/subscriptions","organizations_url":"https://api.github.com/users/jaredmoo/orgs","repos_url":"https://api.github.com/users/jaredmoo/repos","events_url":"https://api.github.com/users/jaredmoo/events{/privacy}","received_events_url":"https://api.github.com/users/jaredmoo/received_events","type":"User","site_admin":false},"repo":{"id":41935770,"name":"elastic-db-tools","full_name":"jaredmoo/elastic-db-tools","owner":{"login":"jaredmoo","id":3248887,"avatar_url":"https://avatars.githubusercontent.com/u/3248887?v=3","gravatar_id":"","url":"https://api.github.com/users/jaredmoo","html_url":"https://github.com/jaredmoo","followers_url":"https://api.github.com/users/jaredmoo/followers","following_url":"https://api.github.com/users/jaredmoo/following{/other_user}","gists_url":"https://api.github.com/users/jaredmoo/gists{/gist_id}","starred_url":"https://api.github.com/users/jaredmoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jaredmoo/subscriptions","organizations_url":"https://api.github.com/users/jaredmoo/orgs","repos_url":"https://api.github.com/users/jaredmoo/repos","events_url":"https://api.github.com/users/jaredmoo/events{/privacy}","received_events_url":"https://api.github.com/users/jaredmoo/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/jaredmoo/elastic-db-tools","description":"Elastic database tools client library allows ADO.NET developers to create applications that implement and use the pattern known as database sharding in Azure SQL Database.","fork":true,"url":"https://api.github.com/repos/jaredmoo/elastic-db-tools","forks_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/forks","keys_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/teams","hooks_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/hooks","issue_events_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/issues/events{/number}","events_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/events","assignees_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/assignees{/user}","branches_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/branches{/branch}","tags_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/tags","blobs_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/git/refs{/sha}","trees_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/statuses/{sha}","languages_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/languages","stargazers_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/stargazers","contributors_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/contributors","subscribers_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/subscribers","subscription_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/subscription","commits_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/commits{/sha}","git_commits_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/git/commits{/sha}","comments_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/comments{/number}","issue_comment_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/issues/comments{/number}","contents_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/contents/{+path}","compare_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/merges","archive_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/downloads","issues_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/issues{/number}","pulls_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/pulls{/number}","milestones_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/milestones{/number}","notifications_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/labels{/name}","releases_url":"https://api.github.com/repos/jaredmoo/elastic-db-tools/releases{/id}","created_at":"2015-09-04T20:11:51Z","updated_at":"2015-09-04T20:11:53Z","pushed_at":"2015-11-03T21:15:01Z","git_url":"git://github.com/jaredmoo/elastic-db-tools.git","ssh_url":"git@github.com:jaredmoo/elastic-db-tools.git","clone_url":"https://github.com/jaredmoo/elastic-db-tools.git","svn_url":"https://github.com/jaredmoo/elastic-db-tools","homepage":null,"size":638,"stargazers_count":0,"watchers_count":0,"language":"C#","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"Azure:master","ref":"master","sha":"d8db4d142584b5734547f14defaed477f09697e5","user":{"login":"Azure","id":6844498,"avatar_url":"https://avatars.githubusercontent.com/u/6844498?v=3","gravatar_id":"","url":"https://api.github.com/users/Azure","html_url":"https://github.com/Azure","followers_url":"https://api.github.com/users/Azure/followers","following_url":"https://api.github.com/users/Azure/following{/other_user}","gists_url":"https://api.github.com/users/Azure/gists{/gist_id}","starred_url":"https://api.github.com/users/Azure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Azure/subscriptions","organizations_url":"https://api.github.com/users/Azure/orgs","repos_url":"https://api.github.com/users/Azure/repos","events_url":"https://api.github.com/users/Azure/events{/privacy}","received_events_url":"https://api.github.com/users/Azure/received_events","type":"Organization","site_admin":false},"repo":{"id":37151564,"name":"elastic-db-tools","full_name":"Azure/elastic-db-tools","owner":{"login":"Azure","id":6844498,"avatar_url":"https://avatars.githubusercontent.com/u/6844498?v=3","gravatar_id":"","url":"https://api.github.com/users/Azure","html_url":"https://github.com/Azure","followers_url":"https://api.github.com/users/Azure/followers","following_url":"https://api.github.com/users/Azure/following{/other_user}","gists_url":"https://api.github.com/users/Azure/gists{/gist_id}","starred_url":"https://api.github.com/users/Azure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Azure/subscriptions","organizations_url":"https://api.github.com/users/Azure/orgs","repos_url":"https://api.github.com/users/Azure/repos","events_url":"https://api.github.com/users/Azure/events{/privacy}","received_events_url":"https://api.github.com/users/Azure/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Azure/elastic-db-tools","description":"Elastic database tools client library allows ADO.NET developers to create applications that implement and use the pattern known as database sharding in Azure SQL Database.","fork":false,"url":"https://api.github.com/repos/Azure/elastic-db-tools","forks_url":"https://api.github.com/repos/Azure/elastic-db-tools/forks","keys_url":"https://api.github.com/repos/Azure/elastic-db-tools/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Azure/elastic-db-tools/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Azure/elastic-db-tools/teams","hooks_url":"https://api.github.com/repos/Azure/elastic-db-tools/hooks","issue_events_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/events{/number}","events_url":"https://api.github.com/repos/Azure/elastic-db-tools/events","assignees_url":"https://api.github.com/repos/Azure/elastic-db-tools/assignees{/user}","branches_url":"https://api.github.com/repos/Azure/elastic-db-tools/branches{/branch}","tags_url":"https://api.github.com/repos/Azure/elastic-db-tools/tags","blobs_url":"https://api.github.com/repos/Azure/elastic-db-tools/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Azure/elastic-db-tools/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Azure/elastic-db-tools/git/refs{/sha}","trees_url":"https://api.github.com/repos/Azure/elastic-db-tools/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Azure/elastic-db-tools/statuses/{sha}","languages_url":"https://api.github.com/repos/Azure/elastic-db-tools/languages","stargazers_url":"https://api.github.com/repos/Azure/elastic-db-tools/stargazers","contributors_url":"https://api.github.com/repos/Azure/elastic-db-tools/contributors","subscribers_url":"https://api.github.com/repos/Azure/elastic-db-tools/subscribers","subscription_url":"https://api.github.com/repos/Azure/elastic-db-tools/subscription","commits_url":"https://api.github.com/repos/Azure/elastic-db-tools/commits{/sha}","git_commits_url":"https://api.github.com/repos/Azure/elastic-db-tools/git/commits{/sha}","comments_url":"https://api.github.com/repos/Azure/elastic-db-tools/comments{/number}","issue_comment_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/comments{/number}","contents_url":"https://api.github.com/repos/Azure/elastic-db-tools/contents/{+path}","compare_url":"https://api.github.com/repos/Azure/elastic-db-tools/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Azure/elastic-db-tools/merges","archive_url":"https://api.github.com/repos/Azure/elastic-db-tools/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Azure/elastic-db-tools/downloads","issues_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues{/number}","pulls_url":"https://api.github.com/repos/Azure/elastic-db-tools/pulls{/number}","milestones_url":"https://api.github.com/repos/Azure/elastic-db-tools/milestones{/number}","notifications_url":"https://api.github.com/repos/Azure/elastic-db-tools/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Azure/elastic-db-tools/labels{/name}","releases_url":"https://api.github.com/repos/Azure/elastic-db-tools/releases{/id}","created_at":"2015-06-09T18:49:58Z","updated_at":"2015-10-31T09:23:57Z","pushed_at":"2015-11-03T20:37:12Z","git_url":"git://github.com/Azure/elastic-db-tools.git","ssh_url":"git@github.com:Azure/elastic-db-tools.git","clone_url":"https://github.com/Azure/elastic-db-tools.git","svn_url":"https://github.com/Azure/elastic-db-tools","homepage":null,"size":1201,"stargazers_count":18,"watchers_count":18,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":5,"mirror_url":null,"open_issues_count":35,"forks":5,"open_issues":35,"watchers":18,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/79"},"html":{"href":"https://github.com/Azure/elastic-db-tools/pull/79"},"issue":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/issues/79"},"comments":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/issues/79/comments"},"review_comments":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/79/comments"},"review_comment":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/pulls/79/commits"},"statuses":{"href":"https://api.github.com/repos/Azure/elastic-db-tools/statuses/264d29ec60ed9ef53402f728827238db8692868c"}}}}