Replicating the schema while preserving existing data
- From: "Marc Deskins" <marcdeskins@xxxxxxxxxxx>
- Date: Wed, 13 Apr 2005 06:58:53 -0700
Hello All,
Here is my situation:
I have a core database that is used to define the schema
of a client-owned database for use with some software. As
the software evolves and changes so too will the schema of
the core database. Ideally these changes should be
propogated down to the client-owned database;altering the
schema to match the new core version without destroying
the data that may already exists.
My attempts to use replication for this have failed when I
perform the following:
-The core database has a single table with three fields.
-The client database has nothing.
*I configure and activate replication
- Now the client database has an identical copy of the
table from the core database.
*I make changes to the core database schema by adding
three more fields to the table.
- Now the client database and core database have
differeing schemas.
*I add data to the client database table.
*I initiate replication from the core to the client
database expecting my three new fields to be appended to
the table without destroying my existing data.
-I don't get what I expect, instead I get a the original
three field table that was first replicated into the
client database and the data is missing.
How can I replicate a schema change from one database into
another without destroying any of the data that may
already exist on the target database?
Thanks,
Marc Deskins
marcdeskins@xxxxxxxxxxx
.
- Follow-Ups:
- Re: Replicating the schema while preserving existing data
- From: Paul Ibison
- Re: Replicating the schema while preserving existing data
- Prev by Date: Re: Merge Metadata Cleanup
- Next by Date: Re: Replicating the schema while preserving existing data
- Previous by thread: Multiple Publications into single subscriber database
- Next by thread: Re: Replicating the schema while preserving existing data
- Index(es):
Relevant Pages
|
