Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2002-07-08 : 08:21:48
|
| Hi, I am trying to replicate a database from one server to another server. 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 replicate the data from DB1 onto DB2 ( Transactional Replication), I'm getting an error during replication. we are getting an error "Unable to drop table due to foreign key constraints". Is it possible to replicate data from one database to another identicaldatabase which has all the constraints and relationships that are there on the publication database? Thanks in advance |
|
|
|
|
|
Replication with constraints