{"action":"created","comment":{"url":"https://api.github.com/repos/Particular/docs.particular.net/pulls/comments/57018405","id":57018405,"diff_hunk":"@@ -0,0 +1,61 @@\n+---\n+title: SQL Server transport deployment options\n+summary: Describes available SQL Server transport deployment options\n+tags:\n+- SQL Server\n+- Transports\n+redirects:\n+- nservicebus/sqlserver/multiple-databases\n+---\n+\n+In default configuration SQL Server transport assumes that all tables used for storing messages are located in a single catalog and within a single schema. The configuration can be changed to partition message storage between different schemas and catalogs. The decision can me made on per queue basis (including error and audit queues).\n+\n+The supported deployment options are:\n+ * ***default***: all queues are stored in a single catalog and a single schema (Versions 1.x and higher)\n+ * ***multi-schema***: queues are stored in a single catalog but in more than one schema (Versions 2.1 and higher)\n+ * ***multi-catalog***: queues are stored in multiple catalogs but on a single SQL Server instance. This mode is indirectly supported by using *multi-instance* option, and requires using DTC. In this document both options are covered under *multi-instance* term.\n+ * ***multi-instance***: queues are stored in multiple catalogs on more than one SQL Server instance (Versions 2.1 to 2.x).\n+\n+NOTE: To properly identify the chosen deployment option all queues that the endpoint interacts with need to be taken into consideration, including error and audit queues. If either of them are stored in a separate SQL Server instance then the deployment is a *multi-instance* one.\n+\n+The transport will route messages to destination based on the configuration. If no specific configuration has been provided for a particular destination, the transport assumes the destination has the same configuration as the sending endpoint (i.e. identical schema, catalog and instance name). If the destination has a different configuration and it hasn't been provided, then exception will be thrown immediately, because the transport wouldn't be able to connect to the destination queue.\n+\n+# Modes overview\n+\n+## Default (single schema, single catalog, single SQL Server instance)\n+\n+- Supported in Versions 1.0 and higher.\n+- Has simple configuration and setup.\n+- Doesn't require Distributed Transaction Coordinator (MS DTC).\n+- The snapshot (backup) of the entire system state can be done by backing up a single database. It is especially useful if business data is also stored in the same database.\n+- Can be monitored with ServiceControl.\n+\n+## Multi-schema\n+\n+- Supported in Versions 2.1 and higher.\n+- Has simple configuration and setup.\n+- Doesn't require Distributed Transaction Coordinator (MS DTC).\n+- The snapshot (backup) of the entire system state is done by backing up a single database. It is especially useful if business data is also stored in the same database.\n+- Enables security configuration on a schema level.\n+- Can't be monitored with ServiceControl.\n+\n+## Multi-instance (and multi-catalog)\n+\n+- Supported in Versions 2.1 to 2.x, legacy support is offered in Versions 3.x, won't be supported directly in Versions 4.0 and higher.","path":"nservicebus/sqlserver/deployment-options.md","position":44,"original_position":44,"commit_id":"e0593f00a6efc65432a2e2a96cbba736baed3df4","original_commit_id":"e0593f00a6efc65432a2e2a96cbba736baed3df4","user":{"login":"indualagarsamy","id":854553,"avatar_url":"https://avatars.githubusercontent.com/u/854553?v=3","gravatar_id":"","url":"https://api.github.com/users/indualagarsamy","html_url":"https://github.com/indualagarsamy","followers_url":"https://api.github.com/users/indualagarsamy/followers","following_url":"https://api.github.com/users/indualagarsamy/following{/other_user}","gists_url":"https://api.github.com/users/indualagarsamy/gists{/gist_id}","starred_url":"https://api.github.com/users/indualagarsamy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/indualagarsamy/subscriptions","organizations_url":"https://api.github.com/users/indualagarsamy/orgs","repos_url":"https://api.github.com/users/indualagarsamy/repos","events_url":"https://api.github.com/users/indualagarsamy/events{/privacy}","received_events_url":"https://api.github.com/users/indualagarsamy/received_events","type":"User","site_admin":false},"body":"I think we should add:\r\nWARNING: This option will not be supported in Versions 4 and above.","created_at":"2016-03-22T16:25:47Z","updated_at":"2016-03-22T16:25:47Z","html_url":"https://github.com/Particular/docs.particular.net/pull/1324#discussion_r57018405","pull_request_url":"https://api.github.com/repos/Particular/docs.particular.net/pulls/1324","_links":{"self":{"href":"https://api.github.com/repos/Particular/docs.particular.net/pulls/comments/57018405"},"html":{"href":"https://github.com/Particular/docs.particular.net/pull/1324#discussion_r57018405"},"pull_request":{"href":"https://api.github.com/repos/Particular/docs.particular.net/pulls/1324"}}},"pull_request":{"url":"https://api.github.com/repos/Particular/docs.particular.net/pulls/1324","id":63204210,"html_url":"https://github.com/Particular/docs.particular.net/pull/1324","diff_url":"https://github.com/Particular/docs.particular.net/pull/1324.diff","patch_url":"https://github.com/Particular/docs.particular.net/pull/1324.patch","issue_url":"https://api.github.com/repos/Particular/docs.particular.net/issues/1324","number":1324,"state":"open","locked":false,"title":"Update docs for SQL Server multi-X","user":{"login":"weralabaj","id":7335079,"avatar_url":"https://avatars.githubusercontent.com/u/7335079?v=3","gravatar_id":"","url":"https://api.github.com/users/weralabaj","html_url":"https://github.com/weralabaj","followers_url":"https://api.github.com/users/weralabaj/followers","following_url":"https://api.github.com/users/weralabaj/following{/other_user}","gists_url":"https://api.github.com/users/weralabaj/gists{/gist_id}","starred_url":"https://api.github.com/users/weralabaj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/weralabaj/subscriptions","organizations_url":"https://api.github.com/users/weralabaj/orgs","repos_url":"https://api.github.com/users/weralabaj/repos","events_url":"https://api.github.com/users/weralabaj/events{/privacy}","received_events_url":"https://api.github.com/users/weralabaj/received_events","type":"User","site_admin":false},"body":"Connects to https://github.com/Particular/NServiceBus.SqlServer/issues/139","created_at":"2016-03-17T10:53:24Z","updated_at":"2016-03-22T16:25:47Z","closed_at":null,"merged_at":null,"merge_commit_sha":"ede7627feba2c8c6c92a9fdb698f1c60e0802973","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/Particular/docs.particular.net/pulls/1324/commits","review_comments_url":"https://api.github.com/repos/Particular/docs.particular.net/pulls/1324/comments","review_comment_url":"https://api.github.com/repos/Particular/docs.particular.net/pulls/comments{/number}","comments_url":"https://api.github.com/repos/Particular/docs.particular.net/issues/1324/comments","statuses_url":"https://api.github.com/repos/Particular/docs.particular.net/statuses/e0593f00a6efc65432a2e2a96cbba736baed3df4","head":{"label":"Particular:multi-database-docos-upgrade","ref":"multi-database-docos-upgrade","sha":"e0593f00a6efc65432a2e2a96cbba736baed3df4","user":{"login":"Particular","id":5038441,"avatar_url":"https://avatars.githubusercontent.com/u/5038441?v=3","gravatar_id":"","url":"https://api.github.com/users/Particular","html_url":"https://github.com/Particular","followers_url":"https://api.github.com/users/Particular/followers","following_url":"https://api.github.com/users/Particular/following{/other_user}","gists_url":"https://api.github.com/users/Particular/gists{/gist_id}","starred_url":"https://api.github.com/users/Particular/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Particular/subscriptions","organizations_url":"https://api.github.com/users/Particular/orgs","repos_url":"https://api.github.com/users/Particular/repos","events_url":"https://api.github.com/users/Particular/events{/privacy}","received_events_url":"https://api.github.com/users/Particular/received_events","type":"Organization","site_admin":false},"repo":{"id":11727301,"name":"docs.particular.net","full_name":"Particular/docs.particular.net","owner":{"login":"Particular","id":5038441,"avatar_url":"https://avatars.githubusercontent.com/u/5038441?v=3","gravatar_id":"","url":"https://api.github.com/users/Particular","html_url":"https://github.com/Particular","followers_url":"https://api.github.com/users/Particular/followers","following_url":"https://api.github.com/users/Particular/following{/other_user}","gists_url":"https://api.github.com/users/Particular/gists{/gist_id}","starred_url":"https://api.github.com/users/Particular/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Particular/subscriptions","organizations_url":"https://api.github.com/users/Particular/orgs","repos_url":"https://api.github.com/users/Particular/repos","events_url":"https://api.github.com/users/Particular/events{/privacy}","received_events_url":"https://api.github.com/users/Particular/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Particular/docs.particular.net","description":"Contains all the content for the Particular documentation site","fork":false,"url":"https://api.github.com/repos/Particular/docs.particular.net","forks_url":"https://api.github.com/repos/Particular/docs.particular.net/forks","keys_url":"https://api.github.com/repos/Particular/docs.particular.net/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Particular/docs.particular.net/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Particular/docs.particular.net/teams","hooks_url":"https://api.github.com/repos/Particular/docs.particular.net/hooks","issue_events_url":"https://api.github.com/repos/Particular/docs.particular.net/issues/events{/number}","events_url":"https://api.github.com/repos/Particular/docs.particular.net/events","assignees_url":"https://api.github.com/repos/Particular/docs.particular.net/assignees{/user}","branches_url":"https://api.github.com/repos/Particular/docs.particular.net/branches{/branch}","tags_url":"https://api.github.com/repos/Particular/docs.particular.net/tags","blobs_url":"https://api.github.com/repos/Particular/docs.particular.net/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Particular/docs.particular.net/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Particular/docs.particular.net/git/refs{/sha}","trees_url":"https://api.github.com/repos/Particular/docs.particular.net/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Particular/docs.particular.net/statuses/{sha}","languages_url":"https://api.github.com/repos/Particular/docs.particular.net/languages","stargazers_url":"https://api.github.com/repos/Particular/docs.particular.net/stargazers","contributors_url":"https://api.github.com/repos/Particular/docs.particular.net/contributors","subscribers_url":"https://api.github.com/repos/Particular/docs.particular.net/subscribers","subscription_url":"https://api.github.com/repos/Particular/docs.particular.net/subscription","commits_url":"https://api.github.com/repos/Particular/docs.particular.net/commits{/sha}","git_commits_url":"https://api.github.com/repos/Particular/docs.particular.net/git/commits{/sha}","comments_url":"https://api.github.com/repos/Particular/docs.particular.net/comments{/number}","issue_comment_url":"https://api.github.com/repos/Particular/docs.particular.net/issues/comments{/number}","contents_url":"https://api.github.com/repos/Particular/docs.particular.net/contents/{+path}","compare_url":"https://api.github.com/repos/Particular/docs.particular.net/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Particular/docs.particular.net/merges","archive_url":"https://api.github.com/repos/Particular/docs.particular.net/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Particular/docs.particular.net/downloads","issues_url":"https://api.github.com/repos/Particular/docs.particular.net/issues{/number}","pulls_url":"https://api.github.com/repos/Particular/docs.particular.net/pulls{/number}","milestones_url":"https://api.github.com/repos/Particular/docs.particular.net/milestones{/number}","notifications_url":"https://api.github.com/repos/Particular/docs.particular.net/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Particular/docs.particular.net/labels{/name}","releases_url":"https://api.github.com/repos/Particular/docs.particular.net/releases{/id}","deployments_url":"https://api.github.com/repos/Particular/docs.particular.net/deployments","created_at":"2013-07-28T23:18:15Z","updated_at":"2016-02-19T18:24:25Z","pushed_at":"2016-03-22T15:20:36Z","git_url":"git://github.com/Particular/docs.particular.net.git","ssh_url":"git@github.com:Particular/docs.particular.net.git","clone_url":"https://github.com/Particular/docs.particular.net.git","svn_url":"https://github.com/Particular/docs.particular.net","homepage":"http://docs.particular.net","size":46419,"stargazers_count":20,"watchers_count":20,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":108,"mirror_url":null,"open_issues_count":155,"forks":108,"open_issues":155,"watchers":20,"default_branch":"master"}},"base":{"label":"Particular:master","ref":"master","sha":"a0d3272e19a9d58824c659dc974ac34775cda639","user":{"login":"Particular","id":5038441,"avatar_url":"https://avatars.githubusercontent.com/u/5038441?v=3","gravatar_id":"","url":"https://api.github.com/users/Particular","html_url":"https://github.com/Particular","followers_url":"https://api.github.com/users/Particular/followers","following_url":"https://api.github.com/users/Particular/following{/other_user}","gists_url":"https://api.github.com/users/Particular/gists{/gist_id}","starred_url":"https://api.github.com/users/Particular/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Particular/subscriptions","organizations_url":"https://api.github.com/users/Particular/orgs","repos_url":"https://api.github.com/users/Particular/repos","events_url":"https://api.github.com/users/Particular/events{/privacy}","received_events_url":"https://api.github.com/users/Particular/received_events","type":"Organization","site_admin":false},"repo":{"id":11727301,"name":"docs.particular.net","full_name":"Particular/docs.particular.net","owner":{"login":"Particular","id":5038441,"avatar_url":"https://avatars.githubusercontent.com/u/5038441?v=3","gravatar_id":"","url":"https://api.github.com/users/Particular","html_url":"https://github.com/Particular","followers_url":"https://api.github.com/users/Particular/followers","following_url":"https://api.github.com/users/Particular/following{/other_user}","gists_url":"https://api.github.com/users/Particular/gists{/gist_id}","starred_url":"https://api.github.com/users/Particular/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Particular/subscriptions","organizations_url":"https://api.github.com/users/Particular/orgs","repos_url":"https://api.github.com/users/Particular/repos","events_url":"https://api.github.com/users/Particular/events{/privacy}","received_events_url":"https://api.github.com/users/Particular/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Particular/docs.particular.net","description":"Contains all the content for the Particular documentation site","fork":false,"url":"https://api.github.com/repos/Particular/docs.particular.net","forks_url":"https://api.github.com/repos/Particular/docs.particular.net/forks","keys_url":"https://api.github.com/repos/Particular/docs.particular.net/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Particular/docs.particular.net/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Particular/docs.particular.net/teams","hooks_url":"https://api.github.com/repos/Particular/docs.particular.net/hooks","issue_events_url":"https://api.github.com/repos/Particular/docs.particular.net/issues/events{/number}","events_url":"https://api.github.com/repos/Particular/docs.particular.net/events","assignees_url":"https://api.github.com/repos/Particular/docs.particular.net/assignees{/user}","branches_url":"https://api.github.com/repos/Particular/docs.particular.net/branches{/branch}","tags_url":"https://api.github.com/repos/Particular/docs.particular.net/tags","blobs_url":"https://api.github.com/repos/Particular/docs.particular.net/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Particular/docs.particular.net/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Particular/docs.particular.net/git/refs{/sha}","trees_url":"https://api.github.com/repos/Particular/docs.particular.net/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Particular/docs.particular.net/statuses/{sha}","languages_url":"https://api.github.com/repos/Particular/docs.particular.net/languages","stargazers_url":"https://api.github.com/repos/Particular/docs.particular.net/stargazers","contributors_url":"https://api.github.com/repos/Particular/docs.particular.net/contributors","subscribers_url":"https://api.github.com/repos/Particular/docs.particular.net/subscribers","subscription_url":"https://api.github.com/repos/Particular/docs.particular.net/subscription","commits_url":"https://api.github.com/repos/Particular/docs.particular.net/commits{/sha}","git_commits_url":"https://api.github.com/repos/Particular/docs.particular.net/git/commits{/sha}","comments_url":"https://api.github.com/repos/Particular/docs.particular.net/comments{/number}","issue_comment_url":"https://api.github.com/repos/Particular/docs.particular.net/issues/comments{/number}","contents_url":"https://api.github.com/repos/Particular/docs.particular.net/contents/{+path}","compare_url":"https://api.github.com/repos/Particular/docs.particular.net/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Particular/docs.particular.net/merges","archive_url":"https://api.github.com/repos/Particular/docs.particular.net/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Particular/docs.particular.net/downloads","issues_url":"https://api.github.com/repos/Particular/docs.particular.net/issues{/number}","pulls_url":"https://api.github.com/repos/Particular/docs.particular.net/pulls{/number}","milestones_url":"https://api.github.com/repos/Particular/docs.particular.net/milestones{/number}","notifications_url":"https://api.github.com/repos/Particular/docs.particular.net/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Particular/docs.particular.net/labels{/name}","releases_url":"https://api.github.com/repos/Particular/docs.particular.net/releases{/id}","deployments_url":"https://api.github.com/repos/Particular/docs.particular.net/deployments","created_at":"2013-07-28T23:18:15Z","updated_at":"2016-02-19T18:24:25Z","pushed_at":"2016-03-22T15:20:36Z","git_url":"git://github.com/Particular/docs.particular.net.git","ssh_url":"git@github.com:Particular/docs.particular.net.git","clone_url":"https://github.com/Particular/docs.particular.net.git","svn_url":"https://github.com/Particular/docs.particular.net","homepage":"http://docs.particular.net","size":46419,"stargazers_count":20,"watchers_count":20,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":108,"mirror_url":null,"open_issues_count":155,"forks":108,"open_issues":155,"watchers":20,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/Particular/docs.particular.net/pulls/1324"},"html":{"href":"https://github.com/Particular/docs.particular.net/pull/1324"},"issue":{"href":"https://api.github.com/repos/Particular/docs.particular.net/issues/1324"},"comments":{"href":"https://api.github.com/repos/Particular/docs.particular.net/issues/1324/comments"},"review_comments":{"href":"https://api.github.com/repos/Particular/docs.particular.net/pulls/1324/comments"},"review_comment":{"href":"https://api.github.com/repos/Particular/docs.particular.net/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/Particular/docs.particular.net/pulls/1324/commits"},"statuses":{"href":"https://api.github.com/repos/Particular/docs.particular.net/statuses/e0593f00a6efc65432a2e2a96cbba736baed3df4"}}}}