Programatically create replication publication?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tery - 28 Nov 2005 19:06 GMT

Is it possible to create a publication entirely from within my application?

If so, are there some samples or documentation anyone can point me to?

Thanks in advance,
Terry

Reply to this Message

Paul Ibison - 28 Nov 2005 19:31 GMT

Terry,
please have a look at the SQLDMO and ActiveX scripts on this page:
http://www.replicationanswers.com/Scripts.asp.
Also, you might want to investigate creating a replication setup in a test
environment, having enterprise amnager script out the setup, modifying it
then using this as a starting point for your setup. This would achieve the
same ends, but be entirely in TSQL.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

Peter Yang [MSFT] - 29 Nov 2005 06:32 GMT

Hello Terry,

If you are using SQL 2005, you may need to consider RMO

Programming with Replication Management Objects
http://msdn2.microsoft.com/en-us/library/ms146869.aspx

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

>From: "Paul Ibison" <Paul.Ibison@Pygmalion.Com>
>References: <OXitg7E9FHA.3020@TK2MSFTNGP09.phx.gbl>
[quoted text clipped - 9 lines]
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: 82-43-215-101.cable.ubr10.newm.blueyonder.co.uk

82.43.215.101

>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:67037
[quoted text clipped - 11 lines]
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)

Reply to this Message

Tery - 29 Nov 2005 14:55 GMT

Thanks guys ...

Your suggestions look like my answers.

Tery

> Hello Terry,
>
[quoted text clipped - 47 lines]
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)

Reply to this Message

Peter Yang [MSFT] - 30 Nov 2005 01:35 GMT

Hello Terry,

My pleasure! :-)

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

>From: "Tery" <justme@noemail.noemail>
>References: <OXitg7E9FHA.3020@TK2MSFTNGP09.phx.gbl>

<uT77YJF9FHA.3880@TK2MSFTNGP12.phx.gbl>
<HNKee6K9FHA.4000@TK2MSFTNGXA02.phx.gbl>

>Subject: Re: Programatically create replication publication?
>Date: Tue, 29 Nov 2005 08:55:11 -0600
[quoted text clipped - 7 lines]
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: dsl-201-155-245-16.prod-empresarial.com.mx

201.155.245.16

>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:67058
[quoted text clipped - 57 lines]
>>> (recommended sql server 2000 replication book:
>>> http://www.nwsu.com/0974973602p.html)

Reply to this Message