MSDE and replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TM - 31 Oct 2006 16:26 GMT

Does anyone know if MSDE can use replication of any kind? I'm looking to
gather up many tiny databases and pull them into a larger 2000 box that is
Processor licensed.

I read that you can set up replication manually using scripts, but the
document didn't go into much detail.

Reply to this Message

Paul Ibison - 31 Oct 2006 16:32 GMT

Yes - but like Personal Edition it can't be a Transactional Publisher.
You can set up replication entirely from scripts - the easiest solution is
to set up a dummy subscriber using EM and then script it out. Edit the
script then apply it to the MSDE instance.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message

TM - 31 Oct 2006 16:48 GMT

Great. Thanks for the quick response. I'll have to give it a try! I like
the idea of scripting it out. I have about 100 instances to do and that
will save a great deal of time.

> Yes - but like Personal Edition it can't be a Transactional Publisher.
> You can set up replication entirely from scripts - the easiest solution is
> to set up a dummy subscriber using EM and then script it out. Edit the
> script then apply it to the MSDE instance.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message