Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question on Replication

Status
Not open for further replies.

vaidyanathanpc

Programmer
Joined
Nov 30, 2001
Messages
36
Location
IN
Hi,
We are trying to replicate a database on one server to another server. The situation is
as follows :
Our publication database is DB1. We restored this database on another server with all the data and relationships and constraints as database DB2. Now when I tried to replicated the data from DB1 onto DB2 (Snapshot as well as Transactional Replication), I'm getting an error during replication. I think for transactional replication, any new inserts, updates or deletes on tables on DB1 should be reflected on DB2 when DB1 is replicated on to DB2 but we are getting an error "Unable to drop table due to foreign key constraints".
When we tried to replicate DB1 without restoring the database on the subscriber server, the data from DB1 was replicated on the subscriber server minus the constraints and relationships among the tables.
Is it possible to replicate data from one database to another identical database which has all the constraints and relationships that are there on the publication database?

Thanks in advance
P.C. Vaidyanathan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top