db1.dbo.table to db2.other.table -- sql server replication

Doug M>
6/19/2007 12:23:02 PM

Hi,

I need help/guidance setting up replication across dbs.

db1 has the same tables as db2. tables have the same fields.

db1 has "dbo.table" schema, db2 has "other.table" schema.

I setup simple replication and db1.dbo.tables are being added to db2 as
db2.dbo.tables instead of just refreshing data on db2.other.tables....

Any help would be greatly appreciated.

Hilary Cotter
6/20/2007 7:48:56 AM

http://www.dbazine.com/sql/sql-articles/cotter1

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : db1.dbo.table to db2.other.table