SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:51 PM
| ||||
| ||||
 2005 Express: testing replication 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/      |
|
02-29-2008, 07:51 PM
| |||
| |||
| Re: 2005 Express: testing replication 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 |
|
02-29-2008, 07:51 PM
| |||
| |||
| Re: 2005 Express: testing replication On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@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/ |
|
02-29-2008, 07:52 PM
| |||
| |||
| Re: 2005 Express: testing replication 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 |
|
02-29-2008, 07:52 PM
| ||||
| ||||
| Re: 2005 Express: testing replication "R.A.M." <r_ahimsa_m@poczta.onet.pl> wrote in message news:v7qsa2tmij36hi65heqv02j8p52t59nesi@4ax.com... > On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@inode.at> > wrote: > > thank you > no, I have only Express Edition. > pity. > BTW, is Replication and Data Mirroring the same thing? No. > > /RAM/ > |
Linear Mode
