Hi,
I am writing C# application accessing 2 databases. One them is publisher
and replicates two of its tables to the other (transactional replication). I
know that replication can either be immediate or scheduled, but is there any
way to perform replication on demand (from my c# app), for instance
executing some sql statement?!
Piotrek
have a look at the initialize and run methods using the activeX controls.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Piotrek Stachowicz" <dynamite@.poczta.onet.pl> wrote in message
news:cdlqsg$r30$1@.news.onet.pl...
> Hi,
> I am writing C# application accessing 2 databases. One them is
publisher
> and replicates two of its tables to the other (transactional replication).
I
> know that replication can either be immediate or scheduled, but is there
any
> way to perform replication on demand (from my c# app), for instance
> executing some sql statement?!
> Piotrek
>
|||Hi,
> have a look at the initialize and run methods using the activeX
controls.
Could you be a slightly more specific (some msdn reference perhaps?). I'm
new to the topic, and I am not quite sure what you mean.
Thanks,
Piotrek
|||here is a code sample of what I am talking about
http://support.microsoft.com/default...&Product=sql2k
For more info on the actual methods have a look at
http://msdn.microsoft.com/library/de...bjcol_00j8.asp
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Piotrek Stachowicz" <dynamite@.poczta.onet.pl> wrote in message
news:cdnrb9$t9f$1@.news.onet.pl...
> Hi,
> controls.
> Could you be a slightly more specific (some msdn reference perhaps?). I'm
> new to the topic, and I am not quite sure what you mean.
> Thanks,
> Piotrek
>
>
Friday, March 9, 2012
replication on demand
Labels:
accessing,
application,
database,
databases,
demand,
microsoft,
mysql,
oracle,
publisherand,
replicates,
replication,
server,
sql,
tables,
transactional,
writing
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment