By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,742 Members | 793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,742 IT Pros & Developers. It's quick & easy.

SQL Server replication with existing data on one server

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.