I need transactional replication to replicate data between a database with a
collation of SQL_Latin1_General_CP1_CI_AS and another with
Latin1_General_BIN. Can this be done with any explicit conversion?
Reading the BOL and searching the internet yeilded no definitive answer.
Grant,
in the article preoprties (elipsis button) you will find the checkbox that
allows you to use the collation of the published column rather thanthe
default database collation on the subscriber.
HTH,
Paul Ibison
"Grant Marlow" <gmarlow@.yahoo.com> wrote in message
news:5aKXc.5738$ZC7.3697@.newssvr19.news.prodigy.co m...
> I need transactional replication to replicate data between a database with
a
> collation of SQL_Latin1_General_CP1_CI_AS and another with
> Latin1_General_BIN. Can this be done with any explicit conversion?
> Reading the BOL and searching the internet yeilded no definitive answer.
>
Showing posts with label acollation. Show all posts
Showing posts with label acollation. Show all posts
Sunday, March 25, 2012
Subscribe to:
Posts (Atom)