Re: Replicate between SQL and Access
- From: "Earl" <brikshoe@xxxxxxxxxxxxxxxxx>
- Date: Mon, 27 Jun 2005 21:34:49 -0500
Thanks Hilary. Is transforming the data during replication a common
technique? For example, one database has non-normalized fields such as
complete addresses, full names and such.
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:Oj8ueL2eFHA.1612@xxxxxxxxxxxxxxxxxxxxxxx
> try to create a indexed view that looks like your access table and then
> replicate that.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Earl" <brikshoe@xxxxxxxxxxxxxxxxx> wrote in message
> news:O19uUN1eFHA.2420@xxxxxxxxxxxxxxxxxxxxxxx
>>I want to replicate between an SQL2k database and an Access database.
>>Unfortunately, the field structures are not identical and neither one can
>>be changed. How best to handle this scenario?
>>
>
>
.
- References:
- Replicate between SQL and Access
- From: Earl
- Re: Replicate between SQL and Access
- From: Hilary Cotter
- Replicate between SQL and Access
- Prev by Date: Re: Replicate between SQL and Access
- Next by Date: Re: Ran out of identity range
- Previous by thread: Re: Replicate between SQL and Access
- Next by thread: Transaction Replication, Help!
- Index(es):
Relevant Pages
|
