2005 Express: testing replication

[R.A.M.]

Hello,
I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got error: "There are no
publications to which you can subscribe, either because this server
has no publications or because you do not have sufficient privileges
to access the publications."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/

[Helmut Woess]

Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:

Hello,
I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got error: "There are no
publications to which you can subscribe, either because this server
has no publications or because you do not have sufficient privileges
to access the publications."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/

SQLExpress can use Replication, but only as subscriber. And your message
says, SQLExpress cannot access the publisher. Do you have a publisher
running? Publisher cannot be done with SQLExpress.

bye, Helmut

[R.A.M.]

On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <us****@inode.at>
wrote:

>Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:

>Hello,
I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got error: "There are no
publications to which you can subscribe, either because this server
has no publications or because you do not have sufficient privileges
to access the publications."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/

SQLExpress can use Replication, but only as subscriber. And your message
says, SQLExpress cannot access the publisher. Do you have a publisher
running? Publisher cannot be done with SQLExpress.

bye, Helmut

thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?

/RAM/

[Helmut Woess]

Am Fri, 07 Jul 2006 16:05:09 +0200 schrieb R.A.M.:

....

BTW, is Replication and Data Mirroring the same thing?

/RAM/

Hmm, i am no expert for this. As much as i know is, that data mirroring
means it happens in real time, so you can switch with no delay from one
server to the other one. Replikation goes in intervals, between the
intervals data between the two databases is different. But i am not sure if
this is the right definition.

bye, Helmut

[Greg D. Moore \(Strider\)]

"R.A.M." <r_********@poczta.onet.plwrote in message
news:v7********************************@4ax.com...

On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <us****@inode.at>
wrote:

thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?

No.

>
/RAM/