Different Schema

Hi Is it possible to use SQL 2000 replication with two databases that
have different schema.
At the momenet I am using scheduled scripts to create export files ,
ftp them and then import them, its complex and I need a better way.
Thanks.
Yes - you could use transactional replication with
(a) Transformable subscriptions (DTS integration)
(b) Indexed Views on the publisher
(c) a custom sync object on the publisher
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thanks - in terms of failover and recovery if either server goes down
or if theres poor connectivity , is a) or c) the better solution ?
Paul Ibison wrote:
> Yes - you could use transactional replication with
> (a) Transformable subscriptions (DTS integration)
> (b) Indexed Views on the publisher
> (c) a custom sync object on the publisher
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||(c) would be less strain on the publisher's transactions and holds more
support going forward to new versions of SQl Server.
However I'm a little confused - in terms of failover it is very strange to
change the schema - normally the apps running on the publisher require the
same tables/fields on the subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .