replication with only 1 server

  • Hi,

    I want to experiment replication or the fisrt time

    Question 1:

    Is it possible to build replication if I only have 1 server ?

    Question 2:

    Is it possible to build replication on an XP Home edition with SQL Server 2008 Enterprise edition RTM (evaluation full copie) ?

    Thank you

    Joyeuses Fêtes

    calico

  • Hi,

    Answer 1:

    Yes you can create replication even with 1 server.

    This server will act as its own distributor.

    You can subscribe for the publication, which is created in this server itself, to complete the replication setup. Choose the destination database accordingly.

    Cheers

    John

  • Answer 2:

    Yes, it is doable.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply