Groups | Blog | Home
all groups > sql server (alternate) > july 2006 >

sql server (alternate) : 2005 Express: testing replication


R.A.M.
7/7/2006 12:00:00 AM
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
Helmut Woess
7/7/2006 2:55:16 PM
Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:

[quoted text, click to view]

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.

R.A.M.
7/7/2006 4:05:09 PM
On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@inode.at>
[quoted text, click to view]

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

/RAM/
Helmut Woess
7/7/2006 7:54:13 PM
Am Fri, 07 Jul 2006 16:05:09 +0200 schrieb R.A.M.:

....
[quoted text, click to view]

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.

Greg D. Moore (Strider)
7/8/2006 12:40:59 AM

[quoted text, click to view]

No.


[quoted text, click to view]

AddThis Social Bookmark Button