vaidyanathanpc
Programmer
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
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