Re: Push subscription: "schema and data"

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Robert A. DiFrancesco (bob.difrancesco_at_comcash.com)
Date: 07/13/04 

Date: Mon, 12 Jul 2004 17:12:36 -0700

Thank you very much.
Just so that I am very clear, if I had made a manual change to the database
(not using the sp's you have pointed out) and I push out the subscription
without the database and schema because there is an existing database, then
the structure change would NOT replicate. Is this correct?

Thank you.

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:OTqXliGaEHA.2516@TK2MSFTNGP10.phx.gbl...
> Use the sp_repladcolumn and sp_repldropcolumn stored procedures to
replicate
> schema changes for existing publications with subscriptions.
>
> When you get the message - push schema and data, the schema does refer to
> the table (and other objects) creation scripts - or as you put it database
> structure.
>
> "Robert A. DiFrancesco" <bob.difrancesco@comcash.com> wrote in message
> news:eHTYxKGaEHA.3708@TK2MSFTNGP10.phx.gbl...
> > If I make a database-structure change on the Publisher, will the
structure
> > change replicate to the Subscriber (and update the structure there) ?
> >
> > When pushing a new subscription, the wizard prompts if you would like to
> > push schema and data. Does 'schema' mean ... the database structure?
> >
> > Thank you,
> > Bob
> >
> >
>
>

Relevant Pages

  • Selective Replication
    ... Have two schemas in the same database. ... used for currents an A_HIST is used to capture ... Using Triggers on 20 tables in A to replicate ... and have flexibility of possibly have the A_HIST schema in a different ...
    (comp.databases.oracle.server)
  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)
  • Split messages
    ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
    (microsoft.public.biztalk.general)
  • Re: Decouple SQL queries from class in OOP design
    ... > Of course there are existing applications that uses many different ... > architectures and still provides measurable business value. ... > should access every database directly. ... by the database, but the schema changes. ...
    (comp.object)
  • ANN: Sequel 2.8.0 Released
    ... Sequel provides thread safety, connection pooling and a concise DSL ... for constructing database queries and table schemas. ... if you want to, but the results and API are adapter dependent, ... Model associations, getting the schema, joins, and many other ...
    (comp.lang.ruby)