You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/relational-databases/replication/non-sql/non-sql-server-subscribers.md
+4-4Lines changed: 4 additions & 4 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
title: "Non-SQL Server Subscribers | Microsoft Docs"
3
3
ms.custom: ""
4
-
ms.date: "0/29/2017"
4
+
ms.date: "08/29/2017"
5
5
ms.prod: "sql-server-2016"
6
6
ms.reviewer: ""
7
7
ms.suite: ""
@@ -65,9 +65,9 @@ For information about creating subscriptions to Oracle and IBM DB2, see [Oracle
65
65
66
66
- When creating a publication in the New Publication Wizard and then enabling it for non-SQL Server Subscribers using the Publication Properties dialog box, the owner of all objects in the subscription database is not specified for non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers, whereas for [!INCLUDE[msCoName](../../../includes/msconame-md.md)][!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers, it is set to the owner of the corresponding object in the publication database.
67
67
68
-
- If a publication will have[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers and non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers, the publication must be enabled for non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers before any subscriptions to [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers are created.
68
+
- If a publication has[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers and non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers, the publication must be enabled for non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers before any subscriptions to [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers are created.
69
69
70
-
- By default, scripts generated by the Snapshot Agent for non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers use non-quoted identifiers in the CREATE TABLE syntax. Therefore, a published table named 'test' is replicated as 'TEST'. To use the same case as the table in the publication database, use the **-QuotedIdentifier** parameter for the Distribution Agent. The **-QuotedIdentifier** parameter must also be used if published object names (such as tables, columns, and constraints) include spaces or words that are reserved words in the version of the database at the non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscriber. For more information about this parameter, see [Replication Distribution Agent](../../../relational-databases/replication/agents/replication-distribution-agent.md).
70
+
- By default, scripts generated by the Snapshot Agent for non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscribers use non-quoted identifiers in the `CREATE TABLE` syntax. Therefore, a published table named 'test' is replicated as 'TEST'. To use the same case as the table in the publication database, use the **-QuotedIdentifier** parameter for the Distribution Agent. The **-QuotedIdentifier** parameter must also be used if published object names (such as tables, columns, and constraints) include spaces or words that are reserved words in the version of the database at the non-[!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Subscriber. For more information about this parameter, see [Replication Distribution Agent](../../../relational-databases/replication/agents/replication-distribution-agent.md).
71
71
72
72
- The account under which the Distribution Agent runs must have read access to the install directory of the OLE DB provider.
73
73
@@ -77,7 +77,7 @@ For information about creating subscriptions to Oracle and IBM DB2, see [Oracle
77
77
78
78
- For IBM DB2, the database is specified in the DB2 connection string. For more information, see [Create a Subscription for a Non-SQL Server Subscriber](../../../relational-databases/replication/create-a-subscription-for-a-non-sql-server-subscriber.md).
79
79
80
-
- If the [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Distributor is running on a 64bit platform, you must use the 64bit version of the appropriate OLE DB provider.
80
+
- If the [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Distributor is running on a 64-bit platform, you must use the 64-bit version of the appropriate OLE DB provider.
81
81
82
82
- Replication moves data in Unicode format regardless of the collation/code pages used on the Publisher and Subscriber. It is recommended that you choose a compatible collation/code page when replicating between Publishers and Subscribers.
0 commit comments