Re: Programatically create replication publication?

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.

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



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


--------------------
>From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
>References: <OXitg7E9FHA.3020@xxxxxxxxxxxxxxxxxxxx>
>Subject: Re: Programatically create replication publication?
>Date: Mon, 28 Nov 2005 19:31:30 -0000
>Lines: 13
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uT77YJF9FHA.3880@xxxxxxxxxxxxxxxxxxxx>
>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
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>
>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)
>
>
>

.

Relevant Pages

  • Re: Replication and secure off-site servers
    ... As I know, there are some improvments in replication in such as management, ... I suggest that you go to SQL 2005 beta newsgroup ... Microsoft Online Partner Support ...
    (microsoft.public.sqlserver.replication)
  • MS03-031 patch for Named pipes denial of service bug
    ... Server post SP3 Cumulative Patch. ... It brings the SQL Level up to 8.0.818. ... Microsoft has dropped the ball on this one, and I have reported it to ... asynchronous, real-time replication, to deliver disaster recovery, data ...
    (NT-Bugtraq)
  • Re: Crosstab with SQL Backend Problem
    ... Whom have you talked to at Microsoft? ... When I set-up the SQL Databse as the Back-end and Access 2007 as the ... somebody must have led you to believe that programming for SQL ... Please reply to the newsgroup. ...
    (microsoft.public.access.queries)
  • RE: SQL CE merge replication erros
    ... perform update action during the merge replication process. ... SQL Server CE merge replication. ... Customer Support Services for the best support of mobile related ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.replication)
  • SQL Training Recommendations?
    ... OS/400 environments that I need to get up to speed on SQL programming. ... This wouldn't be the typical Admin training courses, ... Microsoft 2073 course might be only a portion ...
    (microsoft.public.sqlserver.programming)