471,852 Members | 1,226 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,852 software developers and data experts.

SQL Server replication with existing data on one server

General Brief:
3 SQL Servers as MS SQL Server 2000 Standard Edition with Service
Pack 3
All using FTP for snapshots
All Servers are both Publishers and Distributors.
Server A has the correct data needed to be replicated to Server B
and C.
Server B and C and have blank data.
Server B and C are blank databases ready for replication.
Server A publishers to Server B and Server C
Server A subscribes from Server B and Server C
Server B publishes to and subscribes from only Server A
Server C publishes to and subscribes from only Server A
Each table for replication is set with a constraint on the Primary
key
allowing its own predetermined range values.

I have managed to do SQL replication using either transactional or
Merge Publication without any data in all servers. I would prefer to
use transactional.

The Problem:
As the data exists in only Server A I am unable to get that data
to Server
C and B with there different predetermined range values for the
primary keys.
I can get the data to be replication by allowing the tables in Server
B and C
to be dropped before the data is inserted. The table on Server B and C
gets
recreated with the wrong predetermined range values for the primary
keys.

I think I am doing something wrong with the init snapshot.

Server A
Table email
Primary Key ID
with range 1 to 500,000,000)

Server B
Table email
Primary Key ID
with range 500,000,001 to 1,000,000,000)

Server C
Table email
Primary Key ID
with range 1,000,000,000 to 1,500,000,000)

I would be gratefully if any can point me in the right direction.

Thank You

Philip Trim
Jul 20 '05 #1
0 1928

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Dan Williams | last post: by
14 posts views Thread by diskoduro | last post: by
3 posts views Thread by dlesandrini | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.