469,632 Members | 1,590 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

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 1864

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
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.