Showing posts with label synchronization. Show all posts
Showing posts with label synchronization. Show all posts

Tuesday, February 21, 2012

Replication: Synchronization Status

In SQL 2005 when i expand the local publication , Under replication when i try to view Synchronization Status i see the below message.

The initial snapshot for publication '%Database' is not yet available.

can any one help me on this issue.

Thanks

You can open the replication monitor, go under this publication, go to the other agents tab, and start snapshot.|||This is because initial snapshot for the publication has not been generated. So generate snapshot first.

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
Rob
Standard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>
|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>
|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
Rob
Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
RobStandard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>>I have a requirement to implement replication between SQL Server and MSDE
>>on client machines. Problem is we cannot ask our customers to purchase
>>SQL Server Enterprise Edition, so we are left with the buy vs build
>>scenario.
>> Can anyone recommend any components or vendors that offer this
>> functionality? Royalty free licensing is a must.
>> Thanks in advance.
>> Rob
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
RobStandard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>