Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Replication (2005)  SQL Server 2005 to Oracle 10G replication issue

Author  Topic  AzimLog Starting Member 1 Post Posted - 2007-11-29 : 06:19:53 Hi everyone, I am working on SQL Server 2005 to Oracle10g replcation (Transactionl). All is working well on both end except with SQL server tables where either table name or column name used is an Oracle reserved word. According SQL BOL "By default, scripts generated by the Snapshot Agent for non-SQL Server 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-SQL Server Subscriber" Can any body tell me how this parameter is used and what value should one assign to this parameter. If someone have some other alternatives please share this too. Thanks in advance Azim