SQL Server's Data can be replicated to MSDE 2000 ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harsha Shah - 02 Jul 2005 10:49 GMT

Hello,

I have SQL Server 2000 on window Server 2003, I have a laptop client with
Win XP , I want to install MSDE 2000 on this client and keep weekly updated
with Server. Is it possible ,
If yes, How ?
or any other alternate.

Any hint will be sincerly appreciated..

Harsha.

Reply to this Message

Colin Dawson - 02 Jul 2005 21:17 GMT

I don't think that MSDE support replication, but..... you could always
restore a backup of your database to your laptop. That'll work.

> Hello,
>
[quoted text clipped - 8 lines]
>
> Harsha.

Reply to this Message

Paul Ibison - 02 Jul 2005 21:54 GMT

I agree that backup and restore, DTS, BCP, Linked servers are all potential
alternatives but replication is indeed supported in MSDE, just not
Transactional Publishing.
Rgds,
Paul Ibison

>I don't think that MSDE support replication, but..... you could always
>restore a backup of your database to your laptop. That'll work.
[quoted text clipped - 11 lines]
>>
>> Harsha.

Reply to this Message