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 |
|
jerry1027
Starting Member
1 Post |
 Posted - 2004-09-23 : 22:12:34
|
| I have created a transactional replication from server1 db to server2 db. Everything was fine when I keep the destination table name same as the source. However when I configure the replication to change the destination table name , the error Foreign key FK_VesselPort references invalid table VesselMaster. encounter. How can I replicate two related tables to a new table name in server2 and to avoid the FK reference error? e.g. VesselMaster replicate to WS_VesselMaster and VesselPort replicate to WS_VesselPortI am a dreamer but I am not the only one |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-24 : 01:59:39
|
in the snapshot properties, you could uncheck the one for inclusion of referential integrity.  |
 |
|
|
|
|
|
SQL transactional replication problem