Order for applying the snapshot

Order for applying the snapshot

Post by MSPL » Wed, 29 May 2002 17:06:45



Hai,
I would like to know weather we can specify the order in which to apply the
snapshot.

Thank you in advance

Sheshadri

 
 
 

Order for applying the snapshot

Post by Raj Gil » Thu, 30 May 2002 17:58:54


It is based on the order in which you add the articles.


Quote:> Hai,
> I would like to know weather we can specify the order in which to apply
the
> snapshot.

> Thank you in advance

> Sheshadri


 
 
 

Order for applying the snapshot

Post by Konstantin Krivtso » Sat, 01 Jun 2002 18:09:53


This is incorrect, at least fo merge replication.
Order of snapshot is calculated when snapshot agent run based on the
information in sysdepends table.
There are, however, some troubles with sysdepends in SQL2K see  here:

You can manually alter snapshot order by updating values of the field
schemaversion in the sysmergeschemachange table after the snapshot was
generated.

IMPORTANT: This method isn't supported by MS, so use it at your own risk.


> It is based on the order in which you add the articles.



> > Hai,
> > I would like to know weather we can specify the order in which to apply
> the
> > snapshot.

> > Thank you in advance

> > Sheshadri